Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jdo-dev@db.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Tue, 14 Feb 2006 13:57:13 -0800
From: Craig L Russell <Craig.Russell@Sun.COM>
Subject: Issue 160: Missing description of index, unique
In-reply-to: <200602141014.28645.andy@jpox.org>
Sender: Craig.Russell@Sun.COM
To: Apache JDO project <jdo-dev@db.apache.org>
Cc: JDO Expert Group <jdo-experts-ext@Sun.COM>
Message-id: <5669127F-62DF-48AD-A5E9-184F5C354EFE@Sun.COM>
MIME-version: 1.0
Content-type: multipart/signed; protocol="application/pkcs7-signature";
 boundary=Apple-Mail-21-585760646; micalg=sha1
References: <394E329B-CE91-4D3A-B2B7-0B53BDBAEC6D@Sun.COM>
 <200602141014.28645.andy@jpox.org>

--Apple-Mail-21-585760646
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=WINDOWS-1252;
	delsp=yes;
	format=flowed

Hi Andy,

Here's a proposal for review.

I can't see the value in having the table attribute for embedded =20
index or unique elements. But if they are defined at the class or =20
interface level, the table would be used to identify an index or =20
unique constraint on an associated table (secondary table).

<proposed addition to 18.13>
ELEMENT index
The index element specifies characteristics of an index associated =20
with the containing interface, property, class, join, version, =20
discriminator, field, key, value, element, or order.
To specify that there is an index associated with the containing =20
element, without specifying the name of the index, the indexed =20
attribute can be used instead of the index element. Alternatively, =20
the index element with no attributes can be used.
If the index element is specified at the class or interface level, =20
then column, field, or property elements contained in the index =20
element might contain only the name attribute. If the index element =20
is specified in the property, join, version, discriminator, field, =20
key, value, element or order, then there must not be any contained =20
column, field, or property elements in the index elements.
ATTRIBUTE name
The name attribute specifies the name of the index to generate for =20
this mapping. This attribute is used if the name of the index needs =20
to be specified.
ATTRIBUTE unique
The unique attribute specifies that the index is unique.
ATTRIBUTE table
The table attribute specifies the name of the table to which the =20
index applies. This attribute can only be used with index elements =20
defined at the class or interface level.

ELEMENT unique
The unique element specifies characteristics of a unique constraint =20
associated with the containing interface, class, property, join, =20
version, discriminator, field, key, value, or element.
To specify that there is a unique constraint associated with the =20
containing element, without specifying the name of the unique =20
constraint, the unique attribute can be used instead of the unique =20
element. Alternatively, the unique element can be used with no =20
attributes or contained elements.
If this element is specified at the class level, then column elements =20=

contained in the unique element might contain only the name attribute.
ATTRIBUTE deferred
The deferred attribute specifies whether constraint checking on the =20
containing element is defined in the database as being deferred until =20=

commit. This allows an optimization by the JDO implementation, and =20
might allow certain operations to succeed where they would normally =20
fail. For example, to exchange unique references between pairs of =20
objects requires that the unique constraint columns temporarily =20
contain duplicate values.
Possible values are =93true=94 and =93false=94. The default is =93false=94=
.
ATTRIBUTE name
The name attribute specifies the name of the unique constraint to =20
generate for this mapping. This attribute is used if the name of the =20
unique constraint needs to be specified.
ATTRIBUTE table
The table attribute specifies the name of the table to which the =20
unique constraint applies. This attribute can only be used with =20
unique elements defined at the class or interface level.

<proposed addition to 18.13>

Craig

On Feb 14, 2006, at 1:14 AM, Andy Jefferson wrote:

