Well, I'm running out of ideas. One more... even less likely... and
assuming postrgres has essentially the same versioning/snapshot machinery
as firebird...
At one point running the banktest I was getting deadlocks with read
committed transaction isolation which went away when I changed to snapshot
isolation (I'm writing the driver, so I get to call it serializable). I
never figured out where the problem was coming from, but it might be worth
trying. (if there is the same versioning machinery, serializable should
have only a small performance impact.. if not, you probably want to stay
away)
I think you need 2.4 to be able to set isolation in the pools.
david jencks
On 2001.07.24 16:14:12 -0400 David Esposito wrote:
> 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
>
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
