Veresh Jain <[email protected]> writes: Hi Veresh, this questions belongs on the Derby user's list. This list if for development issue.
As to your question, the fact that other databases work, doesn't mean Derby is wrong, please provide som more detail about what you are doing. For example if you are using autocommit and have two open result sets in that transaction, when the first one is drained it is automaticaly closed leading the the transaction to commit as well, somewhat surprisingly, perhaps. In such cases, run with autocommit off for best results. Dag > Hi, > > We are using Apache Derby latest version in our project and is getting error > "java.lang.RuntimeException: java.sql.SQLException: ResultSet not open. > Verify that autocommit is OFF." > Same SQL statement works properly with MySQL and Oracle but DErby it fails. > > Please provide any pointers as what could be wrong. > > Thanks a lot. > > Regards > Veresh --
