db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: problem with select statement?
Date Mon, 04 Jan 2010 01:13:04 GMT
> when trying to call the next method on a result set generated by a 
> select statement I get the exception:
> java.sql.SQLException: ResultSet not open.  Verify that autocommit is OFF.

By default, a connection is in auto-commit mode. To set autocommit OFF, add

   localConnection.setAutoCommit(false);

to your program, after you have created the connection, and before you
have issued your query.

thanks,

bryan


Mime
View raw message