users@glassfish.java.net

Quoted identifiers in JPA

From: <glassfish_at_javadesktop.org>
Date: Mon, 20 Aug 2007 17:42:50 PDT

Hi,

I would like to quote column names, such as "data" which is a SQL-99 reserved keyword. I noticed that Hibernate Annotations allows user to insert backticks directly into the column name, as follows:

@Column(name="`data`)

but it's not clear to me whether this is portable across all JPA implementations. Any ideas what Glassfish and others do? Does the standard discuss this at all?

Thank you,
Gili
[Message sent by forum member 'cowwoc' (cowwoc)]

http://forums.java.net/jive/thread.jspa?messageID=231712