Hi, I wrote a simple test case to check remove of objects on rollback - seems to work for default odmg-api. Thus the problem could be the the j2ee extension or your test case. So can you please send me the source of your test case?
regards, Armin ----- Original Message ----- From: "jean-pierre lerbscher" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 4:59 PM Subject: Re: Problem : stale data when jta transaction rollback > Hi Armin, > I join to this message 2 files that contain debug info : one is > transaction commit use case, the other is transaction rollback use case. > (It's the same functionnal use case : in the first use case, i commit > the transaction, in the seconde i rollback the transaction.) > I don't see nothing about : > > On rollback/abort all dirty objects are removed from > cache to avoid dirty-reads. > > Could you tell me if the transaction rollback debug info seem to be > correct for you ? > > Regards, > JP > > Armin Waibel wrote: > > >Hi, > > > >----- Original Message ----- > >From: "jean-pierre lerbscher" <[EMAIL PROTECTED]> > >To: "OJB Users List" <[EMAIL PROTECTED]> > >Sent: Tuesday, September 23, 2003 10:38 AM > >Subject: Re: Problem : stale data when jta transaction rollback > > > > > >>Hi Armin, > >>Could could explain to me in detail what happen in odmg or broker > >> > >layer > > > >>when the jta transaction rollback ? > >> > >in odmg-layer we use javax.transaction.Synchronization > >to commit/abort intern odmg tx (see J2EETransactionImpl). > >On rollback/abort all dirty objects are removed from > >cache to avoid dirty-reads. See > >ObjectEnvelopeTable#rollback() (Line 348) > >and state-package. > >Note: > >Before changing an object you need to lock > >the object or you have to make it 'dirty' by your own > >using > >((TransactionExt) tx).markDirty(obj); > >current CVS > >or > >rc4 > >((TransactionImpl) tx).markDirty(obj); > > > > > >pb-layer does not use Synchronization, thus a rollback is > >only done on connection level. > >If you want to synchronize > >the cache you have to do this by our own (clear cache, ...) > >or synchronize the cache with your jotm-transaction by > >implementing your own ObjectCache. > > > >HTH > >regards, > >Armin > > > >>Armin Waibel wrote: > >> > >>>Hi Jean-Pierre, > >>>----- Original Message ----- > >>>From: "jean-pierre lerbscher" <[EMAIL PROTECTED]> > >>>To: "OJB Users List" <[EMAIL PROTECTED]> > >>>Sent: Tuesday, September 23, 2003 10:02 AM > >>>Subject: Re: Problem : stale data when jta transaction rollback > >>> > >>> > >>>>Could you give me an explanation (Armin or ... )? > >>>>What's happen when that an external transaction abort ? > >>>> > >>>It's a known problem. We currently discuss to > >>>introduce a pluggable two-level cache to avoid dirty reads > >>>when using a global cache. > >>>To avoid described problems you can > >>> > >>>- use ObjectCachePerBrokerImpl as cache and > >>>when using current version from CVS it is possible to > >>>declare caches per jdbc-connection-/class-descriptor > >>>(see http://article.gmane.org/gmane.comp.jakarta.ojb.devel/3763 > >>>+ javadoc of cache-package classes) > >>>you can use global cache for read-only classes > >>> > >>>- write your own two-level ObjectCache implementation > >>>depending on jotm > >>> > >>>regards, > >>>Armin > >>> > >>>>Regards, > >>>>JP > >>>> > >>>>jean-pierre lerbscher wrote: > >>>> > >>>>>Hi, > >>>>>I observed the problem with db-ojb-1.0.rc2 and db-ojb-1.0.rc4. I'm > >>>>>using odmg api. > >>>>>My transaction is obtain from a jta transaction manager (jotm). > >>>>>I search and lock an object to update this value, the transaction > >>>>>fails, and when I seek the object again, i obtain the modified > >>>>> > >value > > > >>>>>of the object although the data base is not updated. I think that > >>>>>there is, in this case, a problem of stale data in a cache. > >>>>>ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCacheDefaultImpl > >>>>> > >>>in > >>> > >>>>>ojb.properties > >>>>>Somebody it already encountered the problem. > >>>>>Regards, > >>>>>jean-pierre > >>>>> > >>>>> > >>>>> > >>>--------------------------------------------------------------------- > >>> > >>>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>>> > >>>>> > >>>> > >>>> > >>>--------------------------------------------------------------------- > >>> > >>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>> > >>>> > >>>> > >>> > >>> > >>>--------------------------------------------------------------------- > >>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >>> > >> > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > ------------------------------------------------------------------------ -------- > 2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG ojb.odmg.OJBJ2EE_2 - beginInternTransaction was called > 2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG ojb.odmg.OJBJ2EE_2 - obtain new intern odmg-transaction > 2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG jb.odmg.JTATxManager - registerSynchronization was called > 2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG jb.odmg.JTATxManager - getTransaction called > 2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG jb.odmg.JTATxManager - getTransactionManager called > 2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG jb.odmg.JTATxManager - getTransactionManager called > 2003-09-23 15:36:48,201 174881 [Thread-2] DEBUG jb.odmg.JTATxManager - registerSynchronization was called with parameters > J2EETransactionImpl: [EMAIL PROTECTED] > Transaction: 3df3aaa579404_0_3df3aaa579404_0_ > 2003-09-23 15:36:48,251 174931 [Thread-2] DEBUG ojb.odmg.TransactionImpl - Begin transaction was called on tx [EMAIL PROTECTED], with associated PB null > 2003-09-23 15:36:48,251 174931 [Thread-2] DEBUG ojb.odmg.OJBJ2EE_2 - beginInternTransaction was called > 2003-09-23 15:36:48,251 174931 [Thread-2] DEBUG dmg.oql.OQLQueryImpl - create query for query-string: select utilisateur from com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where idUtilisateur="titou" > 2003-09-23 15:36:48,251 174931 [Thread-2] DEBUG dmg.oql.OQLQueryImpl - Start execute query > 2003-09-23 15:36:48,251 174931 [Thread-2] DEBUG broker.ta.PersistenceBrokerFactoryDefaultImpl - createPersistenceBroker(key) called > 2003-09-23 15:36:48,261 174941 [Thread-2] DEBUG broker.singlevm.PersistenceBrokerImpl - getCollectionByQuery (class org.apache.ojb.broker.util.collections.ManageableVector, class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur, Query from class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where [EMAIL PROTECTED]) > 2003-09-23 15:36:48,261 174941 [Thread-2] DEBUG broker.accesslayer.RsIterator - RsIterator(Query from class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where [EMAIL PROTECTED], [EMAIL PROTECTED] com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur,tableName =UTILISATEUR,schema=<null>,isInterface=false,extendClassNames=[],fieldDe [EMAIL PROTECTED] > m_ColNo=1 > m_ColumnName=ID_UTILISATEUR > m_ColumnType=VARCHAR > m_IsKeyField=true > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=2 > m_ColumnName=NOM > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=3 > m_ColumnName=PRENOM > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=4 > m_ColumnName=EMAIL > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=5 > m_ColumnName=MOT_PASSE > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=6 > m_ColumnName=ID_PROFIL > m_ColumnType=INTEGER > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=4 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ]}]) > 2003-09-23 15:36:48,261 174941 [Thread-2] DEBUG broker.accesslayer.JdbcAccessImpl - executeQuery : Query from class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where [EMAIL PROTECTED] > 2003-09-23 15:36:48,261 174941 [Thread-2] DEBUG accesslayer.sql.SqlGeneratorDefaultImpl - SQL: SELECT A0.ID_UTILISATEUR,A0.EMAIL,A0.NOM,A0.PRENOM,A0.MOT_PASSE,A0.ID_PROFIL FROM UTILISATEUR A0 WHERE A0.ID_UTILISATEUR = ? > 2003-09-23 15:36:48,261 174941 [Thread-2] DEBUG broker.accesslayer.ConnectionFactoryAbstractImpl - do datasource lookup, name: java:comp/env/jdbc/InforumPresse, user: null > 2003-09-23 15:36:48,261 174941 [Thread-2] DEBUG broker.accesslayer.ConnectionManagerImpl - Request new connection from ConnectionFactory: [EMAIL PROTECTED] > 2003-09-23 15:36:48,311 174991 [Thread-2] DEBUG broker.accesslayer.RsIterator - hasNext() -> true > 2003-09-23 15:36:48,311 174991 [Thread-2] DEBUG broker.singlevm.PersistenceBrokerImpl - getObjectByIdentity com.vecteurplus.inforumpresse.presse.profil.Profil{0} > 2003-09-23 15:36:48,311 174991 [Thread-2] DEBUG broker.accesslayer.StatementManager - closeResources was called > 2003-09-23 15:36:48,311 174991 [Thread-2] DEBUG broker.singlevm.PersistenceBrokerImpl - getCollectionByQuery (class org.apache.ojb.broker.util.collections.ManageableVector, class com.vecteurplus.inforumpresse.securite.utilisateur.Role, Query from ROLE_UTILISATEUR where [EMAIL PROTECTED]) > 2003-09-23 15:36:48,311 174991 [Thread-2] DEBUG broker.accesslayer.RsIterator - RsIterator(Query from ROLE_UTILISATEUR where [EMAIL PROTECTED], [EMAIL PROTECTED] com.vecteurplus.inforumpresse.securite.utilisateur.Role,tableName=ROLE,s chema=<null>,isInterface=false,extendClassNames=[],fieldDescriptions={or [EMAIL PROTECTED] > m_ColNo=7 > m_ColumnName=ID_ROLE > m_ColumnType=INTEGER > m_IsKeyField=true > indexed=false > autoIncrement=true > sequenceName=<null> > m_ColumnTypeId=4 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=8 > m_ColumnName=DESCRIPTION > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ]}]) > 2003-09-23 15:36:48,311 174991 [Thread-2] DEBUG broker.accesslayer.JdbcAccessImpl - executeQuery : Query from ROLE_UTILISATEUR where [EMAIL PROTECTED] > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG accesslayer.sql.SqlGeneratorDefaultImpl - SQL: SELECT A0.DESCRIPTION,A0.ID_ROLE FROM ROLE A0,ROLE_UTILISATEUR WHERE (ROLE_UTILISATEUR.ID_UTILISATEUR = ? ) AND ROLE_UTILISATEUR.ID_ROLE = A0.ID_ROLE ORDER BY 2 DESC > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG broker.accesslayer.RsIterator - hasNext() -> true > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG broker.accesslayer.StatementManager - closeResources was called > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG broker.accesslayer.RsIterator - hasNext() -> false > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG broker.accesslayer.StatementManager - closeResources was called > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG broker.accesslayer.RsIterator - hasNext() -> false > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG ojb.odmg.TransactionImpl - lock object was called on tx [EMAIL PROTECTED] > 2003-09-23 15:36:48,321 175001 [Thread-2] DEBUG ojb.odmg.TransactionImpl - proceeding with lock on class: com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur object [EMAIL PROTECTED] > 2003-09-23 15:36:48,331 175011 [Thread-2] DEBUG odmg.locking.LockManagerDefaultImpl - LM.writeLock(tx-127.0.0.1:645ccb:f7cea82047:-7ff8, com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur{titou}) > 2003-09-23 15:36:48,481 175161 [Thread-2] DEBUG ojb.odmg.ObjectEnvelopeTable - register: com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur{titou}(or g.apache.ojb.odmg.states.StateOldClean) > ... commit the user transaction > 2003-09-23 15:36:48,612 175292 [Thread-2] DEBUG jb.odmg.JTATxManager - getTransaction called > 2003-09-23 15:36:48,612 175292 [Thread-2] DEBUG jb.odmg.JTATxManager - getTransactionManager called > 2003-09-23 15:36:48,612 175292 [Thread-2] DEBUG jb.odmg.JTATxManager - getTransactionManager called > 2003-09-23 15:36:48,622 175302 [Thread-2] DEBUG ojb.odmg.ObjectEnvelopeTable - PB is in internal tx: false broker was: [EMAIL PROTECTED] > 2003-09-23 15:36:48,622 175302 [Thread-2] DEBUG ojb.odmg.ObjectEnvelopeTable - call beginTransaction() on PB instance > 2003-09-23 15:36:48,622 175302 [Thread-2] DEBUG ojb.odmg.ObjectEnvelopeTable - commit: com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur{titou}(or g.apache.ojb.odmg.states.StateOldClean) > 2003-09-23 15:36:48,622 175302 [Thread-2] DEBUG odmg.locking.LockManagerDefaultImpl - LM.checkWrite(tx-127.0.0.1:645ccb:f7cea82047:-7ff8, com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur{titou}) > 2003-09-23 15:36:48,652 175332 [Thread-2] INFO broker.singlevm.PersistenceBrokerImpl - Cascade store for this reference (com.vecteurplus.inforumpresse.presse.profil.Profil) was set to false. > 2003-09-23 15:36:48,652 175332 [Thread-2] DEBUG util.sequence.SequenceManagerMySQLImpl - [EMAIL PROTECTED] > m_ColNo=6 > m_ColumnName=ID_PROFIL > m_ColumnType=INTEGER > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=4 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ] > 2003-09-23 15:36:48,652 175332 [Thread-2] DEBUG broker.accesslayer.JdbcAccessImpl - executeUpdate : [EMAIL PROTECTED] > 2003-09-23 15:36:48,662 175342 [Thread-2] DEBUG accesslayer.sql.SqlGeneratorDefaultImpl - SQL: UPDATE UTILISATEUR SET NOM=?, PRENOM=?, EMAIL=?, MOT_PASSE=?, ID_PROFIL=? WHERE ID_UTILISATEUR = ? > 2003-09-23 15:36:48,742 175422 [Thread-2] DEBUG broker.accesslayer.StatementManager - closeResources was called > 2003-09-23 15:36:48,752 175432 [Thread-2] DEBUG accesslayer.sql.SqlGeneratorDefaultImpl - SQL: SELECT ID_ROLE FROM ROLE_UTILISATEUR WHERE ID_UTILISATEUR=? > 2003-09-23 15:36:48,752 175432 [Thread-2] DEBUG broker.accesslayer.JdbcAccessImpl - executeSQL: SELECT ID_ROLE FROM ROLE_UTILISATEUR WHERE ID_UTILISATEUR=? > 2003-09-23 15:36:48,762 175442 [Thread-2] DEBUG ojb.odmg.J2EETransactionImpl - Commit transaction [EMAIL PROTECTED], commit on broker [EMAIL PROTECTED] > 2003-09-23 15:36:48,772 175452 [Thread-2] DEBUG util.pooling.ByPassConnection - ** we ignore commit > 2003-09-23 15:36:48,792 175472 [Thread-2] DEBUG odmg.locking.LockManagerDefaultImpl - LM.releaseLock(tx-127.0.0.1:645ccb:f7cea82047:-7ff8, com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur{titou}) > 2003-09-23 15:36:48,792 175472 [Thread-2] DEBUG ojb.odmg.TransactionImpl - Close Transaction and release current PB [EMAIL PROTECTED] on tx [EMAIL PROTECTED] > 2003-09-23 15:36:48,792 175472 [Thread-2] DEBUG broker.singlevm.PersistenceBrokerImpl - PB.close was called: [EMAIL PROTECTED] > > ------------------------------------------------------------------------ -------- > 2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG ojb.odmg.OJBJ2EE_2 - beginInternTransaction was called > 2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG ojb.odmg.OJBJ2EE_2 - obtain new intern odmg-transaction > 2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG jb.odmg.JTATxManager - registerSynchronization was called > 2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG jb.odmg.JTATxManager - getTransaction called > 2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG jb.odmg.JTATxManager - getTransactionManager called > 2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG jb.odmg.JTATxManager - getTransactionManager called > 2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG jb.odmg.JTATxManager - registerSynchronization was called with parameters > J2EETransactionImpl: [EMAIL PROTECTED] > Transaction: 3df3ac98f1007_0_3df3ac98f1007_0_ > 2003-09-23 15:45:19,877 35301 [Thread-3] DEBUG ojb.odmg.TransactionImpl - Begin transaction was called on tx [EMAIL PROTECTED], with associated PB null > 2003-09-23 15:45:19,977 35401 [Thread-3] DEBUG ojb.odmg.OJBJ2EE_2 - beginInternTransaction was called > 2003-09-23 15:45:19,977 35401 [Thread-3] DEBUG dmg.oql.OQLQueryImpl - create query for query-string: select utilisateur from com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where idUtilisateur="titou" > 2003-09-23 15:45:19,997 35421 [Thread-3] DEBUG dmg.oql.OQLQueryImpl - Start execute query > 2003-09-23 15:45:19,997 35421 [Thread-3] DEBUG broker.ta.PersistenceBrokerFactoryDefaultImpl - createPersistenceBroker(key) called > 2003-09-23 15:45:19,997 35421 [Thread-3] DEBUG broker.singlevm.PersistenceBrokerImpl - getCollectionByQuery (class org.apache.ojb.broker.util.collections.ManageableVector, class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur, Query from class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where [EMAIL PROTECTED]) > 2003-09-23 15:45:20,047 35471 [Thread-3] DEBUG broker.accesslayer.RsIterator - RsIterator(Query from class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where [EMAIL PROTECTED], [EMAIL PROTECTED] com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur,tableName =UTILISATEUR,schema=<null>,isInterface=false,extendClassNames=[],fieldDe [EMAIL PROTECTED] > m_ColNo=1 > m_ColumnName=ID_UTILISATEUR > m_ColumnType=VARCHAR > m_IsKeyField=true > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=2 > m_ColumnName=NOM > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=3 > m_ColumnName=PRENOM > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=4 > m_ColumnName=EMAIL > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=5 > m_ColumnName=MOT_PASSE > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=6 > m_ColumnName=ID_PROFIL > m_ColumnType=INTEGER > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=4 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ]}]) > 2003-09-23 15:45:20,047 35471 [Thread-3] DEBUG broker.accesslayer.JdbcAccessImpl - executeQuery : Query from class com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur where [EMAIL PROTECTED] > 2003-09-23 15:45:20,047 35471 [Thread-3] DEBUG accesslayer.sql.SqlGeneratorDefaultImpl - SQL: SELECT A0.ID_UTILISATEUR,A0.EMAIL,A0.NOM,A0.PRENOM,A0.MOT_PASSE,A0.ID_PROFIL FROM UTILISATEUR A0 WHERE A0.ID_UTILISATEUR = ? > 2003-09-23 15:45:20,047 35471 [Thread-3] DEBUG broker.accesslayer.ConnectionFactoryAbstractImpl - do datasource lookup, name: java:comp/env/jdbc/InforumPresse, user: null > 2003-09-23 15:45:20,047 35471 [Thread-3] DEBUG broker.accesslayer.ConnectionManagerImpl - Request new connection from ConnectionFactory: [EMAIL PROTECTED] > 2003-09-23 15:45:20,097 35521 [Thread-3] DEBUG broker.accesslayer.RsIterator - hasNext() -> true > 2003-09-23 15:45:20,117 35541 [Thread-3] DEBUG broker.singlevm.PersistenceBrokerImpl - getObjectByIdentity com.vecteurplus.inforumpresse.presse.profil.Profil{0} > 2003-09-23 15:45:20,117 35541 [Thread-3] DEBUG broker.accesslayer.StatementManager - closeResources was called > 2003-09-23 15:45:20,117 35541 [Thread-3] DEBUG broker.singlevm.PersistenceBrokerImpl - getCollectionByQuery (class org.apache.ojb.broker.util.collections.ManageableVector, class com.vecteurplus.inforumpresse.securite.utilisateur.Role, Query from ROLE_UTILISATEUR where [EMAIL PROTECTED]) > 2003-09-23 15:45:20,117 35541 [Thread-3] DEBUG broker.accesslayer.RsIterator - RsIterator(Query from ROLE_UTILISATEUR where [EMAIL PROTECTED], [EMAIL PROTECTED] com.vecteurplus.inforumpresse.securite.utilisateur.Role,tableName=ROLE,s chema=<null>,isInterface=false,extendClassNames=[],fieldDescriptions={or [EMAIL PROTECTED] > m_ColNo=7 > m_ColumnName=ID_ROLE > m_ColumnType=INTEGER > m_IsKeyField=true > indexed=false > autoIncrement=true > sequenceName=<null> > m_ColumnTypeId=4 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ],[EMAIL PROTECTED] > m_ColNo=8 > m_ColumnName=DESCRIPTION > m_ColumnType=VARCHAR > m_IsKeyField=false > indexed=false > autoIncrement=false > sequenceName=<null> > m_ColumnTypeId=12 > length=0 > precision=0 > scale=0 > required=false > scaleSpecified=false > precisionSpecified=false > lengthSpecified=false > fieldConversion=org.apache.ojb.broker.accesslayer.conversions.FieldConve [EMAIL PROTECTED] > locking=false > ]}]) > 2003-09-23 15:45:20,117 35541 [Thread-3] DEBUG broker.accesslayer.JdbcAccessImpl - executeQuery : Query from ROLE_UTILISATEUR where [EMAIL PROTECTED] > 2003-09-23 15:45:20,117 35541 [Thread-3] DEBUG accesslayer.sql.SqlGeneratorDefaultImpl - SQL: SELECT A0.DESCRIPTION,A0.ID_ROLE FROM ROLE A0,ROLE_UTILISATEUR WHERE (ROLE_UTILISATEUR.ID_UTILISATEUR = ? ) AND ROLE_UTILISATEUR.ID_ROLE = A0.ID_ROLE ORDER BY 2 DESC > 2003-09-23 15:45:20,137 35561 [Thread-3] DEBUG broker.accesslayer.RsIterator - hasNext() -> true > 2003-09-23 15:45:20,137 35561 [Thread-3] DEBUG broker.accesslayer.StatementManager - closeResources was called > 2003-09-23 15:45:20,137 35561 [Thread-3] DEBUG broker.accesslayer.RsIterator - hasNext() -> false > 2003-09-23 15:45:20,147 35571 [Thread-3] DEBUG broker.accesslayer.StatementManager - closeResources was called > 2003-09-23 15:45:20,147 35571 [Thread-3] DEBUG broker.accesslayer.RsIterator - hasNext() -> false > 2003-09-23 15:45:20,147 35571 [Thread-3] DEBUG ojb.odmg.TransactionImpl - lock object was called on tx [EMAIL PROTECTED] > 2003-09-23 15:45:20,147 35571 [Thread-3] DEBUG ojb.odmg.TransactionImpl - proceeding with lock on class: com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur object [EMAIL PROTECTED] > 2003-09-23 15:45:20,267 35691 [Thread-3] DEBUG odmg.locking.LockManagerDefaultImpl - LM.writeLock(tx-127.0.0.1:645ccb:f7cea82047:-7ff2, com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur{titou}) > 2003-09-23 15:45:20,698 36122 [Thread-3] DEBUG ojb.odmg.ObjectEnvelopeTable - register: com.vecteurplus.inforumpresse.securite.utilisateur.Utilisateur{titou}(or g.apache.ojb.odmg.states.StateOldClean) > rollback of the user transaction... > no trace !!! > ------------------------------------------------------------------------ -------- > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
