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