I thought maybe you had hit it ... but it turns out that it still gets stuck
... I added code to issue an explicit commit() before closing the Connection
but it still hung ... (took it a couple of hours, but it hung at the exact
same spot) ...
btw, this happens with other blocks of code in the same application, not
just this one statement ... however, this is the only one that i can
replicate on a semi-regular basis ...
-Dave
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of David
> Jencks
> Sent: Tuesday, July 24, 2001 9:05 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-dev] client application gets stuck, hangs, freezes,
> whatever you want to call it
>
>
> Unfortunately, it doesn't suggest anything to me. Are you committing
> before closing the connection? I know it's read only, but if postgres
> works like firebird/interbase and the driver doesn't check enough for open
> transactions when it closes a connection it may conceivably make a
> difference.
>
> david jencks
>
> On 2001.07.24 08:14:21 -0400 David Esposito wrote:
> > getSalesRank opens the JDBC connection, creates a PreparedStatement,
> > executes it, then takes the ResultSet and copies the data out into an
> > ArrayList of HashMaps... it then closes the ResultSet, followed by the
> > Statement, followed by the Connection ... It only returns the ArrayList
> > to
> > the caller after the connection to the DB has been closed ... does that
> > narrow things down at all?
> >
> > -Dave
> >
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
