Regards,
Chris
-----Original Message-----
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 02, 2006 4:59 PM
To: OJB Users List
Subject: Re: Super class record not being deleted.
Hi Chris,
I checked in a fix for OJB-93. If possible please test latest version
from SVN OJB_1_0_RELEASE branch. This fix will be included in next
upcoming version (OJB 1.0.5).
regards,
Armin
Armin Waibel wrote:
Hi Chris,
Christopher Lowe wrote:
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?
This sounds like a bug (thanks for detailed description). Could you add
a bug report on JIRA. I will start working on this issue ASAP.
regards,
Armin
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]
NCE_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:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
5492[
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]
5492[
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]
5492[
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.DEPARTM
ENT,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.DEPARTM
ENT,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.MANAGE
R_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.MANAGE
R_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]
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
