Column name clash with SQL keyword

[herkules]

Hi,

This simple entity won't work with EJB3:

public class Attribute implements Serializable {

 private Long id;

 private Byte order;

 @Id
 @GeneratedValue
 public Long getId() {
 return id;
 }

 public void setId(Long id) {
 this.id = id;
 }

 public Byte getOrder() {
 return order;
 }

 public void setOrder(final Byte order) {
 this.order = order;
 }
}

Because JBoss/Hibernate doesn't escape column names with quotes (or DB specific escaping):

create table Attribute (id bigint generated by default as identity (start with 1), order tinyint)
..
Unexpected token: ORDER in statement

I don't want to use artificial name for the column, I'd rather see something like this:

create table Attribute (id bigint generated by default as identity (start with 1), 'order' tinyint)

Is there a (db independent) solution?

Thanks Jan

[herkules]

I don't know if this question is so trivial so nobody bothers to answer or I breaked some nettique or simply everybody lives with it and use artifficial property names to avoid column name clashes?
Or am I simply ignored by this forum?

Thanks, Jan

[maxandersen]

@Column(name="`order`")

[tsar_bomba]

@Column(name="`order`")

This appears to work until you have a @OneToMany join between a parent & child entity, then Hibernate "forgets" to quote the fields on the child-side of the join.

I'm not sure if this is a bug (though it would appear so, since Toplink allows it in Glassfish.) I posted here about this yesterday and haven't gotten a reply yet to confirm.