db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Armin Waibel (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (OJB-93) Super class record not being deleted.
Date Thu, 02 Feb 2006 20:55:04 GMT
     [ 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: 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


Mime
View raw message