Dear Experts,
Can you list me all transactions and sessions specifying whether commit is required or not i.e. autocommit? For ex. commit is required for DML but not for DDL statements...
http://www.experts-exchange.com/Database/Oracle/Q_20154409.html
Zones:
OracleDate Answered: 07/21/2001 Grade: A Views: 58
Is it possible to set autocommit to false? If so how would I go about doing this? After it is set to false how would I commit the database?
Thank You In Advance,
kmurphy
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20232486.html
Zones:
Visual BasicDate Answered: 11/19/2001 Grade: A Views: 0
U have three DML operations in an event .When light turns off during or unexpected shutdown occurs in the middile of some DML operations without commint and rollback statements , data is not saved....
http://www.experts-exchange.com/Database/Miscellaneous/Q_20340768.html
Zones:
DatabasesDate Answered: 11/12/2002 Grade: A Views: 87
I am wondering if there is an option to automatically commit the transactions instead of having to explicitly commit. Is there any VB command or do I have to explicitly do it in the Orcale Database
http://www.experts-exchange.com/Programming/Misc/Q_20413328.html
Zones:
ProgrammingDate Answered: 07/26/2003 Grade: B Views: 0
i have this code.
..
..
ps = conn.prepareStatement("Insert into Service (TechName, ServiceDate, Warranty, Filter, TCom, DCom) values (?,?,?,?,?,?)");
ps2a = conn.prepareStatement("Update purcha...
http://www.experts-exchange.com/Programming/Languages/Java/J2EE/JSP/Q_20816214.html
Zones:
JSPDate Answered: 12/09/2003 Grade: A Views: 0
Hello,
Is there someone who can help me? I wonna configure struts to work with a oracle database. Next text i have put in my struts-config.xml.
<data-sources>
<data-source key="NTDEV2" typ...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/Apache/Q_20906853.htm...
I've been reading about transactions in InnoDB, and some sources say that I must explicitly SET AUTOCOMMIT = 0 before using START TRANSACTION...COMMIT. While others say that disabling AUTOCOMMIT i...
http://www.experts-exchange.com/Database/MySQL/Q_21758914.html
Zones:
MySQL ServerDate Answered: 03/02/2006 Grade: A Views: 6
How to turn autocommit on and off in sqllite using c++
http://www.experts-exchange.com/Programming/System/Windows__Programming/MFC/Q_21779436.htm...
Zones:
Windows MFCDate Answered: 03/18/2006 Grade: A Views: 4
Hi,
I want to set the autocommit off and on and use the rollback an commit commands in a VB .dll that i am using in a web application.
this is what i do.
for example DatacConn has the con...
http://www.experts-exchange.com/Database/Oracle/Q_20653546.html
Zones:
OracleDate Answered: 10/20/2003 Grade: A Views: 0
hi all,
I'm using JBoss 3.2.5 as my application server. I had developed a Stateless Session Bean. In my Session Bean, I try to create a connection to my MSSQL Database via following code :
Init...
http://www.experts-exchange.com/Software/Server_Software/Application_Servers/Q_21138635.ht...
