I don't understand. Can you repeat your explanation of the problem clearly indicating what is a ManagedConnection and what is a Connection? From your description it looks like perhaps the problem is that we are reusing the java.sql.Connection obtained from a XAConnection? This would not be a problem with the trackConnectionByTx logic but with the xa wrapper.
thanks david jencks On 2002.11.01 08:12:05 -0500 Igor Fedorenko wrote: > Hi, > > There is a problem with trackConnectionByTx in the current CVS version > of JBoss 3.2 which occurs when two beans access the same datasource > from the same transaction. I am not 100% sure about original > implementation intends and would like to give others an opportunity to > complain before I check in updated trackConnectionByTx logic. > Consider the following example > > - BeanA allocates a connection and gets an instance conn1 > - BeanA calls BeanB > - BeanB allocates a connection and gets the same instance conn1 > - BeanB closes the connection and returns > - BeanA tries to use the connection and gets SQLException("Logical > handle is closed"). > > Updated trackConnectionByTx logic will return the > same connection only if the connection has not been allocated yet > (condition > "BaseConnectionManager2.ConnectionListener.isManagedConnectionFree()"); > otherwise allocate and return new connection. > > Any objections? > > -- > Igor Fedorenko > Think smart. Think automated. Think Dynamics. > www.thinkdynamics.com > > > > > ------------------------------------------------------- > This sf.net email is sponsored by: See the NEW Palm > Tungsten T handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development > > ------------------------------------------------------- This sf.net email is sponsored by: See the NEW Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development