Subject Re: [IB-Java] Re: Built in pooling added to jca-jdbc driver
Author David Jencks
On 2002.01.07 09:33:01 -0500 Paulo Gaspar wrote:
> Jw,
>
> Hum... I promised taking care of the logging bit but I am still
> missing the time to do it.

I might work on it soon. Could you send me the latest version of your
logging adapter?
>
> Your error suggests that you are missing a Connection.commit() or
> Connection.rollback() call to finalize some transaction. Check
> your code.
>
>
> David,
>
> In my own DB Connection pool I include rolling back connections
> with pending transactions in the returned-to-the-pool connection
> cleanup process. Questions:
> - Can it be that this is missing in the current implementation?
> - What makes more sense: the silent automatic rollback() I
> describe or a noisy one that raises an exception?
>

I forgot about this-- you don't need this in a managed environment. I
think throwing an exception is the way to go here.

Thanks
david jencks
>
>
> Have fun,
> Paulo Gaspar
>
>
> > -----Original Message-----
> > From: jwcanada [mailto:jwcanada@...]
> > Sent: Monday, January 07, 2002 2:38 PM
> > To: IB-Java@yahoogroups.com
> > Subject: [IB-Java] Re: Built in pooling added to jca-jdbc driver
> >
> >
> > David,
> >
> > It seems that the pooling is working, except
> > 1) ds.getConnection() without username, password
> > 2) I tried it in a project, there are few log exception messages as
> > follows:
> >
> > java.lang.IllegalStateException: Can't destroy managed connection
> > with active t ransaction
> > at org.firebirdsql.jca.FBManagedConnection.destroy
> > (FBManagedConnection.j ava:323)
> > at org.firebirdsql.jca.ManagedConnectionPool.doDestroy
> > (ManagedConnection Pool.java:251)
> > at org.firebirdsql.jca.ManagedConnectionPool.removeTimedOut
> > (ManagedConnectionPool.java:179)
> > at org.firebirdsql.jca.IdleRemover$1.run(IdleRemover.java:83)
> > at java.lang.Thread.run(Thread.java:484)
> >
> > 3) Are there any easy way to disable logging?
> >
> > Thank you for the nice work.
> >
> > jw
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > IB-Java-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>