> Hi Craig,
>
>> At http://access1.sun.com/jdo/private/index.html
>
> I sent a mail to the jdo-dev list (and also the JDO2 EG) back on =20
> Monday 16
> Jan, entitled "Section 18 : Where is <unique>, <index>
> description ?" (viewable from the archive of the jdo-dev mailing =20
> list, though
> not for the JDO2 EG archive since that was dead for 3 months).
>
> http://mail-archives.apache.org/mod_mbox/db-jdo-dev/200601.mbox/%=20
> 3c200601161712.08972.andy@jpox.org%3e
>
> I don't see anything in the spec for this. Would it be a quick job =20
> to get this
> included ?
>
>
> Thanks
> --=20
> 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-21-585760646
Content-Transfer-Encoding: base64
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Disposition: attachment;
	filename=smime.p7s

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGUDCCAwkw
ggJyoAMCAQICEB7Y7fLHmKoeHTUdbtYrvpAwDQYJKoZIhvcNAQEEBQAwYjELMAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA1MTIxNTIxNDc0NFoXDTA2MTIxNTIxNDc0
NFowbDEQMA4GA1UEBBMHUnVzc2VsbDEUMBIGA1UEKhMLQ3JhaWcgTGFpcmQxHDAaBgNVBAMTE0Ny
YWlnIExhaXJkIFJ1c3NlbGwxJDAiBgkqhkiG9w0BCQEWFUNyYWlnLlJ1c3NlbGxAU3VuLkNPTTCC
ASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAMXXgEAm88nu8cFbxXSWqTq+GaYpCx/0QSom
8kBbVxpJIURuO4ErLDupeXu6y9+5e7ZKLbeSQE5xbfYPcQR/IhqmYKy5YqRcuzPXREBj2zKEkZph
pNXWpHgMdx9W8dq0Cu2i9Ux/S6c2MuEHrP6gfGGll+b/mzLoO280QHTuE4pcpKntRnwZdGxQ/5l8
IL+eLP+jpJAbYW9C+KNKofZtS6V6R0uzlqTOsEdZvwxZQ4mmPgHoz1+Gjwme/PC5sKvF09MaJDiI
pj9SvZ4CTCgcDZV78J086YwlVbMC0VQotjhu1p42lr8CS33IXLz3OWNrDETCAepah/Dgw2ZZApQ9
9L0CAwEAAaMyMDAwIAYDVR0RBBkwF4EVQ3JhaWcuUnVzc2VsbEBTdW4uQ09NMAwGA1UdEwEB/wQC
MAAwDQYJKoZIhvcNAQEEBQADgYEAKdIkgAWCg2Bi7ocnstfJA4iymTRI2/L4oQx9zvllM9bNJ2cR
cecJIx3HuoHbhPvemh1GExEPgHU+dXSxDmD0BEmPnhSReKCURyslnbMphPZ5kR6USzQFrRa+v0ii
J+SBO9VQYTQWT+xEjmRLM76MfkBFw3IOC9CUkRoYZ88pOoUwggM/MIICqKADAgECAgENMA0GCSqG
SIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQH
EwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZp
Y2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1h
aWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMw
NzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl
IENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWls
IElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUE
cJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/Ef
kTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMB
AAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3Js
LnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYD
VR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GB
AEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+
hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC
3CEZNd4ksdMdRv9dX2VPMYIDEDCCAwwCAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0ECEB7Y7fLHmKoeHTUdbtYrvpAwCQYFKw4DAhoFAKCCAW8wGAYJKoZIhvcN
AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDYwMjE0MjE1NzE0WjAjBgkqhkiG9w0B
CQQxFgQUbZzJysVlBiRB384QyLIQIaJTuY4wgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMC
WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0
ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAe2O3yx5iqHh01HW7WK76QMIGHBgsqhkiG
9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQ
dHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAe
2O3yx5iqHh01HW7WK76QMA0GCSqGSIb3DQEBAQUABIIBAEx3qQOqDnV+FPqqZ8Mr/L5xp+U3+4US
fL9imsTJ7pXdg1fXsZrXKnQTODNLPZNpHaN1coeljzcWvX17KcSShyglkUQT4aPFfieg/XwlTPL4
SFXfJd2Fp7bSRg4HH1aBUNLNbn1n4TvWn2UcEpxArlQiM+BoWReaNy61L6fIGOYV1qldJ+6gkHOL
nRamsdSncEmChsJ5gtuQAZKxVOlxy5sGqp/CYSg1hiXNA9Fn+KXHHiYGSdLrwyRxFK/Q/1QXL9Dm
+0p4bNm81aatQT5uGJnevLf58lfAmm2sIT40V6dYA47chENqwI6QEDRfzlaWydJrXgaP9QFVfVrm
1dWYaVMAAAAAAAA=

--Apple-Mail-21-585760646--