Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 64449 invoked from network); 23 Feb 2007 22:14:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Feb 2007 22:14:27 -0000 Received: (qmail 57406 invoked by uid 500); 23 Feb 2007 22:14:34 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 57373 invoked by uid 500); 23 Feb 2007 22:14:34 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 57364 invoked by uid 99); 23 Feb 2007 22:14:34 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Feb 2007 14:14:34 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,UNPARSEABLE_RELAY,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.98.31] (HELO brmea-mail-1.sun.com) (192.18.98.31) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Feb 2007 14:14:22 -0800 Received: from fe-amer-05.sun.com ([192.18.108.179]) by brmea-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l1NME1hw015635 for ; Fri, 23 Feb 2007 22:14:01 GMT Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JDX00B01SCJT000@mail-amer.sun.com> (original mail from Lance.Andersen@Sun.COM) for derby-dev@db.apache.org; Fri, 23 Feb 2007 15:14:01 -0700 (MST) Received: from [129.150.66.136] by mail-amer.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JDX004S5SFAFCE3@mail-amer.sun.com> for derby-dev@db.apache.org; Fri, 23 Feb 2007 15:14:00 -0700 (MST) Date: Fri, 23 Feb 2007 17:13:57 -0500 From: "Lance J. Andersen" Subject: Re: Global Temp tables In-reply-to: Sender: Lance.Andersen@Sun.COM To: derby-dev@db.apache.org Message-id: <45DF6725.8040109@sun.com> MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_oroI+4JpNLjGPiaHkyk5zQ)" References: <45DF0B36.8080103@sun.com> User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --Boundary_(ID_oroI+4JpNLjGPiaHkyk5zQ) Content-type: multipart/alternative; boundary="Boundary_(ID_hvXzQHn1Kjy4lrmJXdVuug)" --Boundary_(ID_hvXzQHn1Kjy4lrmJXdVuug) Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT Mamta, Thanks for taking the time to respond. I had the developer run this using the embedded driver and attached the log. It looks like the prepare is failing on the DECLARE. I have attached the log for your reference. Regards Lance Mamta Satoor wrote: > Lance, I am sure you have already checked following but wanted to > throw them out anyways > 1)Is the temporary table getting referenced by the same connection > that created it? > 2)Does your particular scenario work under embedded Derby? > > Also, once the connection that created the global table closes, the > global table cease to exist. > > I think it will be worth checking the script under embedded Derby to > rule out Network Server as the culprit. > > Mamta > > > On 2/23/07, *Lance J. Andersen* > wrote: > > Does anyone have an idea as to why the gobal table cannot be found. > > Here is the trace output. > > Regards > lance > > [TopLink Fine]: > ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DECLARE > GLOBAL TEMPORARY TABLE session.TL_CMP3_EMPLOYEE (EMP_ID INTEGER NOT > NULL, PAY_SCALE VARCHAR(255), ROOM_NUM INTEGER, F_NAME VARCHAR(255), > STATUS INTEGER, L_NAME VARCHAR(255), VERSION INTEGER, ADDR_ID INTEGER, > MANAGER_EMP_ID INTEGER, START_DATE DATE, END_DATE DATE, DEPT_ID > INTEGER, > PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED > [TopLink Fine]: > ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DECLARE > GLOBAL TEMPORARY TABLE session.TL_CMP3_SALARY (EMP_ID INTEGER NOT > NULL, > SALARY INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT > LOGGED > [TopLink Fine]: > ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--INSERT > INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION) SELECT > t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0, > CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND > (t1.EMP_ID = t0.EMP_ID)) > [TopLink Fine]: > ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DELETE > > FROM session.TL_CMP3_EMPLOYEE > [TopLink Fine]: > ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DELETE > FROM session.TL_CMP3_SALARY > [TopLink Warning]: > UnitOfWork(31852201)--Thread(Thread[AWT-EventQueue-0,6,main])--Local > Exception Stack: > Exception [TOPLINK-4002] (Oracle ${_EssentialsProductName} - > ${_EssentialsProductVersion} (Build 070220Dev)): > oracle.toplink.essentials.exceptions.DatabaseException > Internal Exception: org.apache.derby.client.am.SqlException : Table > 'SESSION.TL_CMP3_EMPLOYEE' does not exist.Error Code: -1 > Call:INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION) > SELECT t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0, > CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND > (t1.EMP_ID = t0.EMP_ID)) > Query:UpdateAllQuery() > > --Boundary_(ID_hvXzQHn1Kjy4lrmJXdVuug) Content-type: text/html; charset=ISO-8859-1 Content-transfer-encoding: 7BIT Mamta,

