You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by "Armin Waibel (JIRA)" <ji...@apache.org> on 2006/02/02 19:36:04 UTC
[jira] Assigned: (OJB-93) Super class record not being deleted.
[ http://issues.apache.org/jira/browse/OJB-93?page=all ]
Armin Waibel reassigned OJB-93:
-------------------------------
Assign To: Armin Waibel
> 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
>
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Employee@15856a5[
> 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: org.apache.ojb.broker.util.sequence.HighLowSequence@f42ad0[name=SEQ_INHERITANCE_EMPLOYEE,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: org.apache.ojb.broker.InheritanceMultipleTableTest$Manager@9980d5[
> executives=[org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@1d95492[
> department=department_1
> manager=<null>
> id=<null>
> id_2=1138898488078
> name=executive_testDelete_1138898488078
> address=<null>
> ], org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@13f7281[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Manager@9980d5[
> executives=[org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@1d95492[
> department=department_1
> manager=<null>
> id=<null>
> id_2=1138898488078
> name=executive_testDelete_1138898488078
> address=<null>
> ], org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@13f7281[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Manager@9980d5[
> executives=[org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@1d95492[
> department=department_1
> manager=<null>
> id=<null>
> id_2=1138898488078
> name=executive_testDelete_1138898488078
> address=<null>
> ], org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@13f7281[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@1d95492[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@1d95492[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@13f7281[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@13f7281[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Employee@4f459c[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@193c0cf[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Executive@da6bf4[
> 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: org.apache.ojb.broker.InheritanceMultipleTableTest$Manager@11381e7[
> executives=org.apache.ojb.broker.core.proxy.ListProxyDefaultImpl@100363
> 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: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org