Make your own free website on Tripod.com

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]

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


For those not on the DODs mailing list...

Subject: Re: DODS: InstantDB: java.sql.SQLException: results set is closed


> In the ENHYDRA_3_1_BRANCH I have made a change to QueryBuilder
> so that getNextRow() will continue to return null
> after the ResultSet is empty.
>
> Jay Gunter wrote:
> >
> > QueryBuilder.getNextRow() will return null
> > as soon as the ResultSet is empty.
> >
> > If you call getNextRow() after it has already returned null,
> > the exception is thrown.
> >
> > Peter Hearty wrote:
> > >
> > > Anyone know of any DODS behaviour that might lead to this?
> > >
> > > Pete
> > >
> > > --
> > >
> > > Peter Hearty                         peter.hearty@lutris.com
> > > Lutris Technologies (UK)        http://www.lutris.com
> > > ----- Original Message -----
> > > From: "Christine Bregulla" <cbregulla@perbit.de>
> > > To: <instantdb@enhydra.org>
> > > Sent: Tuesday, January 23, 2001 8:43 AM
> > > Subject: InstantDB: 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(QueryBui
> > > lder.java:324)
> > >
> > > at
> > >
com.lutris.dods.builder.generator.query.QueryBuilder.getRows(QueryBuilde
> > > r.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
> > >
> >
> --------------------------------------------------------------------------
---
> > > To unsubscribe from this mailing list, send email to
majordomo@enhydra.org
> > > with the text "unsubscribe dods" in the body of the email.
> > > If you have other questions regarding this mailing list, send email to
> > > the list admin at owner-dods@enhydra.org.
> >
> > --
> >
> > Jay Gunter, Lutris Technologies
> > jay@lutris.com
>
> --------------------------------------------------------------------------
---
> > To unsubscribe from this mailing list, send email to
majordomo@enhydra.org
> > with the text "unsubscribe dods" in the body of the email.
> > If you have other questions regarding this mailing list, send email to
> > the list admin at owner-dods@enhydra.org.
>
> --
>
> Jay Gunter, Lutris Technologies
> jay@lutris.com
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe dods" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-dods@enhydra.org.
>


-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.