Java Answers Forum - connection.setAutoCommit(false) commits after each update?

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Answers Forum
connection.setAutoCommit(false) commits after each update?

1 reply on 1 page. Most recent reply: Feb 24, 2004 2:26 AM by Viswanatha Basavalingappa

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 1 reply on 1 page

SK

Posts: 1
Nickname: dearkoala
Registered: Feb, 2004

connection.setAutoCommit(false) commits after each update?

Posted: Feb 23, 2004 9:35 PM

I have codes in jsp where I grab a database connection, set auto commit to false, did an update via executeUpdate and rollback. What happens is... when I display the auto commit status using getAutoCommit(), it shows true, and the data are updated to the database.
 
I'm using JDK 1.3.1 and Oracle DB 9.0.1.3.
 
Below is an extract of my code.
 

try { 
Context ic = new InitialContext(); 
DataSource ds = (DataSource)ic.lookup((String) application.getAttribute("dataSource")); 
con = ds.getConnection(); 

con.setAutoCommit(false); 
out.println(con.getAutoCommit()); // displayed true during execution. 

stmt = con.createStatement(); 
stmt.executeUpdate(...); 
con.rollbac k(); 
con.close(); 
} 
catch { 
... 
} 
finally { 
... 
} 

TIA.

Viswanatha Basavalingappa

Posts: 84
Nickname: viswagb
Registered: Nov, 2003

Re: connection.setAutoCommit(false) commits after each update?

Posted: Feb 24, 2004 2:26 AM

Hi,
Yes this kind arises some time....solution is ..
To make autoCommit mode off /on You need to use the property 'SelectMethod' for the driver in the URL and set it to 'cursor'

So your driver url should be like :

"jdbc:oracle:thin:@dbmachine:1433;SelectMethod=cursor"

Try this and let me know is it works or not..!!!

Viswa
-------

Flat View: This topic has 1 reply on 1 page

Previous Topic

Next Topic


	Web Artima.com