db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sisilla <sisill...@gmail.com>
Subject Single Transaction Using Multiple Method Calls That Open New Database Connections
Date Wed, 14 Feb 2007 18:47:45 GMT

Hello All,

I would like to update several tables in one transaction. The updates happen
via several method calls, and each of these methods open new database
connections. The methods also contain calls to other methods that open new
database connections. Is it at all possible that these updates could be
handled as a single transaction without eliminating these method calls? 

I am using 
                    conn.setAutoCommit(false);
before the updates and
                    conn.commit();
after the updates, but it isn't working as is.

I am using Derby 10.2.1.6 and JDK 1.6.0 on Windows XP Professional. I
appreciate any help. 

Thanks,
Sisilla
-- 
View this message in context: http://www.nabble.com/Single-Transaction-Using-Multiple-Method-Calls-That-Open-New-Database-Connections-tf3228984.html#a8971063
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message