Atomikos Forum

Hello

i'm new to jta and having to port an application from websphere to tomcat 6 i've integrated atomikos transactionessential in it. I'm using eclipse to develop the application and the oracle drivers in a non xa manner :  i've to write to two different schemas but on the same server.

Every time i restart the server after a debug session i get the post's title warning : what does it mean exactly ?
Am i missing some commit or rollback and leaving pending transactions ?

next , whenever i create a usertransaction and open a connection i see the following row inside the log :
...
 INFO http-8080-2 configuration - check user - get ds
 INFO http-8080-2 configuration - check user - get transaction
 INFO http-8080-2 atomikos - createCompositeTransaction ( 60000 ): created new ROOT transaction with id tm0004000011
 INFO http-8080-2 configuration - check user - open connection
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': getConnection ( null )...
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': init...
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': getConnection ( null )...
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': init...
 INFO http-8080-2 atomikos - addParticipant ( com.atomikos.jdbc.nonxa.AtomikosNonXAParticipant@1f480e3 ) for transaction tm0004000011
 INFO http-8080-2 atomikos - atomikos non-xa connection proxy for oracle.jdbc.driver.T4CConnection@39bf12: calling createStatement on vendor connection...
 INFO http-8080-2 configuration - check user - update
 INFO http-8080-2 configuration - log Access - get ds
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': getConnection ( null )...
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': init...
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': getConnection ( null )...
 INFO http-8080-2 atomikos - AtomikosNonXADataSourceBean 'jdbc/NraDba': init...
 INFO http-8080-2 atomikos - atomikos non-xa connection proxy for oracle.jdbc.driver.T4CConnection@39bf12: calling createStatement on vendor connection...
 INFO http-8080-2 configuration - log Access - execute UPDATE vw_log_access
 INFO http-8080-2 atomikos - atomikos non-xa connection proxy for oracle.jdbc.driver.T4CConnection@39bf12: calling createStatement on vendor connection...
 INFO http-8080-2 configuration - log Access  - modified  1
 INFO http-8080-2 configuration - log Access  - release res
 INFO http-8080-2 atomikos - atomikos non-xa connection proxy for oracle.jdbc.driver.T4CConnection@39bf12: close...
 INFO http-8080-2 configuration - check user - release res
 INFO http-8080-2 atomikos - atomikos non-xa connection proxy for oracle.jdbc.driver.T4CConnection@39bf12: close...
 INFO http-8080-2 configuration - check user - commit
 INFO http-8080-2 atomikos - commit() done (by application) of transaction tm0004000011
 INFO http-8080-2 atomikos - atomikos non-xa connection proxy for oracle.jdbc.driver.T4CConnection@39bf12: committing on connection...
 INFO http-8080-2 atomikos - atomikos non-xa connection proxy for oracle.jdbc.driver.T4CConnection@39bf12: resetting autoCommit to true
...

where checkuser is the method that handles the transaction and calls logAccess. Why i don't see "atomikos - addParticipant ( ..." when i get the connection from ds inside logAccess method ? (datasource ds is shared : singleton). Nonetheless operations are transactional : if an exception is raised before checkuser's commit, then logAccess updates are rolledback.

thank you in advance for clearification
 
stefano

Hi,

Sorry - I can't seem to make a lot of your post; can you restate the problem?

Guy