From jdo-dev-return-724-apmail-db-jdo-dev-archive=www.apache.org@db.apache.org Tue Jul 12 23:07:23 2005 Return-Path: Delivered-To: apmail-db-jdo-dev-archive@www.apache.org Received: (qmail 67713 invoked from network); 12 Jul 2005 23:07:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 12 Jul 2005 23:07:22 -0000 Received: (qmail 75232 invoked by uid 500); 12 Jul 2005 23:07:22 -0000 Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-dev@db.apache.org Received: (qmail 75212 invoked by uid 99); 12 Jul 2005 23:07:22 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jul 2005 16:07:22 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jul 2005 16:07:19 -0700 Received: from fe2.sun.com ([192.18.108.79]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id j6CN7J8t002330 for ; Tue, 12 Jul 2005 17:07:19 -0600 (MDT) Received: from conversion-daemon.fe2.sun.com by fe2.sun.com (Sun Java System Messaging Server 6.1 HotFix 0.02 (built Aug 25 2004)) id <0IJJ00301ELCZV00@fe2.sun.com> (original mail from Craig.Russell@Sun.COM) for jdo-dev@db.apache.org; Tue, 12 Jul 2005 17:07:19 -0600 (MDT) Received: from [192.168.0.10] ([24.6.172.77]) by fe2.sun.com (Sun Java System Messaging Server 6.1 HotFix 0.02 (built Aug 25 2004)) with ESMTPSA id <0IJJ00GV9EW6PYRC@fe2.sun.com> for jdo-dev@db.apache.org; Tue, 12 Jul 2005 17:07:19 -0600 (MDT) Date: Tue, 12 Jul 2005 16:07:23 -0700 From: Craig Russell Subject: Re: Embedded collections of non-PC objects In-reply-to: <200507122046.35036.andy@jpox.org> To: jdo-dev@db.apache.org Message-id: <824F9FC1-F534-4E71-A135-9E1E9E72CCF1@Sun.COM> MIME-version: 1.0 X-Mailer: Apple Mail (2.730) Content-type: multipart/signed; protocol="application/pkcs7-signature"; boundary=Apple-Mail-61--978960025; micalg=sha1 References: <42D2A542.60300@spree.de> <200507121614.10819.andy@jpox.org> <42D4191B.2040201@sun.com> <200507122046.35036.andy@jpox.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --Apple-Mail-61--978960025 Content-Type: multipart/alternative; boundary=Apple-Mail-60--978961187 --Apple-Mail-60--978961187 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Hi Andy, JDO2 defines an attribute "serialized" that specifies whether the contents of a field should be serialized and dumped into a single column, and therefore not queryable. It does allow for any serializable data to be stored, regardless of whether the data is persistence-capable or not. So I think it is a requirement for the Reference Implementation... To help clarify this for the TCK, we can/should add the "serialized" attribute to the columns in the metadata that are embedded. Thanks, Craig On Jul 12, 2005, at 12:46 PM, Andy Jefferson wrote: > Hi Michelle, > > >> Now we get an error with collection types where the field is embedded >> but jpox is looking for a table for the field: >> Iteration request failed : SELECT THIS.BIGDECIMAL_ELE FROM >> applicationidentity0.COLLECTION_OF_BIG_DECIMAL19 THIS WHERE 1 = >> THIS.IDENTIFIER_OID >> > > >> NestedThrowablesStackTrace: >> ERROR 42X05: Table 'APPLICATIONIDENTITY0.COLLECTION_OF_BIG_DECIMAL19' >> does not exist. >> > > JPOX persists collections of non-PC's in a join table. Is there a > join table > here ? because you have none in your metadata. > > Are you expecting us to create some massive BLOB column and dump > all of the > collection into that ? because we don't support that currently, and > I don't > have any requests from users to do such a thing (since querying of the > elements would be getting close to impossible). > > > -- > Andy > Java Persistent Objects - JPOX > Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:Craig.Russell@sun.com P.S. A good JDO? O, Gasp! --Apple-Mail-60--978961187 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1 Hi Andy,

JDO2 defines an attribute = "serialized" that specifies whether the contents of a field should be = serialized and dumped into a single column, and therefore not queryable. = It does allow for any serializable data to be stored, regardless of = whether the data is persistence-capable or not.

So I think it is a = requirement for the Reference Implementation...

To help clarify this for = the TCK, we can/should add the "serialized" attribute to the columns in = the metadata that are embedded.

Thanks,

Craig

On Jul 12, 2005, at 12:46 PM, Andy Jefferson wrote:

Hi Michelle,


Now we = get an error with collection types where the field is embedded
but jpox is looking for a table for the = field:
Iteration request failed : = SELECT THIS.BIGDECIMAL_ELE FROM=A0
=A0
=A0

=
ERROR 42X05: = Table 'APPLICATIONIDENTITY0.COLLECTION_OF_BIG_DECIMAL19'
does not exist.


JPOX = persists collections of non-PC's in a join table. Is there a join = table=A0
here ? because you have none in your = metadata.

Are you expecting us to create some massive BLOB = column and dump all of the=A0
=A0
have any requests from users to do such a thing = (since querying of the=A0
elements = would be getting close to impossible).


--=A0
Java Persistent Objects - = JPOX


Craig Russell

Architect, Sun Java = Enterprise System http://java.sun.com/products/jdo=

408 = 276-5638 mailto:Craig.Russell@sun.com

P.S. A = good JDO? O, Gasp!


= --Apple-Mail-60--978961187-- --Apple-Mail-61--978960025 Content-Transfer-Encoding: base64 Content-Type: application/pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGHjCCAtcw ggJAoAMCAQICAw3FWTANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0EwHhcNMDUwMTEwMDA0MTA5WhcNMDYwMTEwMDA0MTA5WjBHMR8wHQYDVQQD ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSQwIgYJKoZIhvcNAQkBFhVDcmFpZy5SdXNzZWxsQFN1 bi5DT00wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDti7ZE4rO6oXKbLM02AG9WY55t udmBVL53fb3V3X5S1kvcJOk1NEMIYT/T7Ww+/hE955zvHT29+mIoNe8AW/yj1WUH8uGG2HxhwCHI UQTHmN/ioVJgjwUaYbtNMKbL/NRpnL0QWewdMJS+6IFzFyX7ADFW5cJ+UWNLvNeWAQtN0mtLildn vdOgh50i8YPvACNkCHoomGjXx0azcXbe1X3c5AgRI6e2CZe5k2lRFQFUMqkjdoMtQPoNqJ1BxH9l i4cnabl8mcTwHHl44hrvb8ThqwRf2pfJh2vVuwmgK6z4IWjOk4RQM+0ODsRdq67mBdimJYmPMK1p RMBHzrUsfKxNAgMBAAGjMjAwMCAGA1UdEQQZMBeBFUNyYWlnLlJ1c3NlbGxAU3VuLkNPTTAMBgNV HRMBAf8EAjAAMA0GCSqGSIb3DQEBBAUAA4GBAIj86LzxCHedStDLMEeqHLy+UFG7zIRHfChSIV42 +MvXicydXEBh8v0Ry1V2d/lY4jS78G5yW5R9fKt1U5nlRBCOVzdhomvSolnNRIT71wPVVDrAIVlA YpXKxSmVBq7+4hV+3ZLHDeq3qZnNmiJR0sTEUD16xZX1RJs9dRYPCHoRMIIDPzCCAqigAwIBAgIB DTANBgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTES MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMf Q2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFs IEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29t MB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT HFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG cmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEpjxVc1X7TrnK mVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph8r9RzgHU5VAKMNcCY1osiRVwjt3J8CuFWqo/cVbL rzwLB+fxH5E2JCoTzyvV84J3PQO+K/67GD4Hv0CAAmTXp6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZ cmC3+wIDAQABo4GUMIGRMBIGA1UdEwEB/wQIMAYBAf8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0 cDovL2NybC50aGF3dGUuY29tL1RoYXd0ZVBlcnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQD AgEGMCkGA1UdEQQiMCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0B AQUFAAOBgQBIjNFQg+oLLswNo2asZw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3h YWLD2ToZfoSxmRsAxRoLgnSeJVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1 TXfjViF4gtwhGTXeJLHTHUb/XV9lTzGCAucwggLjAgEBMGkwYjELMAkGA1UEBhMCWkExJTAjBgNV BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h bCBGcmVlbWFpbCBJc3N1aW5nIENBAgMNxVkwCQYFKw4DAhoFAKCCAVMwGAYJKoZIhvcNAQkDMQsG CSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDUwNzEyMjMwNzI0WjAjBgkqhkiG9w0BCQQxFgQU RNcS7efg25nmdNhvFWfeIP4/qFYweAYJKwYBBAGCNxAEMWswaTBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw3FWTB6BgsqhkiG9w0BCRACCzFroGkwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1Ro YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAgMNxVkwDQYJKoZIhvcNAQEBBQAEggEA MvWfQl/tIMYzLz0JezIoqG/NMlBe79WTPoY3WjxS+EK+DSPTg0kjY5/T0PRvVGtTkuaZao1gjPP4 /I/Ga3YZtpz/hXslP9mU/h5rHAH1dG2hmpu3GpuZyaA87tFLk5LifQTDnat5C36CxWJhxRW/SCvV XBeYwYrH4bDxRTlkbdgRwYPMp7gGdPhlvDhaOpKuN+KfzXzzZDoR8VgmfiFefYizqWy84QRndas/ Za/HqEoRIEnA9dH2tFzrocNgzxXrXaEFO6a34aLlNonS272FWAmFeIOobAqmdUhqQYWPnERTG6In vnAhq1DLACxhjxuzE8tUbUn3806zvrRFGDjs+gAAAAAAAA== --Apple-Mail-61--978960025--