db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Malte.Kem...@de.equens.com>
Subject [No Subject]
Date Mon, 28 Sep 2009 16:00:54 GMT
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.

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


Mime
View raw message