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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Dec 18, 2009
i am using this function to get link of page which refered current page (in Back Button)
[Code]...
View 2 Replies
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
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
Jul 3, 2009
CSV/Delim Text File To Datagridview, and back.
View 2 Replies
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
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
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
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
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
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
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