persistence@glassfish.java.net

RE: TopLink and quoted database identifiers

From: Gordon Yorke <gordon.yorke_at_oracle.com>
Date: Fri, 3 Nov 2006 08:41:56 -0500

Hello Andrei,
    I can assure you TopLink is "spec-compliant". As "quoted" identifiers are not covered in the specification each persistence provider will have its own means of specifing quoted metadata. To pass a "quoted" value to an annotation use the escape quote character (\") around the value TopLink will interpret this as an intention to have the identifier display as specified.
eg. @Column(name="\"coLuMnName\"")
--Gordon

-----Original Message-----
From: Andrei.Badea_at_Sun.COM [mailto:Andrei.Badea_at_Sun.COM]On Behalf Of
Andrei Badea
Sent: Friday, November 03, 2006 4:28 AM
To: persistence_at_glassfish.dev.java.net
Subject: TopLink and quoted database identifiers


The problems described by a NetBeans user at

http://www.netbeans.org/servlets/ReadMsg?list=nbusers&msgNo=78730

seem to be caused by TopLink considering all database identifiers
unquoted. I can't find the word "quoted" in the JPA spec, is TopLink
actually spec-compliant, or is there a way to tell it to quote database
identifiers?

Thanks,

Andrei