Hi All,
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?
Regards,
Chris
-----Original Message-----
From: Christopher Lowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 31, 2006 6:57 PM
To: 'OJB Users List'
Subject: RE: Super class record not being deleted.
Hi Armin,
I'm using the PersistenceBroker API.
Chris.
-----Original Message-----
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 31, 2006 4:08 PM
To: OJB Users List
Subject: Re: Super class record not being deleted.
Hi Chris,
which api do you use?
Armin
Christopher Lowe wrote:
> Hi All,
> I have an inheritance relationship between my Product and Car
> objects. New inserts of car objects work fine. The problem I'm
experiencing
> is that when I remove a car the corresponding product record is not being
> removed from the product table. The mappings are shown below. I'm using
> version db-ojb-1.0.4, the oscahce for caching, and the remote locking
> implementation. Is there something wrong with my mappings? I've included
my
> stack trace so that you can observe that the car and all the relationships
> are removed correctly, but not the product entry. Please advise.
>
> Thank you,
> Chris
>
> Mappings:
>
> <class-descriptor class="com.dm.beans.Product" schema="destinationdb"
> table="product">
> <field-descriptor name="id" column="ID" jdbc-type="INTEGER"
> primarykey="true" nullable="false" autoincrement="true"/>
> <field-descriptor name="supplierId" column="SUPPLIER_ID"
> jdbc-type="INTEGER"/>
> <field-descriptor name="name" column="NAME" jdbc-type="VARCHAR" />
> <field-descriptor name="ackOptLock" column="ACK_OPT_LOCK"
> jdbc-type="BIGINT" locking="true"/>
> <reference-descriptor
> name="supplier"
> class-ref="com.dm.beans.suppliers.Supplier"
> proxy="true"
> auto-update="link"
> auto-delete="none"
> >
> <foreignkey field-ref="supplierId"/>
> </reference-descriptor>
> </class-descriptor>
>
> <class-descriptor class="com.dm.beans.car.Car" schema="destinationdb"
> table="car">
> <field-descriptor name="id" column="ID" jdbc-type="INTEGER"
> primarykey="true" nullable="false"/>
> <field-descriptor name="modelId" column="MODEL_ID" jdbc-type="INTEGER"
> />
> <field-descriptor name="typeId" column="TYPE_ID" jdbc-type="INTEGER"
/>
> <field-descriptor name="largePassenger" column="LARGE_PASSENGER"
> jdbc-type="INTEGER" />
> <field-descriptor name="mediumPassenger" column="MEDIUM_PASSENGER"
> jdbc-type="INTEGER" />
> <field-descriptor name="smallPassenger" column="SMALL_PASSENGER"
> jdbc-type="INTEGER" />
> <field-descriptor name="largeLuggage" column="LARGE_LUGGAGE"
> jdbc-type="INTEGER" />
> <field-descriptor name="mediumLuggage" column="MEDIUM_LUGGAGE"
> jdbc-type="INTEGER" />
> <field-descriptor name="smallLuggage" column="SMALL_LUGGAGE"
> jdbc-type="INTEGER" />
> <field-descriptor name="quantity" column="QUANTITY"
jdbc-type="INTEGER"
> />
> <field-descriptor name="allocation" column="ALLOCATION"
> jdbc-type="INTEGER" />
> <field-descriptor name="ackOptLock" column="ACK_OPT_LOCK"
> jdbc-type="BIGINT" locking="true"/>
> <reference-descriptor
> name="super"
> class-ref="com.dm.beans.Product"
> >
> <foreignkey field-ref="id"/>
> </reference-descriptor>
> <reference-descriptor
> name="model"
> class-ref="com.dm.beans.type.CarModel"
> proxy="true"
> auto-update="link"
> auto-delete="false"
> >
> <foreignkey field-ref="modelId"/>
> </reference-descriptor>
> <reference-descriptor
> name="type"
> class-ref="com.dm.beans.type.CarType"
> proxy="true"
> auto-update="link"
> auto-delete="false"
> >
> <foreignkey field-ref="typeId"/>
> </reference-descriptor>
> <collection-descriptor
> name="amenities"
>
> collection-class="org.apache.ojb.broker.util.collections.RemovalAwareList"
> element-class-ref="com.dm.beans.type.Amenity"
> auto-update="link"
> auto-delete="link"
> proxy="true"
> indirection-table="product_amenity"
> >
> <fk-pointing-to-this-class column="PRODUCT_ID"/>
> <fk-pointing-to-element-class column="AMENITY_ID"/>
> </collection-descriptor>
> <collection-descriptor
> name="mediaFiles"
>
> collection-class="org.apache.ojb.broker.util.collections.RemovalAwareList"
> element-class-ref="com.dm.beans.Multimedia"
> auto-update="link"
> auto-delete="link"
> proxy="true"
> indirection-table="product_multimedia"
> >
> <fk-pointing-to-this-class column="PRODUCT_ID"/>
> <fk-pointing-to-element-class column="MULTIMEDIA_ID"/>
> </collection-descriptor>
> <collection-descriptor
> name="rates"
>
> collection-class="org.apache.ojb.broker.util.collections.RemovalAwareList"
> element-class-ref="com.dm.beans.car.CarRate"
> auto-update="true"
> auto-delete="true"
> proxy="true"
> >
> <inverse-foreignkey field-ref="productId"/>
> </collection-descriptor>
> </class-descriptor>
>
> Stack Trace:
>
> 2006-01-31 15:35:24,312 DEBUG implementations.CarDAOOJBImpl -
remove():
> 518
> 2006-01-31 15:35:24,312 DEBUG implementations.CarDAOOJBImpl -
remove():
> [EMAIL PROTECTED]
> id=518
> supplierId=<null>
> name=<null>
> modelId=<null>
> typeId=<null>
> adults=<null>
> children=<null>
> infants=<null>
> largeLuggage=<null>
> mediumLuggage=<null>
> smallLuggage=<null>
> quantity=<null>
> allocation=<null>
> ]
> [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
> SQL:DELETE FROM product_amenity WHERE PRODUCT_ID=?
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG:
executeUpdateSQL:
> DELETE FROM product_amenity WHERE PRODUCT_ID=?
> [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
> SQL:DELETE FROM product_multimedia WHERE PRODUCT_ID=?
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG:
executeUpdateSQL:
> DELETE FROM product_multimedia WHERE PRODUCT_ID=?
> [org.apache.ojb.broker.core.QueryReferenceBroker] DEBUG:
> getCollectionByQuery (class
> org.apache.ojb.broker.util.collections.RemovalAwareList, class
> com.dm.beans.car.CarRate, QueryByCriteria from class
> com.dm.beans.car.CarRate where [productId = 518])
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery:
> QueryByCriteria from class com.dm.beans.car.CarRate where [productId =
518]
> [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
> SQL:SELECT
>
A0.ID,A0.CAR_ID,A0.START_DATE,A0.END_DATE,A0.COMMISSION,A0.DAY1,A0.DAY2,A0.D
> AY3,A0.DAY4,A0.DAY5,A0.DAY6,A0.DAY7,A0.EXTRA,A0.ACK_OPT_LOCK FROM
> destinationdb.car_rate A0 WHERE A0.CAR_ID = ?
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery:
> [EMAIL PROTECTED]
> [org.apache.ojb.broker.accesslayer.RsIterator] DEBUG:
> RsIterator[org.apache.ojb.broker.accesslayer.RsQueryObject[query:
> QueryByCriteria from class com.dm.beans.car.CarRate where [productId =
> 518], class descriptor: com.dm.beans.car.CarRate]] 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]
> id=29
> commission=21%
> day1=49.15
> day2=98.3
> day3=136.13
> day4=181.5
> day5=198.0
> day6=198.0
> day7=198.0
> extra=28.29
> ]
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete:
> [EMAIL PROTECTED]
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete:
> [EMAIL PROTECTED]
> id=518
> supplierId=173
> name=Daihatsu - Mini Moke
> modelId=61
> typeId=7
> adults=2
> children=2
> infants=0
> largeLuggage=0
> mediumLuggage=0
> smallLuggage=1
> quantity=2
> allocation=2
> ]
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeDelete:
> [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
