InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: java.sql.SQLException: results set is closed

Title: java.sql.SQLException: results set is closed

Hi,

IDB Version 3.25

The following SQL Statement causes an exception when an empty result set is returned or
if used directly after an Update to the same table.

"select Stammdaten.oid, Stammdaten.Kurzname, Stammdaten.Kundennr, Stammdaten.Name1 from stammdaten WHERE Stammdaten.BWInstIst is not null ORDER BY Kurzname ASC"

Here the error message:

java.sql.SQLException: results set is closed
at org.enhydra.instantdb.jdbc.idbResultsSet.checkClosed(idbResultsSet.java:83)

at org.enhydra.instantdb.jdbc.idbResultsSet.next(idbResultsSet.java:223)
 
at com.lutris.dods.builder.generator.query.QueryBuilder.getNextRow(QueryBuilder.java:324)

at com.lutris.dods.builder.generator.query.QueryBuilder.getRows(QueryBuilder.java:279)

if the select returns at least one row (data record) the exception is not thrown.

Is there a known fix for this?

Thanks,

Christine