Hello again,
This may or may not be the best place to post this message. If not, I
apologize in advance and will appreciate any pointers to the proper
place.
I am writing an application that uses DBCP to connect to an Oracle 9
database. My app needs to perform "six degrees"-types of queries
against the database (i.e. starting at a central record, expand out so
many degrees). These degrees are accomplished by recursion, which each
recursive layer acquiring its own DB connection via DBCP. Some of the
ResultSets can be quite large. Eventually, I start getting sporadic
exceptions:
java.sql.SQLException: Closed Resultset: next
...
at oracle.jdbc.driver.OracleResultSetImpl.next
Not being a DB guru, I'm having a real hard time determining where
this error is coming from. I close every ResultSet, Statement, and
Connection I use. I synchronize on the DB pool object when asking for
a connection...
Any idea/thoughts/pointers as to what is going on here?
Thanks in advance,
James
--
James A. Cubeta
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
