Hi Armin, Thanks for the quick turn-around on this bug. How do I download the source from svn ojb_1_0_release branch? Do I have to use my browser and click on each file to download everything, I'm sure there is a better way, please advise. How soon will the bug OJB-94 be assigned and fixed. It is critical to our project that we have this fixed.
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]
