ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gérard Ribière <gerard.ribi...@netcourrier.com>
Subject Committing Transactions with WebSphere and DB2
Date Fri, 07 Jan 2005 11:29:03 GMT
Hello,

I am using iBatis sqlMap 2.0.7 with IBM WebSphere Application Server 
version 5.0.2.9
I use the standard sequence :
    try
    {
        sqlMap.startTransaction ();
        listeServeurs = sqlMap.queryForList("getListeServeurs", null) ;
        sqlMap.commitTransaction ();
    }
    catch (Exception e)
    {
        gestionErreur("Erreur liste des serveurs ", e) ;
    }
    finally
    {
        try
        {
            sqlMap.endTransaction ();
        }
        catch(SQLException e)
        {
            gestionErreur ("Erreur fermeture de transaction ", e) ;
        }
    }

My transactions are read only transactions. However, I always get the 
following message :

[07/01/05 12:20:44:219 CET] 228fdff7 LocalTransact E WLTC0033E: The 
jdbc/StatHttp resource was cancelled during the cleaning of a non 
resolved LocalTransactionContainment.
[07/01/05 12:20:44:234 CET] 228fdff7 LocalTransact E WLTC0032E: One or 
more resources have been cancelled. A LocalTransactionContainment 
includes a non resolved cancelling operation.
[07/01/05 12:20:44:234 CET] 228fdff7 TraceNLS      u No message text 
associated with key LocalTransaction.rolled-back.due.to.setRollbackOnly 
in bundle com.ibm.ejs.resources.seriousMessages
[07/01/05 12:20:44:234 CET] 228fdff7 WebAppTransac E LocalTransaction 
rolled-back due to setRollbackOnly
[07/01/05 12:20:44:250 CET] 228fdff7 WebGroup      E SRVE0026E: [Servlet 
Error]-[LocalTransaction rolled-back due to setRollbackOnly]: 
com.ibm.ws.LocalTransaction.RolledbackException
    at 
com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:966)

I was able to work around this problem by adding the following two 
statements in the try  block :

            java.sql.Connection connection = sqlMap.getCurrentConnection() ;
            connection.commit() ;
That is, I am committing the transactions myself.

Any idea about what happens ?
Thank you in advance.



Mime
View raw message