RE: [Jython-users] zxJDBC not committing ?

[Noel R. <no...@ya...>]

>
>[NOTE] Since both the Python DB API and JDBC have .commit() on the
>connection be careful with threads.  A connection used to create cursors
>across threads is dangerous since one thread might call .commit() on the
>connection while other threads are in the middle of something.  It is
>best to allocate a new connection per thread or use a connection pool
>(Datasource or otherwise) to make sure no two threads are sharing a
>single connection.

Brian -- while we're on the subject I have a follow up question... is there 
a connection pool tool that you've used with zxJDBC that works particularly 
well (or works at all)?  I've been looking around for pool tools that hit 
the JDBC 2.0 spec (which it seems like zxJDBC needs), and haven't found 
anything that I really like.

Thanks,

Noel


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com