[ http://issues.apache.org/jira/browse/OJB-93?page=all ]
Armin Waibel resolved OJB-93:
-----------------------------
Fix Version: 1.0.5
Resolution: Fixed
Add new tests for this issue in ...broker.InheritanceMultipleTableTest and
...odmg.InheritanceMultipleTableTest.
Fixed in PersistenceBrokerImpl
> 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
> Assignee: Armin Waibel
> Fix For: 1.0.5
>
> 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]