Thanks for taking the time to respond.


I had the developer run this using the embedded driver and attached the log.  It looks like the prepare is failing on the DECLARE.


I have attached the log for your reference.

Regards
Lance

Mamta Satoor wrote:
Lance, I am sure you have already checked following but wanted to throw them out anyways
1)Is the temporary table getting referenced by the same connection that created it?
2)Does your particular scenario work under embedded Derby?
 
Also, once the connection that created the global table closes, the global table cease to exist.
 
I think it will be worth checking the script under embedded Derby to rule out Network Server as the culprit.
 
Mamta

 
On 2/23/07, Lance J. Andersen <Lance.Andersen@sun.com> wrote:
Does anyone have an idea as to why the gobal table cannot be found.

Here is the trace output.

Regards
lance

[TopLink Fine]:
ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DECLARE
GLOBAL TEMPORARY TABLE session.TL_CMP3_EMPLOYEE (EMP_ID INTEGER NOT
NULL, PAY_SCALE VARCHAR(255), ROOM_NUM INTEGER, F_NAME VARCHAR(255),
STATUS INTEGER, L_NAME VARCHAR(255), VERSION INTEGER, ADDR_ID INTEGER,
MANAGER_EMP_ID INTEGER, START_DATE DATE, END_DATE DATE, DEPT_ID INTEGER,
PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED
[TopLink Fine]:
ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DECLARE
GLOBAL TEMPORARY TABLE session.TL_CMP3_SALARY (EMP_ID INTEGER NOT NULL,
SALARY INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED
[TopLink Fine]:
ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--INSERT
INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION) SELECT
t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0,
CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND
(t1.EMP_ID = t0.EMP_ID))
[TopLink Fine]:
ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DELETE
FROM session.TL_CMP3_EMPLOYEE
[TopLink Fine]:
ClientSession(12549034)--Connection(16309502)--Thread(Thread[AWT-EventQueue-0,6,main])--DELETE
FROM session.TL_CMP3_SALARY
[TopLink Warning]:
UnitOfWork(31852201)--Thread(Thread[AWT-EventQueue-0,6,main])--Local
Exception Stack:
Exception [TOPLINK-4002] (Oracle ${_EssentialsProductName} -
${_EssentialsProductVersion} (Build 070220Dev)):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: org.apache.derby.client.am.SqlException : Table
'SESSION.TL_CMP3_EMPLOYEE' does not exist.Error Code: -1
Call:INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION)
SELECT t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0,
CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND
(t1.EMP_ID = t0.EMP_ID))
Query:UpdateAllQuery()

