VB OracleTransaction Not Rolling Back

Sep 14, 2010

I'm calling a third party stored procedure in Oracle from VB that is not rolling back.

Code first (I'm simplifying):

Connection string:
String sqlstr = "SERVER=x.x.x.x;Database=db;uid=sa;pwd=admin;Connect Timeout=60; Min Pool Size=5; Max Pool Size=100;";

The call (I've just forced a rollback immediately after the execute to test it):

Dim Oraclecon As New OracleConnection(_OracleConnection)
Dim sqlCon As New SqlConnection(_SQLConnection)
Dim oTrans As OracleTransaction = Nothing

[Code.....

I can't give the details of the stored procedure but it does a commit and rollback inside it.

Either way, it is doing an insert, and that immediate rollback does not rollback the insert.

View 2 Replies


ADVERTISEMENT

Rolling Back A Transaction With MySQL Connector?

Mar 23, 2011

I have one multi-row INSERT statement (300 or so sets of values) that I would like to commit to the MySQL database in an all-or-nothing fashion. insert into table VALUES

(1, 2, 3),
(4, 5, 6),
(7, 8, 9);

In some cases, a set of values in the command will not meet the criteria of the table (duplicate key, for example). When that happens I do not want any of the previous sets added to the database. I've implemented this with the following code, however, my rollback command doesn't appear to be making a difference. I've used this documentation: http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqltransaction.html

Dim transaction As MySqlTransaction = sqlConnection.BeginTransaction()
sqlCommand = New MySqlCommand(insertStr, sqlConnection, transaction)
Try

[code]....

I get the DUPLICATE KEY exception thrown, no Rollback Exception thrown, and every set of values up to duplicate key committed to the database.

View 1 Replies

Setup Is Not Rolling Back If Condition If False

Jun 11, 2011

if one installer class in my project and in custom action doing some procedure to validate the serial key using user interface editor during setup creation. while installing the set up if the condition is not true the setup in rolling back it is installing.

[Code]...

View 1 Replies

Sql Server - Rolling Back Entity Framework Transaction, Cached Item Persist?

Aug 23, 2011

I'm using an Entity Framework context, and sometimes would like to create a transaction so that the client can do multiple changes and then commit/rollback them all together.However, if many changes were made, and SaveChanges() was called multiple times, after which a rollback is called, entities that were commited already, will remain the way they were commited, and would not roll back.Here's how my transaction-relative functions look like:

Public Sub BeginTransaction()
Dim context = HttpContext.Current.GetObjectContext()
If Not context.Connection.State = ConnectionState.Open Then
context.Connection.Open()
End If

[Code]...

Not only does the test fail, but it also leave the ObjectContext in an unstable mode, because it still has invalid changes in it.

View 1 Replies

Error With Rolling A Dice

Oct 31, 2011

I'm trying to create a game that involves rolling a dice. When I load the program and click the btnRoll button, the dice works fine and stops after a random number (between 10 and 20) of face changes. It then records the score in the a new line in a ListBox. Only problem is, when I press the roll button again, the face only changes once before recording the result.

I have tried creating a separate program that simply rolls the dice without recording the result, and it works fine. So I used roughly the same code in my game, but it still won't work. I have tried looking online for help for a few days now, so I figured this would be a good time to ask here.[code]...

View 8 Replies

How To Create A Rolling Percentage From A Log

Apr 7, 2011

I would like to have some sort of percentage on the amount of times each button has been pressede.gButton 1 is pressed 5 times, button 2 is pressed 3 times, button 3 is pressed 2 times.I would like this to create a percentage output onto the same form that is updated everytime a button is pressed on the form.

View 5 Replies

ASP.Net Grid View Rolling Total In Gridview

May 10, 2009

However in my opinion they require a lot of prior knowledge on how to programatically refer to each item.

Does anyone have a link to or can create a relatively basic example of how to achive a running total in the footer for an ASP:Gridview?

View 3 Replies

Calculating The Rolling Average In Crystal Reports?

Jun 17, 2009

I'm trying to calculate the rolling average in a crystal report. I have got 4 weeks in a month, and I have calculated the average for each week so long. Now I want to calculate a rolling average. eg:

For week1: rolling average = (week1Average)/1
For week2: rolling average = (week1Average + week2Average)/2
For week3: rolling average = (week1Average + week2Average + week3Average)/3
etc.

The problem with the code below is that, it is not looping through,therefore the rolling average for each week is the same as its average value wich is not correct.

Dim i, weekNum as number
Dim tot as double
weekNum =Distinctcount({ItemRating.WeekNo})

[Code].....

View 1 Replies

Random Number Generator - Simulating Rolling Of Two Dices

Sep 11, 2011

I have a certain problem with 2 number generators that I have. My problem is that I want them to act individually. To where they seperatly come up with a random number. Mine is from 1-6 for 2 random number to simulate the rolling of two 6 sided dice. The problem that I have is that when I run the program they always generate the same number no matter what that number is. When I step through it step by step while the program is running in the debug screen they come up with a different number. This is in visual basic 2010 express edition.

Private
Sub
Button1_Click(ByVal
sender As
System.Object,
[Code] .....

View 3 Replies

.net - Error When Rolling Out Software Revision To Terminal Sessions Instead Of Desktops?

Nov 15, 2010

I'm doing some maintenance on some software originally built by my predecessor at the company (who has since moved on to greener pastures). I'm currently rolling out a new version of the software. At this company, the installation procedure is basically to just shove the /bin/Release directory out into our automated program updater's magic directory, allowing it to automatically copy the contents of that directory over to the local /Program Files/ and let the magic happen. The magic always seems to happen, so there's no big issue, there, although it does weird me out somewhat, after many years of .msi installers...

[Code]...

View 2 Replies

Data Designers/wizards So Good Now That Rolling Own Is No Longer Worth While?

Apr 9, 2010

Coming form too many years of VB6 I have a natural inclination to write my own data access code, etc. rather than using database wizard, etc. Same goes for using simple databinding to recordset rather than managing object collections and tying those to controls

I am finally moving to VB.NET and find myself on a solo project without any team on which to lean, so I have a couple related questions as I try to get my head around the transition. The project is basically a line of business app with a SQL Server back end.

1. Are the data designers/wizards so good now that rolling your own is no longer worth while?

2. Is the data-binding now fast, flexible, and reliable?

3. Can you recommend a good book or robust on-line tutorial that covers this sort of programming? 2008 or 2010 preferred.

View 1 Replies

Game Programming :: Dice Rolling Program - When Using Rnd Fucntion How To Make It 1-6 Only

Dec 17, 2008

So my question is, I'm wiriting a VERY basic dice rolling program for my computer programming class in high school. I'm using a randomize function to generate numbers but I only want it to do numbers 1 - 6....how do I do this?

Dim x As Integer
Randomize()
x = CInt(10 * Rnd())

Dim Y As Integer
Randomize()
Y = CInt(10 * Rnd())

That is my code for my x and y (each die) to generate code, but how do I make it do 1 - 6 ONLY? Develope a game that in which a player rolls two dice. Each die has 6 faces. Each face contains 1, 2,3,4,5,6 after the dice have come to rest the sum of the spots is calculated, if the sum is 7 or 12 on the first throw, the player wins. If the sum is 2,3, or 11 on the first throw, the player loses, and the house wins. If the sum is 4,5,6,8,9,10 on the first throw the sum becomes the player's point. To win, a player must roll the dice until the plater rolls the point value. The player loses by rolling a 7 before rolling the point. I also have another question, How would I set this up to keep up with points and stuff? and the part that says "The player loses by rolling a 7 before rolling the point." I have no clue what to do on that. I'm not asking for code hand outs. I'm just asking what functions and such I'd use to write the code.

View 6 Replies

Back To The Previous Page On Click Of Custom Back Button?

Aug 25, 2010

I am using an image button and on click of it i want to go to visited page.Now i am using - Response.Redirect(Request.UrlReferrer.ToString()),It is going to previous page, but when i am in a page of some user details where the link is looks like - users.aspx?userid=25 and i visit some other page and click back(image button) i want to see the same userdetail page. How to track that.

View 2 Replies

Passing Back Lisbox Values When Going Back To Previous Page?

Jul 23, 2009

I have a search page with a couple of pulldowns. Dependig on the values of them I show a grid matching the searched criteria, basically a table with links the user can navigate to. My problem comes when the user wants to navigate back. At the moment I have a "Back" button which simply redirects the user to the initial search page. I think it would be a good improvement to have the values of the pulldowns filled in with the values the user selected, this way when he presses the "Back" button he would not have to restart the whole search process again.

View 5 Replies

Get My Toolbox Back To Normal - Can Put It Back On Auto Hide And Such

May 31, 2009

I'm not sure what I did, But I would like to get my toolbox back to normal where I can put it back on auto hide and such.

View 3 Replies

Delay In Back To Back Messages Through Socket

May 10, 2012

We have a server application and a client application that communicates with each other using socket.

When the server application sends 2 messages about 16-31 ms apart, the 1st message is received by the client application with little delay (like 16-32 ms after it was sent). But the 2nd message is received by the client application a lot later (like 200 ms later) than when it was sent.

We already disabled Nagle algorithm (set NoDelay = True) in the socket in both the server and client application.

View 1 Replies

Smtp :: Sending Back To Back Emails?

Jun 17, 2011

We are having problems with sending back to back emails on one of our web sites. The site is built with .net framework 2.0.We can send the first email without any problems on every try. But to send a second email you need to wait about 20-30 minutes.the problem.One thing we tried was changing the smtp email server. We tried a third party smtp server but the same problem persisted. So I think the problem is not with the smtp server but with our .net code.

Imports Microsoft.VisualBasic
Imports System.Net
Imports System.Net.Mail

[code].....

View 1 Replies

Have A Slew Of IF Statements Back To Back?

Mar 2, 2011

I am creating an application that will be faced with multiple decisions to make and I want to know if it is possible to create around 20 if statements to excute or decide between before excuting?

The application will encounter multiple websites but each website will have the same elements but not neccessary in the same order so I was going to tell the app to loop through the IF statement and if the condition is met to run that sub routine where it starts over and loops through the IF statements until next condition is met.

Is this possible in VB.NET or is 20 or so IF statements to many to use at once?[code]...

View 3 Replies

Records Back-to-back In A Msgbox?

Dec 19, 2010

I have a dBase file named PROBA, with two cells: "VNEV", "KNEV".I would like to see the records back-to-back in a Msgbox.

Imports System.Data
Imports System.Data.Odbc
Public Class FormCount1
Public Sub Recordszm() Handles MyBase.Load
'TODO: This line of code loads data into the 'DataSet1.PROBA' table. You can move, or remove it, as needed.

[Code]...

View 4 Replies

Asp.net - Back Reference Link (link Of Back Page)

Dec 18, 2009

i am using this function to get link of page which refered current page (in Back Button)

[Code]...

View 2 Replies

.net Xml To Dataset Back To Xml?

Jul 28, 2009

I recieve a failry complex XML from a web service (30+ tables; with nesting). I need to be able to look a this data; make mods and then pass it back (still well formed per xsd) to the web site. I am able to parse it both natively in XML and by putting it into a dataset. I am more comfortable working in a dataset so thought the best approach for me would be to take the XML to a dataset dsOrder.ReadXml(XMLreader) (also tried with inferschema switch) work with it as required; then using _newXML_str = dsOrder.GetXml

put the dataseet back into xml. This almost works, but the XML while well formed does not adhere to the schema. In particular, it appears that all the simple types for a table are put ahead of the complex types (even thoguh the schema wants some of these items intermixed), so when sent back to the web site, it complains about the order of the tags.

is there a way to get the xml from dataset command to form an xml that will ahdere to the schema? I tried using the available xsd to influence this process but it either doesn't work or I did not know how to apply it properly. If someone has a suggestion for this application I would appreciate comments and any detailed samples that come to hand. I am working in vss 2008; framework 2.0; and use vb.net.

View 2 Replies

Can't Get Back My Project

Jan 17, 2010

I'm working under vb 2008 french version i'll try to translate my problem, hope that u get it right well yesterday i started creating a simple calculator (application windows forms) i did the half work then i save all (Ctrl+Maj+S) . Today i opened the saved file ,i get the Form1.vb page and the Form1.designer, but i cant find the Form1.vb[design] .

View 2 Replies

CSV To Datagridview And Back To Same?

Jul 3, 2009

CSV/Delim Text File To Datagridview, and back.

View 2 Replies

FileDateTime To Get UTC (GMT) Back?

Apr 29, 2012

I have an app that goes out and looks at some files for the Date & Time so that I can compare later for if a newer file is in a directory.However I have seen that between some file copy's, I have files reporting back different time stamps, but in actually the files are the same, and I am assuming the time zone may be off of one of the computers that the file is copied from.How can I make this work correctly? This is what I have, but it still returns the files with the hour off between them and the UTC is changing the time, but still get the hour difference. (Obviously i'm changing the strPattern to whichever directory.I am looking at):

strStamp = FileDateTime(strPattern).ToUniversalTime

is there a different property on the file I should look for? The files belong to a software program, so they are not your typical .txt files or anything.

View 10 Replies

Files Back With VB?

Aug 13, 2010

i need the codes to write a softwrae that will back up files from a computer to a removable disk in vb

View 1 Replies

Get The Code Back From Dll?

Aug 24, 2010

My project is getting lost due to hdd external problem, I am taking a backup every day, so i should be saved, but the problem is I am using a class library I create which exist on another directory, when I try to open it, I saw a lot of strange character look like hex charI have added the class library to my project as new project and as I said before it exist in another a directory outside the project. the last backup i found was in 11 Aug 2010. And i coded a lot in one of the class.

View 6 Replies

Get The Gui Grids Back?

Feb 2, 2010

i'm using vb 2008 and i'm wondering if theres any way to get the gui grids back (like in vb 6) and to turn off/make snap less sensitive..

View 2 Replies

How To Move Back And Forth

Apr 24, 2012

I know that pressing ctrl- will take us to the last place. What about if we want to move forward? Also where in the vb.net documentation is this mentioned?

View 1 Replies

Load RTF Back From DB?

Dec 21, 2009

I am trying to load the Table contents in a .rtf format but It just leaves the rich text box blank thats my code for adding in RTF format which works fine[code]...

View 3 Replies

VB6 Forum Instead.net Back To VB6?

Feb 7, 2011

I found this source code for controlling mappoint in .net .Net confuses me so much.

What would it take to convert it back to VB6? The projects seem small in size, but I just dont understand .net[URL]...

View 7 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved