Re: Problem : stale data when jta transaction rollback

Tue, 23 Sep 2003 07:59:30 -0700

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 ojb.odmg.JTATxManager  - 
registerSynchronization was called 
2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG ojb.odmg.JTATxManager  - 
getTransaction called 
2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG ojb.odmg.JTATxManager  - 
getTransactionManager called 
2003-09-23 15:36:48,191 174871 [Thread-2] DEBUG ojb.odmg.JTATxManager  - 
getTransactionManager called 
2003-09-23 15:36:48,201 174881 [Thread-2] DEBUG ojb.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 odmg.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 odmg.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],tableName=UTILISATEUR,schema=<null>,isInterface=false,extendClassNames=[],[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
  [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
  [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
  [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
  [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
  [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
  [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],tableName=ROLE,schema=<null>,isInterface=false,extendClassNames=[],[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
  [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
  [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}(org.apache.ojb.odmg.states.StateOldClean)
 
... commit the user transaction
2003-09-23 15:36:48,612 175292 [Thread-2] DEBUG ojb.odmg.JTATxManager  - 
getTransaction called 
2003-09-23 15:36:48,612 175292 [Thread-2] DEBUG ojb.odmg.JTATxManager  - 
getTransactionManager called 
2003-09-23 15:36:48,612 175292 [Thread-2] DEBUG ojb.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}(org.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
  [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 ojb.odmg.JTATxManager  - 
registerSynchronization was called 
2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG ojb.odmg.JTATxManager  - getTransaction 
called 
2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG ojb.odmg.JTATxManager  - 
getTransactionManager called 
2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG ojb.odmg.JTATxManager  - 
getTransactionManager called 
2003-09-23 15:45:19,777 35201 [Thread-3] DEBUG ojb.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 odmg.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 odmg.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],tableName=UTILISATEUR,schema=<null>,isInterface=false,extendClassNames=[],[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
  [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
  [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
  [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
  [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
  [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
  [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],tableName=ROLE,schema=<null>,isInterface=false,extendClassNames=[],[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
  [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
  [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}(org.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]

Reply via email to