--Boundary_(ID_hvXzQHn1Kjy4lrmJXdVuug)-- --Boundary_(ID_oroI+4JpNLjGPiaHkyk5zQ) Content-type: text/plain; name=derbyForTest.log Content-transfer-encoding: 7BIT Content-disposition: inline; filename=derbyForTest.log 2007-02-23 21:18:01.266 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_EMP_PROJ WHERE EXISTS(SELECT t0.EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) AND t0.EMP_ID = CMP3_EMP_PROJ.EMPLOYEES_EMP_ID) :End prepared statement 2007-02-23 21:18:01.266 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_SALARY WHERE EXISTS(SELECT t0.EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) AND t1.EMP_ID = CMP3_SALARY.EMP_ID) :End prepared statement 2007-02-23 21:18:01.266 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_EMPLOYEE WHERE NOT EXISTS(SELECT t0.EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE (t1.EMP_ID = t0.EMP_ID) AND t0.EMP_ID = CMP3_EMPLOYEE.EMP_ID) :End prepared statement 2007-02-23 21:18:01.282 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_ADDRESS WHERE (COUNTRY = 'testUpdateUsingTempStorage') :End prepared statement 2007-02-23 21:18:01.297 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: UPDATE CMP3_EMPLOYEE_SEQ SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? :End prepared statement with 2 parameters begin parameter #1: 50 :end parameter begin parameter #2: EMPLOYEE_SEQ :end parameter 2007-02-23 21:18:01.297 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: SELECT SEQ_COUNT FROM CMP3_EMPLOYEE_SEQ WHERE SEQ_NAME = ? :End prepared statement with 1 parameters begin parameter #1: EMPLOYEE_SEQ :end parameter 2007-02-23 21:18:01.313 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_ADDRESS (CITY, PROVINCE, STREET, P_CODE, COUNTRY) VALUES (?, ?, ?, ?, ?) :End prepared statement with 5 parameters begin parameter #1: 2 :end parameter begin parameter #2: :end parameter begin parameter #3: :end parameter begin parameter #4: :end parameter begin parameter #5: testUpdateUsingTempStorage :end parameter 2007-02-23 21:18:01.313 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: values IDENTITY_VAL_LOCAL() :End prepared statement 2007-02-23 21:18:01.313 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_ADDRESS (CITY, PROVINCE, STREET, P_CODE, COUNTRY) VALUES (?, ?, ?, ?, ?) :End prepared statement with 5 parameters begin parameter #1: 1 :end parameter begin parameter #2: :end parameter begin parameter #3: :end parameter begin parameter #4: :end parameter begin parameter #5: testUpdateUsingTempStorage :end parameter 2007-02-23 21:18:01.313 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: values IDENTITY_VAL_LOCAL() :End prepared statement 2007-02-23 21:18:01.313 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_ADDRESS (CITY, PROVINCE, STREET, P_CODE, COUNTRY) VALUES (?, ?, ?, ?, ?) :End prepared statement with 5 parameters begin parameter #1: 3 :end parameter begin parameter #2: :end parameter begin parameter #3: :end parameter begin parameter #4: :end parameter begin parameter #5: testUpdateUsingTempStorage :end parameter 2007-02-23 21:18:01.313 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: values IDENTITY_VAL_LOCAL() :End prepared statement 2007-02-23 21:18:01.313 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement 2007-02-23 21:18:01.329 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), End compiling prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement 2007-02-23 21:18:01.344 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 12 parameters begin parameter #1: 401 :end parameter begin parameter #2: null :end parameter begin parameter #3: 1 :end parameter begin parameter #4: testUpdateUsingTempStorage :end parameter begin parameter #5: null :end parameter begin parameter #6: 1 :end parameter begin parameter #7: 1 :end parameter begin parameter #8: null :end parameter begin parameter #9: 17 :end parameter begin parameter #10: null :end parameter begin parameter #11: null :end parameter begin parameter #12: null :end parameter 2007-02-23 21:18:01.344 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_SALARY (SALARY, EMP_ID) VALUES (?, ?) :End prepared statement with 2 parameters begin parameter #1: 100 :end parameter begin parameter #2: 401 :end parameter 2007-02-23 21:18:01.344 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 12 parameters begin parameter #1: 403 :end parameter begin parameter #2: null :end parameter begin parameter #3: 3 :end parameter begin parameter #4: testUpdateUsingTempStorage :end parameter begin parameter #5: null :end parameter begin parameter #6: 3 :end parameter begin parameter #7: 1 :end parameter begin parameter #8: null :end parameter begin parameter #9: 18 :end parameter begin parameter #10: null :end parameter begin parameter #11: null :end parameter begin parameter #12: null :end parameter 2007-02-23 21:18:01.344 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_SALARY (SALARY, EMP_ID) VALUES (?, ?) :End prepared statement with 2 parameters begin parameter #1: 300 :end parameter begin parameter #2: 403 :end parameter 2007-02-23 21:18:01.344 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 12 parameters begin parameter #1: 402 :end parameter begin parameter #2: null :end parameter begin parameter #3: 2 :end parameter begin parameter #4: testUpdateUsingTempStorage :end parameter begin parameter #5: null :end parameter begin parameter #6: 2 :end parameter begin parameter #7: 1 :end parameter begin parameter #8: null :end parameter begin parameter #9: 16 :end parameter begin parameter #10: null :end parameter begin parameter #11: null :end parameter begin parameter #12: null :end parameter 2007-02-23 21:18:01.360 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_SALARY (SALARY, EMP_ID) VALUES (?, ?) :End prepared statement with 2 parameters begin parameter #1: 200 :end parameter begin parameter #2: 402 :end parameter 2007-02-23 21:18:01.360 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:18:01.360 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2360), (SESSIONID = 41), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:18:01.360 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2357), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:18:01.360 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_EMPLOYEE (EMP_ID INTEGER NOT NULL, PAY_SCALE VARCHAR(255), ROOM_NUM INTEGER, F_NAME VARCHAR(255), STATUS INTEGER, L_NAME VARCHAR(255), VERSION INTEGER, MANAGER_EMP_ID INTEGER, ADDR_ID INTEGER, START_DATE DATE, END_DATE DATE, DEPT_ID INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_EMPLOYEE (EMP_ID INTEGER NOT NULL, PAY_SCALE VARCHAR(255), ROOM_NUM INTEGER, F_NAME VARCHAR(255), STATUS INTEGER, L_NAME VARCHAR(255), VERSION INTEGER, MANAGER_EMP_ID INTEGER, ADDR_ID INTEGER, START_DATE DATE, END_DATE DATE, DEPT_ID INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_SALARY (EMP_ID INTEGER NOT NULL, SALARY INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_SALARY (EMP_ID INTEGER NOT NULL, SALARY INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION) SELECT t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION) SELECT t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DELETE FROM session.TL_CMP3_EMPLOYEE :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DELETE FROM session.TL_CMP3_EMPLOYEE :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DELETE FROM session.TL_CMP3_SALARY :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DELETE FROM session.TL_CMP3_SALARY :End prepared statement 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Rolling back 2007-02-23 21:18:01.376 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2365), (SESSIONID = 42), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:19:36.516 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2358), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:19:36.516 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_EMP_PROJ WHERE EXISTS(SELECT t0.EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) AND t0.EMP_ID = CMP3_EMP_PROJ.EMPLOYEES_EMP_ID) :End prepared statement 2007-02-23 21:19:36.516 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_SALARY WHERE EXISTS(SELECT t0.EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) AND t1.EMP_ID = CMP3_SALARY.EMP_ID) :End prepared statement 2007-02-23 21:19:36.532 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_EMPLOYEE WHERE NOT EXISTS(SELECT t0.EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE (t1.EMP_ID = t0.EMP_ID) AND t0.EMP_ID = CMP3_EMPLOYEE.EMP_ID) :End prepared statement 2007-02-23 21:19:36.547 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: DELETE FROM CMP3_ADDRESS WHERE (COUNTRY = 'testUpdateUsingTempStorage') :End prepared statement 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_ADDRESS (CITY, PROVINCE, STREET, P_CODE, COUNTRY) VALUES (?, ?, ?, ?, ?) :End prepared statement with 5 parameters begin parameter #1: 3 :end parameter begin parameter #2: :end parameter begin parameter #3: :end parameter begin parameter #4: :end parameter begin parameter #5: testUpdateUsingTempStorage :end parameter 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: values IDENTITY_VAL_LOCAL() :End prepared statement 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_ADDRESS (CITY, PROVINCE, STREET, P_CODE, COUNTRY) VALUES (?, ?, ?, ?, ?) :End prepared statement with 5 parameters begin parameter #1: 2 :end parameter begin parameter #2: :end parameter begin parameter #3: :end parameter begin parameter #4: :end parameter begin parameter #5: testUpdateUsingTempStorage :end parameter 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: values IDENTITY_VAL_LOCAL() :End prepared statement 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_ADDRESS (CITY, PROVINCE, STREET, P_CODE, COUNTRY) VALUES (?, ?, ?, ?, ?) :End prepared statement with 5 parameters begin parameter #1: 1 :end parameter begin parameter #2: :end parameter begin parameter #3: :end parameter begin parameter #4: :end parameter begin parameter #5: testUpdateUsingTempStorage :end parameter 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: values IDENTITY_VAL_LOCAL() :End prepared statement 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 12 parameters begin parameter #1: 406 :end parameter begin parameter #2: null :end parameter begin parameter #3: 3 :end parameter begin parameter #4: testUpdateUsingTempStorage :end parameter begin parameter #5: null :end parameter begin parameter #6: 3 :end parameter begin parameter #7: 1 :end parameter begin parameter #8: null :end parameter begin parameter #9: 19 :end parameter begin parameter #10: null :end parameter begin parameter #11: null :end parameter begin parameter #12: null :end parameter 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_SALARY (SALARY, EMP_ID) VALUES (?, ?) :End prepared statement with 2 parameters begin parameter #1: 300 :end parameter begin parameter #2: 406 :end parameter 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 12 parameters begin parameter #1: 405 :end parameter begin parameter #2: null :end parameter begin parameter #3: 2 :end parameter begin parameter #4: testUpdateUsingTempStorage :end parameter begin parameter #5: null :end parameter begin parameter #6: 2 :end parameter begin parameter #7: 1 :end parameter begin parameter #8: null :end parameter begin parameter #9: 20 :end parameter begin parameter #10: null :end parameter begin parameter #11: null :end parameter begin parameter #12: null :end parameter 2007-02-23 21:19:36.563 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_SALARY (SALARY, EMP_ID) VALUES (?, ?) :End prepared statement with 2 parameters begin parameter #1: 200 :end parameter begin parameter #2: 405 :end parameter 2007-02-23 21:19:36.579 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_EMPLOYEE (EMP_ID, PAY_SCALE, ROOM_NUM, F_NAME, STATUS, L_NAME, VERSION, MANAGER_EMP_ID, ADDR_ID, START_DATE, END_DATE, DEPT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 12 parameters begin parameter #1: 404 :end parameter begin parameter #2: null :end parameter begin parameter #3: 1 :end parameter begin parameter #4: testUpdateUsingTempStorage :end parameter begin parameter #5: null :end parameter begin parameter #6: 1 :end parameter begin parameter #7: 1 :end parameter begin parameter #8: null :end parameter begin parameter #9: 21 :end parameter begin parameter #10: null :end parameter begin parameter #11: null :end parameter begin parameter #12: null :end parameter 2007-02-23 21:19:36.579 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Executing prepared statement: INSERT INTO CMP3_SALARY (SALARY, EMP_ID) VALUES (?, ?) :End prepared statement with 2 parameters begin parameter #1: 100 :end parameter begin parameter #2: 404 :end parameter 2007-02-23 21:19:36.579 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:19:36.579 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2371), (SESSIONID = 43), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:19:36.579 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2359), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_EMPLOYEE (EMP_ID INTEGER NOT NULL, PAY_SCALE VARCHAR(255), ROOM_NUM INTEGER, F_NAME VARCHAR(255), STATUS INTEGER, L_NAME VARCHAR(255), VERSION INTEGER, MANAGER_EMP_ID INTEGER, ADDR_ID INTEGER, START_DATE DATE, END_DATE DATE, DEPT_ID INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_EMPLOYEE (EMP_ID INTEGER NOT NULL, PAY_SCALE VARCHAR(255), ROOM_NUM INTEGER, F_NAME VARCHAR(255), STATUS INTEGER, L_NAME VARCHAR(255), VERSION INTEGER, MANAGER_EMP_ID INTEGER, ADDR_ID INTEGER, START_DATE DATE, END_DATE DATE, DEPT_ID INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_SALARY (EMP_ID INTEGER NOT NULL, SALARY INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DECLARE GLOBAL TEMPORARY TABLE session.TL_CMP3_SALARY (EMP_ID INTEGER NOT NULL, SALARY INTEGER, PRIMARY KEY (EMP_ID)) ON COMMIT DELETE ROWS NOT LOGGED :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION) SELECT t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, ROOM_NUM, VERSION) SELECT t0.EMP_ID, t1.SALARY, (t0.VERSION + 1) FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME = 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID)) :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DELETE FROM session.TL_CMP3_EMPLOYEE :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DELETE FROM session.TL_CMP3_EMPLOYEE :End prepared statement 2007-02-23 21:19:36.594 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Begin compiling prepared statement: DELETE FROM session.TL_CMP3_SALARY :End prepared statement 2007-02-23 21:19:36.610 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Error compiling prepared statement: DELETE FROM session.TL_CMP3_SALARY :End prepared statement 2007-02-23 21:19:36.610 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Rolling back 2007-02-23 21:19:36.610 GMT Thread[AWT-EventQueue-0,6,main] (XID = 2375), (SESSIONID = 44), (DATABASE = C:/Dev_ri/properties/Derby1), (DRDAID = null), Committing --Boundary_(ID_oroI+4JpNLjGPiaHkyk5zQ)--