Super class record not being deleted.
-------------------------------------
Key: OJB-93
URL: http://issues.apache.org/jira/browse/OJB-93
Project: OJB
Type: Bug
Components: PB-API
Versions: 1.0.4
Environment: Mysql Database.
Reporter: Christopher Lowe
I ran the junit test suite for the broker api and got the same result. When a
base class object is deleted the corresponding record in the database is
removed but not the super class object record. I ran only the testDelete()
method in the InheritanceMultipleTableTest class. I'm attaching the output with
debug on for the sql output. Please see the attached file. Is anyone else
getting this problem? Is there a fix for this?
Below is the output from the test:-
Testsuite: org.apache.ojb.broker.AllTests
Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 3.235 sec
------------- Standard Output ---------------
[BOOT] INFO: -- boot log messages -->
[BOOT] INFO: Loading OJB's properties:
file:/C:/db-ojb-1.0.4/target/test/ojb/OJB.properties
[BOOT] INFO: Found logging properties file: OJB-logging.properties
[BOOT] INFO: Logging: Found logger class
'org.apache.ojb.broker.util.logging.PoorMansLoggerImpl
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
id=<null>
id_2=1138898488078
name=employee_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:INSERT INTO INHERITANCE_EMPLOYEE (OBJ_ID,OBJ_ID_2,NAME,FK_ADDRESS) VALUES
(?,?,?,?)
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.TABLENAME,A0.MAX_KEY,A0.GRAB_SIZE,A0.VERSION FROM OJB_HL_SEQ A0
WHERE A0.TABLENAME = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.TABLENAME,A0.MAX_KEY,A0.GRAB_SIZE,A0.VERSION FROM OJB_HL_SEQ A0
WHERE A0.TABLENAME = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate: [EMAIL
PROTECTED],grabSize=20,version=1,maxKey=200040,currentKey=200020]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:UPDATE OJB_HL_SEQ SET MAX_KEY=?,GRAB_SIZE=?,VERSION=? WHERE TABLENAME = ?
AND VERSION = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.mysql.jdbc.ServerPreparedStatement[2] - UPDATE OJB_HL_SEQ SET
MAX_KEY=200040,GRAB_SIZE=20,VERSION=2 WHERE TABLENAME =
'SEQ_INHERITANCE_EMPLOYEE' AND VERSION = 1
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[1] - INSERT INTO INHERITANCE_EMPLOYEE
(OBJ_ID,OBJ_ID_2,NAME,FK_ADDRESS) VALUES
(200021,1138898488078,'employee_testDelete_1138898488078',null)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
[EMAIL PROTECTED]
department=department_1
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
], [EMAIL PROTECTED]
department=department_2
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]]
consortiumKey=<null>
department=<null>
manager=<null>
id=<null>
id_2=1138898488078
name=manager_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[2] - INSERT INTO INHERITANCE_EMPLOYEE
(OBJ_ID,OBJ_ID_2,NAME,FK_ADDRESS) VALUES
(200022,1138898488078,'manager_testDelete_1138898488078',null)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
[EMAIL PROTECTED]
department=department_1
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
], [EMAIL PROTECTED]
department=department_2
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]]
consortiumKey=<null>
department=<null>
manager=<null>
id=200022
id_2=1138898488078
name=manager_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:INSERT INTO INHERITANCE_EXECUTIVE
(OBJ_ID,OBJ_ID_2,DEPARTMENT,MANAGER_ID,MANAGER_ID_2) VALUES (?,?,?,?,?)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[3] - INSERT INTO INHERITANCE_EXECUTIVE
(OBJ_ID,OBJ_ID_2,DEPARTMENT,MANAGER_ID,MANAGER_ID_2) VALUES
(200022,1138898488078,null,null,null)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
[EMAIL PROTECTED]
department=department_1
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
], [EMAIL PROTECTED]
department=department_2
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]]
consortiumKey=<null>
department=<null>
manager=<null>
id=200022
id_2=1138898488078
name=manager_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:INSERT INTO INHERITANCE_MANAGER (OBJ_ID,OBJ_ID_2,FK_CONSORTIUM) VALUES
(?,?,?)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[4] - INSERT INTO INHERITANCE_MANAGER
(OBJ_ID,OBJ_ID_2,FK_CONSORTIUM) VALUES (200022,1138898488078,null)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
department=department_1
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[5] - INSERT INTO INHERITANCE_EMPLOYEE
(OBJ_ID,OBJ_ID_2,NAME,FK_ADDRESS) VALUES
(200023,1138898488078,'executive_testDelete_1138898488078',null)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
department=department_1
manager=<null>
id=200023
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[6] - INSERT INTO INHERITANCE_EXECUTIVE
(OBJ_ID,OBJ_ID_2,DEPARTMENT,MANAGER_ID,MANAGER_ID_2) VALUES
(200023,1138898488078,'department_1',200022,1138898488078)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
department=department_2
manager=<null>
id=<null>
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[7] - INSERT INTO INHERITANCE_EMPLOYEE
(OBJ_ID,OBJ_ID_2,NAME,FK_ADDRESS) VALUES
(200024,1138898488078,'executive_testDelete_1138898488078',null)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert: [EMAIL
PROTECTED]
department=department_2
manager=<null>
id=200024
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.mysql.jdbc.ServerPreparedStatement[8] - INSERT INTO INHERITANCE_EXECUTIVE
(OBJ_ID,OBJ_ID_2,DEPARTMENT,MANAGER_ID,MANAGER_ID_2) VALUES
(200024,1138898488078,'department_2',200022,1138898488078)
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.NAME,A0.FK_ADDRESS,A1.OBJ_ID,A1.OBJ_ID_2,A1.DEPARTMENT,A1.MANAGER_ID,A1.MANAGER_ID_2,A2.OBJ_ID,A2.OBJ_ID_2,A2.FK_CONSORTIUM,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' WHEN A2.OBJ_ID
IS NOT NULL AND A2.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' WHEN A1.OBJ_ID IS
NOT NULL AND A1.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Executive' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Employee' END AS OJB_CLAZZ
FROM INHERITANCE_EMPLOYEE A0 LEFT OUTER JOIN INHERITANCE_EXECUTIVE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_MANAGER A2 ON A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.OBJ_ID = ?) AND A0.OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.NAME,A0.FK_ADDRESS,A1.OBJ_ID,A1.OBJ_ID_2,A1.DEPARTMENT,A1.MANAGER_ID,A1.MANAGER_ID_2,A2.OBJ_ID,A2.OBJ_ID_2,A2.FK_CONSORTIUM,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' WHEN A2.OBJ_ID
IS NOT NULL AND A2.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' WHEN A1.OBJ_ID IS
NOT NULL AND A1.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Executive' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Employee' END AS OJB_CLAZZ
FROM INHERITANCE_EMPLOYEE A0 LEFT OUTER JOIN INHERITANCE_EXECUTIVE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_MANAGER A2 ON A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.OBJ_ID = ?) AND A0.OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.DEPARTMENT,A0.MANAGER_ID,A0.MANAGER_ID_2,A1.NAME,A1.FK_ADDRESS,A2.OBJ_ID,A2.OBJ_ID_2,A2.FK_CONSORTIUM,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' WHEN A2.OBJ_ID
IS NOT NULL AND A2.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Executive' END AS OJB_CLAZZ
FROM INHERITANCE_EXECUTIVE A0 INNER JOIN INHERITANCE_EMPLOYEE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_MANAGER A2 ON A0.OBJ_ID=A2.OBJ_ID AND A0.OBJ_ID_2=A2.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.OBJ_ID = ?) AND A0.OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.DEPARTMENT,A0.MANAGER_ID,A0.MANAGER_ID_2,A1.NAME,A1.FK_ADDRESS,A2.OBJ_ID,A2.OBJ_ID_2,A2.FK_CONSORTIUM,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' WHEN A2.OBJ_ID
IS NOT NULL AND A2.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Executive' END AS OJB_CLAZZ
FROM INHERITANCE_EXECUTIVE A0 INNER JOIN INHERITANCE_EMPLOYEE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_MANAGER A2 ON A0.OBJ_ID=A2.OBJ_ID AND A0.OBJ_ID_2=A2.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.OBJ_ID = ?) AND A0.OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.FK_CONSORTIUM,A1.DEPARTMENT,A1.MANAGER_ID,A1.MANAGER_ID_2,A2.NAME,A2.FK_ADDRESS,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' END AS OJB_CLAZZ
FROM INHERITANCE_MANAGER A0 INNER JOIN INHERITANCE_EXECUTIVE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 INNER JOIN INHERITANCE_EMPLOYEE
A2 ON A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_SHAREHOLDER A3 ON A0.OBJ_ID=A3.OBJ_ID AND A0.OBJ_ID_2=A3.OBJ_ID_2
WHERE (A0.OBJ_ID = ?) AND A0.OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.FK_CONSORTIUM,A1.DEPARTMENT,A1.MANAGER_ID,A1.MANAGER_ID_2,A2.NAME,A2.FK_ADDRESS,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' END AS OJB_CLAZZ
FROM INHERITANCE_MANAGER A0 INNER JOIN INHERITANCE_EXECUTIVE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 INNER JOIN INHERITANCE_EMPLOYEE
A2 ON A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_SHAREHOLDER A3 ON A0.OBJ_ID=A3.OBJ_ID AND A0.OBJ_ID_2=A3.OBJ_ID_2
WHERE (A0.OBJ_ID = ?) AND A0.OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery:
ReportQuery from class
org.apache.ojb.broker.InheritanceMultipleTableTest$Executive count(*) where
[managerId = 200022, managerId_2 = 1138898488078]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT count(*) FROM INHERITANCE_EXECUTIVE A0 INNER JOIN
INHERITANCE_EMPLOYEE A1 ON A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_MANAGER A2 ON A0.OBJ_ID=A2.OBJ_ID AND
A0.OBJ_ID_2=A2.OBJ_ID_2 LEFT OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON
A2.OBJ_ID=A3.OBJ_ID AND A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.MANAGER_ID = ?) AND
A0.MANAGER_ID_2 = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery:
com.mysql.jdbc.ServerPreparedStatement[12] - SELECT count(*) FROM
INHERITANCE_EXECUTIVE A0 INNER JOIN INHERITANCE_EMPLOYEE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_MANAGER A2 ON A0.OBJ_ID=A2.OBJ_ID AND A0.OBJ_ID_2=A2.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.MANAGER_ID = 200022) AND A0.MANAGER_ID_2 =
1138898488078
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete: [EMAIL
PROTECTED]
id=200021
id_2=1138898488078
name=employee_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:DELETE FROM INHERITANCE_EMPLOYEE WHERE OBJ_ID = ? AND OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete:
com.mysql.jdbc.ServerPreparedStatement[13] - DELETE FROM INHERITANCE_EMPLOYEE
WHERE OBJ_ID = 200021 AND OBJ_ID_2 = 1138898488078
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete: [EMAIL
PROTECTED]
department=department_1
manager=<null>
id=200023
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:DELETE FROM INHERITANCE_EXECUTIVE WHERE OBJ_ID = ? AND OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete:
com.mysql.jdbc.ServerPreparedStatement[14] - DELETE FROM INHERITANCE_EXECUTIVE
WHERE OBJ_ID = 200023 AND OBJ_ID_2 = 1138898488078
[org.apache.ojb.broker.core.QueryReferenceBroker] DEBUG: getCollectionByQuery
(class org.apache.ojb.broker.util.collections.RemovalAwareCollection, class
org.apache.ojb.broker.InheritanceMultipleTableTest$Executive, QueryByCriteria
from class org.apache.ojb.broker.InheritanceMultipleTableTest$Executive where
[managerId = 200022, managerId_2 = 1138898488078])
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery:
QueryByCriteria from class
org.apache.ojb.broker.InheritanceMultipleTableTest$Executive where [managerId
= 200022, managerId_2 = 1138898488078]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.DEPARTMENT,A0.MANAGER_ID,A0.MANAGER_ID_2,A1.NAME,A1.FK_ADDRESS,A2.OBJ_ID,A2.OBJ_ID_2,A2.FK_CONSORTIUM,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' WHEN A2.OBJ_ID
IS NOT NULL AND A2.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Executive' END AS OJB_CLAZZ
FROM INHERITANCE_EXECUTIVE A0 INNER JOIN INHERITANCE_EMPLOYEE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_MANAGER A2 ON A0.OBJ_ID=A2.OBJ_ID AND A0.OBJ_ID_2=A2.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.MANAGER_ID = ?) AND A0.MANAGER_ID_2 = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery:
com.mysql.jdbc.ServerPreparedStatement[15] - SELECT
A0.OBJ_ID,A0.OBJ_ID_2,A0.DEPARTMENT,A0.MANAGER_ID,A0.MANAGER_ID_2,A1.NAME,A1.FK_ADDRESS,A2.OBJ_ID,A2.OBJ_ID_2,A2.FK_CONSORTIUM,A3.OBJ_ID,A3.OBJ_ID_2,A3.SHARE_,CASE
WHEN A3.OBJ_ID IS NOT NULL AND A3.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Shareholder' WHEN A2.OBJ_ID
IS NOT NULL AND A2.OBJ_ID_2 IS NOT NULL THEN
'org.apache.ojb.broker.InheritanceMultipleTableTest$Manager' ELSE
'org.apache.ojb.broker.InheritanceMultipleTableTest$Executive' END AS OJB_CLAZZ
FROM INHERITANCE_EXECUTIVE A0 INNER JOIN INHERITANCE_EMPLOYEE A1 ON
A0.OBJ_ID=A1.OBJ_ID AND A0.OBJ_ID_2=A1.OBJ_ID_2 LEFT OUTER JOIN
INHERITANCE_MANAGER A2 ON A0.OBJ_ID=A2.OBJ_ID AND A0.OBJ_ID_2=A2.OBJ_ID_2 LEFT
OUTER JOIN INHERITANCE_SHAREHOLDER A3 ON A2.OBJ_ID=A3.OBJ_ID AND
A2.OBJ_ID_2=A3.OBJ_ID_2 WHERE (A0.MANAGER_ID = 200022) AND A0.MANAGER_ID_2 =
1138898488078
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG:
RsIterator[org.apache.ojb.broker.accesslayer.RsQueryObject[query:
QueryByCriteria from class
org.apache.ojb.broker.InheritanceMultipleTableTest$Executive where [managerId
= 200022, managerId_2 = 1138898488078], class descriptor:
org.apache.ojb.broker.InheritanceMultipleTableTest$Executive]] initialized
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> true
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> false
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete: [EMAIL
PROTECTED]
department=department_2
manager=<null>
id=200024
id_2=1138898488078
name=executive_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete:
com.mysql.jdbc.ServerPreparedStatement[16] - DELETE FROM INHERITANCE_EXECUTIVE
WHERE OBJ_ID = 200024 AND OBJ_ID_2 = 1138898488078
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete: [EMAIL
PROTECTED]
[EMAIL PROTECTED]
consortiumKey=<null>
department=<null>
manager=<null>
id=200022
id_2=1138898488078
name=manager_testDelete_1138898488078
address=<null>
]
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:DELETE FROM INHERITANCE_MANAGER WHERE OBJ_ID = ? AND OBJ_ID_2 = ?
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete:
com.mysql.jdbc.ServerPreparedStatement[17] - DELETE FROM INHERITANCE_MANAGER
WHERE OBJ_ID = 200022 AND OBJ_ID_2 = 1138898488078
------------- ---------------- ---------------
Testcase: testDelete took 2.828 sec
Testcase: testHsqldbShutdown took 0.016 sec
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
