Hi,

I am a bit confused by this log.

The SQL-Statements are alright, but the there are a lot of commitings and rolling backs I cannot explain, since my program actually does one commit as far I can see from the logs of my application.

Also I am wondering about Sessionid=0? As far I know my program does only use one connection.

Could somebody explain this to me?

 

Thanks a lot in advance

 

Malte

 

----------------------------------------------------------------

2009-09-28 15:40:50.071 GMT:

Booten von Derby Version The Apache Software Foundation - Apache Derby - 10.5.1.1 - (764942): Instanz a816c00e-0124-014f-afba-0000000ec648

für das Datenbankverzeichnis C:\Dokumente und Einstellungen\z300057\workspace\FED-Convertings\DB

 

Das Ladeprogramm für Datenbankklassen wurde gestartet - derby.database.classpath=''

2009-09-28 15:40:50.274 GMT Thread[main,5,main] (XID = 571), (SESSIONID = 0), (DATABASE = DB), (DRDAID = null), Committing

2009-09-28 15:40:50.274 GMT Thread[main,5,main] (XID = 571), (SESSIONID = 0), (DATABASE = DB), (DRDAID = null), Rolling back

2009-09-28 15:40:50.274 GMT Thread[main,5,main] (XID = 572), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Committing

2009-09-28 15:40:50.274 GMT Thread[main,5,main] (XID = 572), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Committing

2009-09-28 15:40:50.290 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Begin compiling prepared statement: delete from MEMO_RECORDS

where TMPST_IN < ? :End prepared statement

2009-09-28 15:40:50.603 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), End compiling prepared statement: delete from MEMO_RECORDS

where TMPST_IN < ? :End prepared statement

2009-09-28 15:40:50.665 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: delete from MEMO_RECORDS

where TMPST_IN < ? :End prepared statement with 1 parameters begin parameter #1: 2009-09-27 17:40:50.649 :end parameter

2009-09-28 15:40:50.712 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Begin compiling prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement

2009-09-28 15:40:50.712 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), End compiling prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement

2009-09-28 15:40:50.712 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-01 :end parameter

2009-09-28 15:40:50.759 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-02 :end parameter

2009-09-28 15:40:50.774 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-03 :end parameter

2009-09-28 15:40:50.790 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-04 :end parameter

2009-09-28 15:40:50.806 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-05 :end parameter

2009-09-28 15:40:50.821 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-06 :end parameter

2009-09-28 15:40:50.884 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-07 :end parameter

2009-09-28 15:40:50.899 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-08 :end parameter

2009-09-28 15:40:50.915 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-09 :end parameter

2009-09-28 15:40:50.931 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-10 :end parameter

2009-09-28 15:40:50.931 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-11 :end parameter

2009-09-28 15:40:50.946 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-12 :end parameter

2009-09-28 15:40:50.962 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-13 :end parameter

2009-09-28 15:40:50.978 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-14 :end parameter

2009-09-28 15:40:51.009 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-15 :end parameter

2009-09-28 15:40:51.009 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Executing prepared statement: INSERT INTO MEMO_RECORDS (RECORD_ID) VALUES (?) :End prepared statement with 1 parameters begin parameter #1: FED-PAYI01-16 :end parameter

2009-09-28 15:40:51.024 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Committing

2009-09-28 15:40:51.024 GMT Thread[main,5,main] (XID = 573), (SESSIONID = 1), (DATABASE = DB), (DRDAID = null), Rolling back

 

2009-09-28 15:40:51.196 GMT:

Die Instanz a816c00e-0124-014f-afba-0000000ec648 wird heruntergefahren.

----------------------------------------------------------------