db-ojb-dev mailing list archives

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