Return-Path: 
 <jdo-dev-return-1602-apmail-db-jdo-dev-archive=www.apache.org@db.apache.org>
Delivered-To: apmail-db-jdo-dev-archive@www.apache.org
Received: (qmail 94598 invoked from network); 27 Sep 2005 14:48:14 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 Sep 2005 14:48:14 -0000
Received: (qmail 99238 invoked by uid 500); 27 Sep 2005 14:48:12 -0000
Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jdo-dev-help@db.apache.org>
List-Unsubscribe: <mailto:jdo-dev-unsubscribe@db.apache.org>
List-Post: <mailto:jdo-dev@db.apache.org>
List-Id: <jdo-dev.db.apache.org>
Reply-To: jdo-dev@db.apache.org
Delivered-To: mailing list jdo-dev@db.apache.org
Received: (qmail 99177 invoked by uid 99); 27 Sep 2005 14:48:12 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Sep 2005 07:48:10 -0700
Received: from ajax.apache.org (ajax.apache.org [127.0.0.1])
	by ajax.apache.org (Postfix) with ESMTP id B70D7123
	for <jdo-dev@db.apache.org>; Tue, 27 Sep 2005 16:47:48 +0200 (CEST)
Message-ID: <1127156275.1127832468735.JavaMail.jira@ajax.apache.org>
Date: Tue, 27 Sep 2005 16:47:48 +0200 (CEST)
From: "Andy Jefferson (JIRA)" <jira@apache.org>
To: jdo-dev@db.apache.org
Subject: [jira] Resolved: (JDO-125) Incorrect SQL generated for serialized
 embedded collections using serialized-element="true"
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

     [ http://issues.apache.org/jira/browse/JDO-125?page=all ]
     
Andy Jefferson resolved JDO-125:
--------------------------------

    Resolution: Cannot Reproduce
     Assign To: Andy Jefferson  (was: Erik Bengtson)

This is no longer applicable. JDO-143 is the most recent error on the CollectionCollections test and consequently this error is not reproduceable

> Incorrect SQL generated for serialized embedded collections using serialized-element="true"
> -------------------------------------------------------------------------------------------
>
>          Key: JDO-125
>          URL: http://issues.apache.org/jira/browse/JDO-125
>      Project: JDO
>         Type: Bug
>   Components: tck20
>  Environment: JPOX
>     Reporter: Craig Russell
>     Assignee: Andy Jefferson

>
> The .jdo:
> <field name="CollectionOfObject2" >
>   <collection element-type="org.apache.jdo.tck.pc.fieldtypes.SimpleClass" serialized-element="true">
>   </collection>
> </field>
> The .orm:
>             <field name="CollectionOfObject2"
>                    table="COLLECTION_OF_OBJECT2">
>                 <join column="IDENTIFIER"/>
>                 <element column="COLLVAL"/>
>             </field>
> The schema:
> CREATE TABLE COLLECTION_OF_OBJECT2
> (
>     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
> 	COLLVAL LONG VARCHAR FOR BIT DATA
> );
>  test(org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections)javax.jdo.JDODataStoreException: Iteration request failed : SELECT  FROM datastoreidentity0.COLLECTION_OF_OBJECT2 THIS WHERE 3 = THIS.IDENTIFIER
>     [java]      at org.jpox.store.rdbms.scostore.AbstractSetStore.iterator(AbstractSetStore.java:151)
>     [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:381)
>     [java]      at org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:279)
>     [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
>     [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1834)
>     [java]      at org.jpox.store.StoreManager.update(StoreManager.java:768)
>     [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4055)
>     [java]      at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2932)
>     [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:432)
>     [java]      at org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.runTest(TestCollectionCollections.java:97)
>     [java]      at org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.test(TestCollectionCollections.java:69)
>     [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>     [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>     [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197)
>     [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:115)
>     [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:93)
>     [java] NestedThrowablesStackTrace:
>     [java] ERROR 42X01: Syntax error: Encountered "FROM" at line 1, column 9.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira