This is a multi-part message in MIME format.
------=_NextPart_000_0023_01C8AAD2.6AE0F180
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am migrating from another database to PostgreSQL and have run into a =
serious problem. The Java program runs fine on the other DB but under =
PostgreSQL it gives the error, "ResultSet is closed."=20
This result set is created in a method that processes each row =
sequentially. Within the processing, it passes the result set to another =
method that retrieves columns from it and creates additional result sets =
to retrieve related information. This second method can also call itself =
recursively. This works fine with HSQLDB but fails when returning back =
to the original method and attempting another loop on the original =
result set, claiming it is closed.
I have removed all occurrences of closing any result sets and there are =
no instances of closing underlying statements within those methods. =
Finally, I have stepped through the entire operation with a debugger and =
found no unexpected events. Each time a new result set was created, the =
debugger indicated it to be a new entity. When finally returning to the =
original, it appeared to be the correct instance.
Is there a known problem along these lines? Any help or suggestions will =
be most appreciated.
Thanks,
Bayless
------=_NextPart_000_0023_01C8AAD2.6AE0F180
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I am migrating from another database to =
PostgreSQL=20
and have run into a serious problem. The Java program runs fine on the =
other DB=20
but under PostgreSQL it gives the error, "ResultSet is closed."=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>This result set is created in a method =
that=20
processes each row sequentially. Within the processing, it passes =
the=20
result set to another method that retrieves columns from it and =
creates=20
additional result sets to retrieve related information. This second =
method can=20
also call itself recursively. This works fine with HSQLDB but fails when =
returning back to the original method and attempting another loop on the =
original result set, claiming it is closed.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have removed all occurrences of =
closing any=20
result sets and there are no instances of closing underlying statements =
within=20
those methods. Finally, I have stepped through the entire operation with =
a=20
debugger and found no unexpected events. Each time a new result set was =
created,=20
the debugger indicated it to be a new entity. When finally returning to =
the=20
original, it appeared to be the correct instance.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Is there a known problem along these =
lines? Any=20
help or suggestions will be most appreciated.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bayless</FONT></DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0023_01C8AAD2.6AE0F180--
|
