db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakob Braeuchi <jbraeu...@gmx.ch>
Subject Re: [BUG] Prefetch/query bug?
Date Tue, 16 Dec 2003 21:54:11 GMT
hi armin,

i started the prefetch-thing but it grew more and more sophisticated and 
complicated... i'm currently working on prefetching m:n-relationships.

jakob

Armin Waibel wrote:
> 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 <andy@transdecisions.com>
>>>>>
>>>>>
>>>>> 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
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message