Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 96857 invoked from network); 13 Dec 2003 12:36:18 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 13 Dec 2003 12:36:18 -0000 Received: (qmail 48947 invoked by uid 500); 13 Dec 2003 12:36:16 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 48918 invoked by uid 500); 13 Dec 2003 12:36:15 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 48903 invoked from network); 13 Dec 2003 12:36:14 -0000 Received: from unknown (HELO mailout03.aul.t-online.de) (194.25.134.81) by daedalus.apache.org with SMTP; 13 Dec 2003 12:36:14 -0000 Received: from fwd05.aul.t-online.de by mailout03.aul.t-online.de with smtp id 1AV90H-0002TE-06; Sat, 13 Dec 2003 13:36:13 +0100 Received: from code-au-lait.de (bROMBGZDgexb7pkSga6fpbyzpLRikuTwu9hqYsJokPz2QEa1+2Hc0Z@[80.145.117.175]) by fmrl05.sul.t-online.com with esmtp id 1AV909-0qGOK80; Sat, 13 Dec 2003 13:36:05 +0100 Message-ID: <3FDB07B0.20903@code-au-lait.de> Date: Sat, 13 Dec 2003 13:36:00 +0100 From: Armin Waibel User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Developers List Subject: Re: [BUG] Prefetch/query bug? References: <3FDA3C57.2050609@code-au-lait.de> <3FDAFF68.2030800@gmx.ch> <3FDB01BE.9010305@code-au-lait.de> <3FDB028E.6070709@gmx.ch> In-Reply-To: <3FDB028E.6070709@gmx.ch> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Seen: false X-ID: bROMBGZDgexb7pkSga6fpbyzpLRikuTwu9hqYsJokPz2QEa1+2Hc0Z@t-dialin.net X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi Jakob, Jakob Braeuchi wrote: > hi armin, > > what puzzled me first is that prefetching is used although no > relationship is marked to be prefetched in the query. > > is this auto-prefetch feature and the different behaviour of > getIterator.. and getCollectiuon.. documented somewhere ? > Sorry Jakob, I don't have a clue. Thought you are involved in implementing the prefetch-feature? regards, Armin > jakob > > > Armin Waibel wrote: > >> Hi Jakob, >> >> Jakob Braeuchi wrote: >> >>> hi armin, andy, >>> >>> the problem is that the class-descriptor of the itemClass is used. i >>> fixed it by using the class-descriptor of the class of the real object. >>> >> great!! Thanks! >> >>> btw: what's the scarab defect number ? >>> >> I don't fire a scarab bug report - sorry I was too lazy for such a >> painful odyssee ;-) >> >> regards, >> Armin >> >>> hth >>> jakob >>> >>> Armin Waibel wrote: >>> >>>> Hi all, >>>> >>>> Andy Malakov reported me a *serious* bug in conjunction with >>>> PB.getCollectionByQuery >>>> PB.getIteratorByQuery >>>> >>>> Seems that these method return different result for the same query. >>>> I checked in a modified version of his test cases >>>> ...broker.CollectionTest#testOneBookShelfQueryByIterator() >>>> ...broker.CollectionTest#testOneBookShelfQueryByCollection() >>>> >>>> first one pass, second fail. (metadata in >>>> repository_junit_reference.xml) >>>> >>>> Below see his original post with detailed description of what is >>>> going on (p6spy output for failing test see below too). >>>> >>>> Needs to be fixed before rc5!! >>>> >>>> regards, >>>> Armin >>>> >>>> -------- Original Message -------- >>>> Subject: Reference to base class Re: OJB >>>> Date: Fri, 12 Dec 2003 11:14:30 -0500 >>>> From: Andy Malakov >>>> >>>> >>>> Hello Armin, >>>> >>>> Thanks for submitting that fix. >>>> >>>> >>>> What troubles me is that I found some problem retrieving collections of >>>> objects that have reference to extent. Problem exists in "CVS HEAD" >>>> and didn't exist in RC4. /Very/ easy to reproduce. >>>> >>>> Say, I have class BookShelf that has list of BookShelfItems. There are >>>> several kinds of BookShelfItems: Books, DVDs, etc. >>>> >>>> >>>> *public class BookShelf { >>>> private int pk; >>>> private List /*of BookShelfItem*/ items;* >>>> * ...* >>>> *}* >>>> ** >>>> *public abstract class BookShelfItem { >>>> private int pk; >>>> private BookShelf shelf;* >>>> * ...* >>>> *}* >>>> ** >>>> *public class Book extends BookShelfItem {* >>>> *...* >>>> *} >>>> * >>>> *public class DVD extends BookShelfItem {* >>>> *...* >>>> *}* >>>> >>>> >>>> Now if I create a bookshelf with one book and one DVD, I can load it >>>> via >>>> getIteratorByQuery() without any problems: >>>> >>>> *b.getIteratorByQuery(new QueryByCriteria (BookShelf.class, new >>>> Criteria >>>> ()));* >>>> >>>> But when I try to use getCollectionByQuery(), I each bookshelf _only >>>> has >>>> one item_ (!) [More precisely one kind of items in case of larger >>>> number >>>> of items] >>>> >>>> *b.getCollectionByQuery(new QueryByCriteria (BookShelf.class, new >>>> Criteria ()));* >>>> >>>> After some debugging I found what looks like a problem in >>>> >>>> When CollectionPrefetcher.associateBatched(Collection owners, >>>> Collection >>>> children) associates bookshelfs with items (at this moment I can see >>>> that both collections contain valid number of items) it have problems >>>> findinf foreign key values in child items. >>>> >>>> CollectionPrefetcher, line178 (CVS): >>>> * for (Iterator it = children.iterator(); it.hasNext(); ) >>>> { >>>> relatedObject = it.next(); // child item >>>> fkValues = cds.getForeignKeyValues(relatedObject, cld);* >>>> >>>> >>>> Problem is caused by the fact that *getForeignKeyValues* [in case of >>>> reference to base class] will search for foreign keys *only in class >>>> descriptor of first concrete class* (!). >>>> >>>> ObjectReferenceDescriptor, line 143 (CVS): >>>> >>>> * Class firstConcreteClass = (Class) extents.get(0); >>>> mif = >>>> getClassDescriptor().getRepository().getDescriptorFor(firstConcreteClass); >>>> >>>> * >>>> >>>> I have the above example as simple JUnit test case (attached). Let me >>>> know - I will be happy to provide any additional information. >>>> >>>> I can also submit a bugreport into Scarab. >>>> >>>> Thanks a lot, >>>> Andy >>>> >>>> >>>> p6spy output for failing test >>>> >>>> 1071266171376|20|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE 'SEQ_COLLECTION_GATHERER' >>>> 1071266171376|0|0|statement||SELECT MAX(GAT_ID) FROM >>>> COLLECTION_GATHERER >>>> 1071266171386|0|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COLLECTION_GATHERER','deprecatedColumn','20','20','1') >>>> 1071266171386|0|1|commit|| >>>> 1071266171396|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '1' >>>> 1071266171396|0|0|statement|INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES (?,?) |INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES >>>> ('1','1071266170485_testStoreDeleteSimpleCollections') >>>> 1071266171406|10|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE >>>> 'SEQ_COLLECTION_COLLECTIBLE_BASE' >>>> 1071266171406|0|0|statement||SELECT MAX(COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_BASE >>>> 1071266171406|0|0|statement||SELECT MAX(COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_B >>>> 1071266171406|0|0|statement||SELECT MAX(COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_C >>>> 1071266171406|0|0|statement||SELECT MAX(COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_D >>>> 1071266171406|0|0|statement||SELECT MAX(COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_D >>>> 1071266171406|0|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COLLECTION_COLLECTIBLE_BASE','deprecatedColumn','20','20','1') >>>> 1071266171406|0|1|commit|| >>>> 1071266171416|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '1' >>>> 1071266171416|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('1','col_1071266170485_colBase_1','1') >>>> 1071266171416|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '2' >>>> 1071266171416|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('2','col_1071266170485_colBase_2','1') >>>> 1071266171416|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '3' >>>> 1071266171416|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('3','col_1071266170485_colBase_3','1') >>>> 1071266171416|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '4' >>>> 1071266171426|10|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('4','col_1071266170485_colB_1','1') >>>> 1071266171426|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '5' >>>> 1071266171426|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('5','col_1071266170485_colB_2','1') >>>> 1071266171426|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '6' >>>> 1071266171426|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('6','col_1071266170485_colB_3','1') >>>> 1071266171426|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '7' >>>> 1071266171426|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('7','col_1071266170485_colB_4','1') >>>> 1071266171426|0|0|commit|| >>>> 1071266171426|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '1' >>>> 1071266171436|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = '1' ORDER BY 3 DESC >>>> 1071266171446|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = '1' ORDER BY 4 DESC >>>> 1071266171446|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '1' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleD' ) ORDER BY 4 DESC >>>> 1071266171476|0|0|statement|SELECT count(A0.COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = ? |SELECT >>>> count(A0.COL_ID) FROM COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = >>>> '1' >>>> 1071266171476|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = '1' ORDER BY 3 DESC >>>> 1071266171476|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266170485_colBase%' >>>> 1071266171486|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266170485_colB%' >>>> 1071266171496|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171496|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171496|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171496|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171507|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '7' >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '6' >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '5' >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '4' >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_BASE >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_BASE WHERE >>>> COL_ID = '3' >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_BASE >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_BASE WHERE >>>> COL_ID = '2' >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_BASE >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_BASE WHERE >>>> COL_ID = '1' >>>> 1071266171507|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = '1' ORDER BY 4 DESC >>>> 1071266171507|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '1' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleDD' ) ORDER BY 4 DESC >>>> 1071266171507|0|0|statement|DELETE FROM COLLECTION_GATHERER WHERE >>>> GAT_ID = ? |DELETE FROM COLLECTION_GATHERER WHERE GAT_ID = '1' >>>> 1071266171507|0|0|commit|| >>>> 1071266171507|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '1' >>>> 1071266171517|10|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266170485_colBase%' >>>> 1071266171517|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266170485_colB%' >>>> 1071266171517|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171517|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171517|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171517|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171517|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266170485%' >>>> 1071266171527|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '2' >>>> 1071266171527|0|0|statement|INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES (?,?) |INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES >>>> ('2','1071266171517_testDeleteCollectionDoRemoveCollectionObjectBeforeDelete') >>>> >>>> 1071266171527|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '8' >>>> 1071266171527|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('8','col_1071266171517_colBase_1','2') >>>> 1071266171527|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '9' >>>> 1071266171527|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('9','col_1071266171517_colBase_2','2') >>>> 1071266171527|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '10' >>>> 1071266171527|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('10','col_1071266171517_colBase_3','2') >>>> 1071266171527|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '11' >>>> 1071266171527|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('11','col_1071266171517_colB_1','2') >>>> 1071266171527|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '12' >>>> 1071266171527|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('12','col_1071266171517_colB_2','2') >>>> 1071266171527|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '13' >>>> 1071266171527|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('13','col_1071266171517_colB_3','2') >>>> 1071266171537|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '14' >>>> 1071266171537|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('14','col_1071266171517_colB_4','2') >>>> 1071266171537|0|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE 'SEQ_COLLECTION_COLLECTIBLE_CC' >>>> 1071266171537|0|0|statement||SELECT MAX(COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_CC >>>> 1071266171537|0|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COLLECTION_COLLECTIBLE_CC','deprecatedColumn','20','20','1') >>>> 1071266171537|0|1|commit|| >>>> 1071266171537|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CC WHERE >>>> COL_ID = '1' >>>> 1071266171537|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('1','col_1071266171517_colCC_1','','ext1') >>>> 1071266171537|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CC WHERE >>>> COL_ID = '2' >>>> 1071266171547|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('2','col_1071266171517_colCC_2','','ext2') >>>> 1071266171547|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CC WHERE >>>> COL_ID = '3' >>>> 1071266171547|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('3','col_1071266171517_colCC_3','','ext3') >>>> 1071266171557|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CC WHERE >>>> COL_ID = '4' >>>> 1071266171557|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('4','col_1071266171517_colCC_4','','ext4') >>>> 1071266171557|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CC WHERE >>>> COL_ID = '5' >>>> 1071266171557|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('5','col_1071266171517_colCC_5','','ext5') >>>> 1071266171557|0|0|commit|| >>>> 1071266171557|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '2' >>>> 1071266171557|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = '2' ORDER BY 3 DESC >>>> 1071266171557|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = '2' ORDER BY 4 DESC >>>> 1071266171557|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '2' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleD' ) ORDER BY 4 DESC >>>> 1071266171567|0|0|statement|SELECT count(A0.COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = ? |SELECT >>>> count(A0.COL_ID) FROM COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = >>>> '2' >>>> 1071266171567|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = '2' ORDER BY 3 DESC >>>> 1071266171577|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171517_colBase%' >>>> 1071266171577|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171517_colB%' >>>> 1071266171577|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171577|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171577|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171577|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171577|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171577|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '14' >>>> 1071266171577|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '13' >>>> 1071266171577|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '12' >>>> 1071266171597|20|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_B >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID >>>> = '11' >>>> 1071266171597|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_BASE >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_BASE WHERE >>>> COL_ID = '10' >>>> 1071266171597|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_BASE >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_BASE WHERE >>>> COL_ID = '9' >>>> 1071266171597|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_BASE >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_BASE WHERE >>>> COL_ID = '8' >>>> 1071266171597|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = '2' ORDER BY 4 DESC >>>> 1071266171597|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '2' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleDD' ) ORDER BY 4 DESC >>>> 1071266171597|0|0|statement|DELETE FROM COLLECTION_GATHERER WHERE >>>> GAT_ID = ? |DELETE FROM COLLECTION_GATHERER WHERE GAT_ID = '2' >>>> 1071266171597|0|0|commit|| >>>> 1071266171597|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '2' >>>> 1071266171607|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171517_colBase%' >>>> 1071266171607|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171517_colB%' >>>> 1071266171607|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171607|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171607|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171607|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171607|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171517%' >>>> 1071266171607|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '3' >>>> 1071266171607|0|0|statement|INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES (?,?) |INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES >>>> ('3','1071266171607_testDeleteMainObjectWithOneToNRelation') >>>> 1071266171617|10|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE 'SEQ_COLLECTION_COLLECTIBLE_CCC' >>>> 1071266171617|0|0|statement||SELECT MAX(COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_CCC >>>> 1071266171617|0|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COLLECTION_COLLECTIBLE_CCC','deprecatedColumn','20','20','1') >>>> 1071266171617|0|1|commit|| >>>> 1071266171637|10|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CCC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '1' >>>> 1071266171637|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CCC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CCC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('1','col_1071266171607_colCCC_1','3','ext1') >>>> 1071266171637|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CCC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '2' >>>> 1071266171637|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CCC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CCC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('2','col_1071266171607_colCCC_2','3','ext2') >>>> 1071266171637|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CCC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '3' >>>> 1071266171647|10|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CCC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CCC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('3','col_1071266171607_colCCC_3','3','ext3') >>>> 1071266171647|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CCC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '4' >>>> 1071266171647|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CCC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CCC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('4','col_1071266171607_colCCC_4','3','ext4') >>>> 1071266171647|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_CCC WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '5' >>>> 1071266171647|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_CCC >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_CCC (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('5','col_1071266171607_colCCC_5','3','ext5') >>>> 1071266171647|0|0|commit|| >>>> 1071266171647|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '3' >>>> 1071266171647|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = '3' ORDER BY 3 DESC >>>> 1071266171647|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = '3' ORDER BY 4 DESC >>>> 1071266171657|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '3' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleD' ) ORDER BY 4 DESC >>>> 1071266171657|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CCC A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CCC A0 WHERE A0.NAME LIKE 'col_1071266171607%' >>>> 1071266171657|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = '3' ORDER BY 3 DESC >>>> 1071266171657|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = '3' ORDER BY 4 DESC >>>> 1071266171667|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CCC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CCC A0 WHERE A0.GAT_ID = '3' ORDER BY 4 DESC >>>> 1071266171667|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '3' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleD' ) ORDER BY 4 DESC >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '5' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '4' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '3' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '2' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '1' >>>> 1071266171667|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = '3' ORDER BY 4 DESC >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '5' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '4' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '3' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '2' >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_CCC >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_CCC WHERE >>>> COL_ID = '1' >>>> 1071266171667|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '3' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleDD' ) ORDER BY 4 DESC >>>> 1071266171667|0|0|statement|DELETE FROM COLLECTION_GATHERER WHERE >>>> GAT_ID = ? |DELETE FROM COLLECTION_GATHERER WHERE GAT_ID = '3' >>>> 1071266171667|0|0|commit|| >>>> 1071266171667|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CCC A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CCC A0 WHERE A0.NAME LIKE 'col_1071266171607%' >>>> 1071266171677|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '4' >>>> 1071266171677|0|0|statement|INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES (?,?) |INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES >>>> ('4','1071266171677_testStoreDeleteSimpleCollections') >>>> 1071266171677|0|0|statement|SELECT >>>> GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |SELECT GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D WHERE COL_ID = '15' >>>> 1071266171677|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES (?,?,?,?) |INSERT >>>> INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES >>>> ('15','col_1071266171677_colD_1','org.apache.ojb.broker.CollectionTest$CollectibleD','4') >>>> >>>> 1071266171677|0|0|statement|SELECT >>>> GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |SELECT GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D WHERE COL_ID = '16' >>>> 1071266171677|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES (?,?,?,?) |INSERT >>>> INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES >>>> ('16','col_1071266171677_colD_2','org.apache.ojb.broker.CollectionTest$CollectibleD','4') >>>> >>>> 1071266171677|0|0|statement|SELECT >>>> GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |SELECT GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D WHERE COL_ID = '17' >>>> 1071266171677|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES (?,?,?,?) |INSERT >>>> INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES >>>> ('17','col_1071266171677_colDD_1','org.apache.ojb.broker.CollectionTest$CollectibleDD','4') >>>> >>>> 1071266171677|0|0|statement|SELECT >>>> GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |SELECT GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D WHERE COL_ID = '18' >>>> 1071266171677|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES (?,?,?,?) |INSERT >>>> INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES >>>> ('18','col_1071266171677_colDD_2','org.apache.ojb.broker.CollectionTest$CollectibleDD','4') >>>> >>>> 1071266171677|0|0|statement|SELECT >>>> GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |SELECT GAT_ID,OJB_CONCRETE_CLASS,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D WHERE COL_ID = '19' >>>> 1071266171677|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES (?,?,?,?) |INSERT >>>> INTO COLLECTION_COLLECTIBLE_D >>>> (COL_ID,NAME,OJB_CONCRETE_CLASS,GAT_ID) VALUES >>>> ('19','col_1071266171677_colDD_3','org.apache.ojb.broker.CollectionTest$CollectibleDD','4') >>>> >>>> 1071266171677|0|0|commit|| >>>> 1071266171677|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '4' >>>> 1071266171677|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = '4' ORDER BY 3 DESC >>>> 1071266171687|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = '4' ORDER BY 4 DESC >>>> 1071266171687|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '4' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleD' ) ORDER BY 4 DESC >>>> 1071266171697|0|0|statement|SELECT count(A0.COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? )|SELECT count(A0.COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '4' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleDD' ) >>>> 1071266171697|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '4' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleDD' ) ORDER BY 4 DESC >>>> 1071266171697|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE (A0.NAME LIKE ? ) AND A0.NAME >>>> LIKE ? |SELECT A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID >>>> FROM COLLECTION_COLLECTIBLE_D A0 WHERE (A0.NAME LIKE >>>> 'col_1071266171677_colD%' ) AND A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171697|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE >>>> 'col_1071266171677_colDD%' >>>> 1071266171707|10|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171707|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171707|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171707|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171707|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171707|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171707|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.GAT_ID = '4' ORDER BY 4 DESC >>>> 1071266171707|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_D WHERE COL_ID >>>> = '16' >>>> 1071266171717|10|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_D WHERE COL_ID >>>> = '15' >>>> 1071266171717|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_D WHERE COL_ID >>>> = '19' >>>> 1071266171717|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_D WHERE COL_ID >>>> = '18' >>>> 1071266171717|0|0|statement|DELETE FROM COLLECTION_COLLECTIBLE_D >>>> WHERE COL_ID = ? |DELETE FROM COLLECTION_COLLECTIBLE_D WHERE COL_ID >>>> = '17' >>>> 1071266171717|0|0|statement|DELETE FROM COLLECTION_GATHERER WHERE >>>> GAT_ID = ? |DELETE FROM COLLECTION_GATHERER WHERE GAT_ID = '4' >>>> 1071266171717|0|0|commit|| >>>> 1071266171717|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '4' >>>> 1071266171717|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE >>>> 'col_1071266171677_colD%' >>>> 1071266171717|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE >>>> 'col_1071266171677_colDD%' >>>> 1071266171717|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171717|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171717|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171717|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171717|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171677%' >>>> 1071266171727|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '5' >>>> 1071266171727|0|0|statement|INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES (?,?) |INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES ('5','1071266171727_testStoreSimpleCollections') >>>> 1071266171727|0|0|statement|UPDATE COLLECTION_GATHERER SET NAME=? >>>> WHERE GAT_ID = ? |UPDATE COLLECTION_GATHERER SET >>>> NAME='1071266171727_testStoreSimpleCollections' WHERE GAT_ID = '5' >>>> 1071266171727|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '20' >>>> 1071266171727|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('20','col_1071266171727_colBase_1','5') >>>> 1071266171727|0|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE >>>> 'SEQ_COLLECTION_COLLECTIBLE_BASE' >>>> 1071266171737|0|1|statement|UPDATE OJB_HL_SEQ SET >>>> MAX_KEY=?,GRAB_SIZE=?,VERSION=? WHERE TABLENAME = ? AND FIELDNAME = >>>> ? AND VERSION = ? |UPDATE OJB_HL_SEQ SET >>>> MAX_KEY='40',GRAB_SIZE='20',VERSION='2' WHERE TABLENAME = >>>> 'SEQ_COLLECTION_COLLECTIBLE_BASE' AND FIELDNAME = >>>> 'deprecatedColumn' AND VERSION = '1' >>>> 1071266171737|0|1|commit|| >>>> 1071266171737|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '21' >>>> 1071266171737|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('21','col_1071266171727_colBase_2','5') >>>> 1071266171737|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = ? |SELECT >>>> GAT_ID,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_BASE WHERE COL_ID = '22' >>>> 1071266171737|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_BASE >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_BASE (COL_ID,NAME,GAT_ID) VALUES >>>> ('22','col_1071266171727_colBase_3','5') >>>> 1071266171747|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '23' >>>> 1071266171747|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('23','col_1071266171727_colB_1','5') >>>> 1071266171747|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '24' >>>> 1071266171747|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('24','col_1071266171727_colB_2','5') >>>> 1071266171747|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '25' >>>> 1071266171747|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('25','col_1071266171727_colB_3','5') >>>> 1071266171747|0|0|statement|SELECT GAT_ID,NAME,COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B WHERE COL_ID = ? |SELECT GAT_ID,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_B WHERE COL_ID = '26' >>>> 1071266171747|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_B >>>> (COL_ID,NAME,GAT_ID) VALUES (?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_B (COL_ID,NAME,GAT_ID) VALUES >>>> ('26','col_1071266171727_colB_4','5') >>>> 1071266171747|0|0|commit|| >>>> 1071266171747|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '5' >>>> 1071266171747|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = '5' ORDER BY 3 DESC >>>> 1071266171747|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = '5' ORDER BY 4 DESC >>>> 1071266171747|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '5' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleD' ) ORDER BY 4 DESC >>>> 1071266171757|0|0|statement|SELECT count(A0.COL_ID) FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = ? |SELECT >>>> count(A0.COL_ID) FROM COLLECTION_COLLECTIBLE_B A0 WHERE A0.GAT_ID = >>>> '5' >>>> 1071266171757|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171727_colBase%' >>>> 1071266171757|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171727_colB%' >>>> 1071266171757|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171727%' >>>> 1071266171757|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266171727%' >>>> 1071266171757|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171727%' >>>> 1071266171757|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171727%' >>>> 1071266171757|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171727%' >>>> 1071266171767|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '6' >>>> 1071266171767|0|0|statement|INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES (?,?) |INSERT INTO COLLECTION_GATHERER >>>> (GAT_ID,NAME) VALUES >>>> ('6','1071266171757_testStoreCollectionObjectsWithBackReference') >>>> 1071266171767|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_C WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_C WHERE >>>> COL_ID = '27' >>>> 1071266171767|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_C >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_C (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('27','col_1071266171757_colC_1','6','ext1') >>>> 1071266171767|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_C WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_C WHERE >>>> COL_ID = '28' >>>> 1071266171767|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_C >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_C (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('28','col_1071266171757_colC_2','6','ext2') >>>> 1071266171767|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_C WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_C WHERE >>>> COL_ID = '29' >>>> 1071266171767|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_C >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_C (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('29','col_1071266171757_colC_3','6','ext3') >>>> 1071266171767|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_C WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_C WHERE >>>> COL_ID = '30' >>>> 1071266171767|0|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_C >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_C (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('30','col_1071266171757_colC_4','6','ext4') >>>> 1071266171767|0|0|statement|SELECT GAT_ID,EXTENT_NAME,NAME,COL_ID >>>> FROM COLLECTION_COLLECTIBLE_C WHERE COL_ID = ? |SELECT >>>> GAT_ID,EXTENT_NAME,NAME,COL_ID FROM COLLECTION_COLLECTIBLE_C WHERE >>>> COL_ID = '31' >>>> 1071266171787|20|0|statement|INSERT INTO COLLECTION_COLLECTIBLE_C >>>> (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES (?,?,?,?) |INSERT INTO >>>> COLLECTION_COLLECTIBLE_C (COL_ID,NAME,GAT_ID,EXTENT_NAME) VALUES >>>> ('31','col_1071266171757_colC_5','6','ext5') >>>> 1071266171787|0|0|commit|| >>>> 1071266171787|0|0|statement|SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = ? |SELECT GAT_ID,NAME FROM >>>> COLLECTION_GATHERER WHERE GAT_ID = '6' >>>> 1071266171787|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = ? ORDER BY 3 >>>> DESC|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.GAT_ID = '6' ORDER BY 3 DESC >>>> 1071266171787|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = ? ORDER BY 4 >>>> DESC|SELECT A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_CC A0 WHERE A0.GAT_ID = '6' ORDER BY 4 DESC >>>> 1071266171797|10|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = ? ) AND >>>> (A0.OJB_CONCRETE_CLASS = ? ) ORDER BY 4 DESC|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE ( A0.GAT_ID = '6' ) AND >>>> (A0.OJB_CONCRETE_CLASS = >>>> 'org.apache.ojb.broker.CollectionTest$CollectibleD' ) ORDER BY 4 DESC >>>> 1071266171797|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE >>>> 'col_1071266171757_colC%' >>>> 1071266171797|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171757%' >>>> 1071266171797|0|0|statement|SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.EXTENT_NAME,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_C A0 WHERE A0.NAME LIKE 'col_1071266171757%' >>>> 1071266171797|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_BASE A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_BASE A0 >>>> WHERE A0.NAME LIKE 'col_1071266171757%' >>>> 1071266171797|0|0|statement|SELECT A0.GAT_ID,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_B A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.NAME,A0.COL_ID FROM COLLECTION_COLLECTIBLE_B A0 WHERE >>>> A0.NAME LIKE 'col_1071266171757%' >>>> 1071266171807|0|0|statement|SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE ? |SELECT >>>> A0.GAT_ID,A0.OJB_CONCRETE_CLASS,A0.NAME,A0.COL_ID FROM >>>> COLLECTION_COLLECTIBLE_D A0 WHERE A0.NAME LIKE 'col_1071266171757%' >>>> 1071266171807|0|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE 'SEQ_COL_BOOKSHELFS' >>>> 1071266171807|0|0|statement||SELECT MAX(PK) FROM COL_BOOKSHELFS >>>> 1071266171807|0|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COL_BOOKSHELFS','deprecatedColumn','20','20','1') >>>> 1071266171807|0|1|commit|| >>>> 1071266171807|0|0|statement|SELECT NAME,PK FROM COL_BOOKSHELFS WHERE >>>> PK = ? |SELECT NAME,PK FROM COL_BOOKSHELFS WHERE PK = '1' >>>> 1071266171807|0|0|statement|INSERT INTO COL_BOOKSHELFS (PK,NAME) >>>> VALUES (?,?) |INSERT INTO COL_BOOKSHELFS (PK,NAME) VALUES >>>> ('1','testOneBookShelfQueryByCollection_1071266171807') >>>> 1071266171807|0|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE 'SEQ_COL_BOOKS' >>>> 1071266171817|0|0|statement||SELECT MAX(PK) FROM COL_BOOKS >>>> 1071266171817|0|0|statement||SELECT MAX(PK) FROM COL_DVDS >>>> 1071266171817|0|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COL_BOOKS','deprecatedColumn','20','20','1') >>>> 1071266171817|0|1|commit|| >>>> 1071266171817|0|0|statement|SELECT BOOKSHELF_FK,PK FROM COL_DVDS >>>> WHERE PK = ? |SELECT BOOKSHELF_FK,PK FROM COL_DVDS WHERE PK = '1' >>>> 1071266171817|0|0|statement|INSERT INTO COL_DVDS (PK,BOOKSHELF_FK) >>>> VALUES (?,?) |INSERT INTO COL_DVDS (PK,BOOKSHELF_FK) VALUES ('1','1') >>>> 1071266171817|0|0|statement|SELECT BOOKSHELF_FK,PK FROM COL_BOOKS >>>> WHERE PK = ? |SELECT BOOKSHELF_FK,PK FROM COL_BOOKS WHERE PK = '2' >>>> 1071266171827|10|0|statement|INSERT INTO COL_BOOKS (PK,BOOKSHELF_FK) >>>> VALUES (?,?) |INSERT INTO COL_BOOKS (PK,BOOKSHELF_FK) VALUES ('2','1') >>>> 1071266171827|0|0|commit|| >>>> 1071266171827|0|0|statement|SELECT NAME,PK FROM COL_BOOKSHELFS WHERE >>>> PK = ? |SELECT NAME,PK FROM COL_BOOKSHELFS WHERE PK = '1' >>>> 1071266171827|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT >>>> A0.BOOKSHELF_FK,A0.PK FROM COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> 1071266171827|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_DVDS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT A0.BOOKSHELF_FK,A0.PK >>>> FROM COL_DVDS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> 1071266171827|0|0|statement|SELECT A0.NAME,A0.PK FROM COL_BOOKSHELFS >>>> A0 WHERE A0.NAME LIKE ? |SELECT A0.NAME,A0.PK FROM COL_BOOKSHELFS >>>> A0 WHERE A0.NAME LIKE >>>> 'testOneBookShelfQueryByCollection_1071266171807' >>>> 1071266171837|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT >>>> A0.BOOKSHELF_FK,A0.PK FROM COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> 1071266171837|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_DVDS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT A0.BOOKSHELF_FK,A0.PK >>>> FROM COL_DVDS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> 1071266171847|0|0|statement|SELECT NAME,PK FROM COL_BOOKSHELFS WHERE >>>> PK = ? |SELECT NAME,PK FROM COL_BOOKSHELFS WHERE PK = '2' >>>> 1071266171847|0|0|statement|INSERT INTO COL_BOOKSHELFS (PK,NAME) >>>> VALUES (?,?) |INSERT INTO COL_BOOKSHELFS (PK,NAME) VALUES >>>> ('2','testOneBookShelfQueryByIterator_1071266171847') >>>> 1071266171847|0|0|statement|SELECT BOOKSHELF_FK,PK FROM COL_DVDS >>>> WHERE PK = ? |SELECT BOOKSHELF_FK,PK FROM COL_DVDS WHERE PK = '3' >>>> 1071266171847|0|0|statement|INSERT INTO COL_DVDS (PK,BOOKSHELF_FK) >>>> VALUES (?,?) |INSERT INTO COL_DVDS (PK,BOOKSHELF_FK) VALUES ('3','2') >>>> 1071266171847|0|0|statement|SELECT BOOKSHELF_FK,PK FROM COL_BOOKS >>>> WHERE PK = ? |SELECT BOOKSHELF_FK,PK FROM COL_BOOKS WHERE PK = '4' >>>> 1071266171847|0|0|statement|INSERT INTO COL_BOOKS (PK,BOOKSHELF_FK) >>>> VALUES (?,?) |INSERT INTO COL_BOOKS (PK,BOOKSHELF_FK) VALUES ('4','2') >>>> 1071266171847|0|0|commit|| >>>> 1071266171847|0|0|statement|SELECT NAME,PK FROM COL_BOOKSHELFS WHERE >>>> PK = ? |SELECT NAME,PK FROM COL_BOOKSHELFS WHERE PK = '2' >>>> 1071266171847|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT >>>> A0.BOOKSHELF_FK,A0.PK FROM COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = '2' >>>> 1071266171847|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_DVDS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT A0.BOOKSHELF_FK,A0.PK >>>> FROM COL_DVDS A0 WHERE A0.BOOKSHELF_FK = '2' >>>> 1071266171847|0|0|statement|SELECT A0.NAME,A0.PK FROM COL_BOOKSHELFS >>>> A0 WHERE A0.NAME LIKE ? |SELECT A0.NAME,A0.PK FROM COL_BOOKSHELFS >>>> A0 WHERE A0.NAME LIKE 'testOneBookShelfQueryByIterator_1071266171847' >>>> 1071266171857|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT >>>> A0.BOOKSHELF_FK,A0.PK FROM COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = '2' >>>> 1071266171857|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_DVDS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT A0.BOOKSHELF_FK,A0.PK >>>> FROM COL_DVDS A0 WHERE A0.BOOKSHELF_FK = '2' >>>> >>>> >>>> 1071266674410|20|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE 'SEQ_COL_BOOKSHELFS' >>>> 1071266674430|10|0|statement||SELECT MAX(PK) FROM COL_BOOKSHELFS >>>> 1071266674450|10|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COL_BOOKSHELFS','deprecatedColumn','20','20','1') >>>> 1071266674450|0|1|commit|| >>>> >>>> 1071266674460|0|0|statement|SELECT NAME,PK FROM COL_BOOKSHELFS WHERE >>>> PK = ? |SELECT NAME,PK FROM COL_BOOKSHELFS WHERE PK = '1' >>>> 1071266674460|0|0|statement|INSERT INTO COL_BOOKSHELFS (PK,NAME) >>>> VALUES (?,?) |INSERT INTO COL_BOOKSHELFS (PK,NAME) VALUES >>>> ('1','testOneBookShelfQueryByCollection_1071266673408') >>>> 1071266674470|0|1|statement|SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE ? |SELECT >>>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>>> OJB_HL_SEQ A0 WHERE A0.TABLENAME LIKE 'SEQ_COL_BOOKS' >>>> 1071266674470|0|0|statement||SELECT MAX(PK) FROM COL_BOOKS >>>> 1071266674470|0|0|statement||SELECT MAX(PK) FROM COL_DVDS >>>> 1071266674470|0|1|statement|INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>>> |INSERT INTO OJB_HL_SEQ >>>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES >>>> ('SEQ_COL_BOOKS','deprecatedColumn','20','20','1') >>>> 1071266674470|0|1|commit|| >>>> >>>> 1071266674480|0|0|statement|SELECT BOOKSHELF_FK,PK FROM COL_DVDS >>>> WHERE PK = ? |SELECT BOOKSHELF_FK,PK FROM COL_DVDS WHERE PK = '1' >>>> 1071266674480|0|0|statement|INSERT INTO COL_DVDS (PK,BOOKSHELF_FK) >>>> VALUES (?,?) |INSERT INTO COL_DVDS (PK,BOOKSHELF_FK) VALUES ('1','1') >>>> 1071266674480|0|0|statement|SELECT BOOKSHELF_FK,PK FROM COL_BOOKS >>>> WHERE PK = ? |SELECT BOOKSHELF_FK,PK FROM COL_BOOKS WHERE PK = '2' >>>> 1071266674480|0|0|statement|INSERT INTO COL_BOOKS (PK,BOOKSHELF_FK) >>>> VALUES (?,?) |INSERT INTO COL_BOOKS (PK,BOOKSHELF_FK) VALUES ('2','1') >>>> 1071266674480|0|0|commit|| >>>> >>>> 1071266674480|0|0|statement|SELECT NAME,PK FROM COL_BOOKSHELFS WHERE >>>> PK = ? |SELECT NAME,PK FROM COL_BOOKSHELFS WHERE PK = '1' >>>> 1071266674520|10|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_DVDS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT A0.BOOKSHELF_FK,A0.PK >>>> FROM COL_DVDS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> 1071266674520|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT >>>> A0.BOOKSHELF_FK,A0.PK FROM COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> >>>> 1071266674520|0|0|statement|SELECT A0.NAME,A0.PK FROM COL_BOOKSHELFS >>>> A0 WHERE A0.NAME LIKE ? |SELECT A0.NAME,A0.PK FROM COL_BOOKSHELFS >>>> A0 WHERE A0.NAME LIKE >>>> 'testOneBookShelfQueryByCollection_1071266673408' >>>> 1071266674560|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_DVDS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT A0.BOOKSHELF_FK,A0.PK >>>> FROM COL_DVDS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> 1071266674560|0|0|statement|SELECT A0.BOOKSHELF_FK,A0.PK FROM >>>> COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = ? |SELECT >>>> A0.BOOKSHELF_FK,A0.PK FROM COL_BOOKS A0 WHERE A0.BOOKSHELF_FK = '1' >>>> >>>> >>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org >>>> For additional commands, e-mail: ojb-dev-help@db.apache.org >>>> >>>> . >>>> >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org >>> For additional commands, e-mail: ojb-dev-help@db.apache.org >>> >>> >>> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org >> For additional commands, e-mail: ojb-dev-help@db.apache.org >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org > For additional commands, e-mail: ojb-dev-help@db.apache.org > > > --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org