db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lance J. Andersen" <Lance.Ander...@Sun.COM>
Subject Re: Global Temp tables
Date Fri, 23 Feb 2007 22:43:15 GMT
I think part of the problem is the application is using PRIMARY KEY 
(EMP_ID) in the creation of the table:

: 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


The error message is not that helpful :-(

Error code -1, SQL state 42995: The requested function does not apply to 
global temporary tables.
Line 1, column 2


Lance J. Andersen wrote:
> 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 
>> <mailto: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()
>>
>>
> ------------------------------------------------------------------------
>
> 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
>   

Mime
View raw message