hi, all


can close the database Connection before the JTA transaction commit or rollback?

my understanding:

if the connection not come from connection pool. i think this must be a issue, but if Connection come from pool, the close method just return it to pool, but due to multithread environment, the connection maybe can be used immediately by another thread, but the the previous transaction still not commit or rollback, but the connection aleady service for other service(maybe into another transaction), i think
this will produce an unexpected result.

i can't confirm my understanding, i aleady be confused , please help me!

thanks

regards

not quite understand u by producing an unexpected result with reusing the released connection. i think when a connection is released to the pool, all objects/status related to this connection are cleared and no longer exist

my means: if do as above description, whether have any issue or problem?

thanks

Here's an idea: try it!

In JTA, connections (managed resources) associated with a transaction are not available for re-use outside that transaction until the end of said transaction. Read up on how JTA and JCA work.

thanks

that's means that the same connection can't participate the diffrent JTA transaction in the same time?

thanks

i will read the specification, can u give me the excerpt from the specification about this? i thanks a lot

regards

Hi
answering to the forst query...i can say that

1. if the connection not come from connection pool. i think this must be a issue,
Yes! this can be an issue

2. if Connection come from pool, the close method just return it to pool,
Yes! this is also true

3. but due to multithread environment, the connection maybe can be used immediately by another thread, but the the previous transaction still not commit or rollback, but the connection aleady service for other service(maybe into another transaction),
No! as the connection will close and the changes wont take effect so there is no point of committ or no point of rollback.
you have to explicitely do that as the state can be still in the cache ready to be committed or rollbacked....!!


hope u got the answers.

thanks