db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: ERROR 40XC0: Dead statement (by zak allen)
Date Thu, 06 Dec 2007 16:13:09 GMT
adam jvok wrote:

>   public static void deadLock(String firstTable, String secondTable,
> ResultSet[] data1) throws SQLException, Exception {
>     Connection conn = DriverManager.getConnection("jdbc:default:connection");
>     conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE) ;
>     boolean ac=conn.getAutoCommit();
>     conn.setAutoCommit(false) ;

[snip]

>         conn.setAutoCommit(ac) ;

Somewhat unrelated, but FYI the JDBC connection in a Java procedure is 
always in non-auto commit mode, thus there is no need to change its 
auto-commit status or reset it.

Dan.


Mime
View raw message