Hi. I'm trying to use EJB3.0 (latest) with PostgreSQL. I'm having some troubles, when I want to use postgresql reserved words for my table names, like this:

when i do a: select o.orderId from Order as o
hibernate generates: select order0_.order_id as x0_0_ from order order0_
the correct sql would be: select order0_.order_id as x0_0_ from "order" order0_

In other words, it does't escape table names as they should be. I found somewhere that I should add backticks (`) around my table name, but that was when I configure Hibernate with xml files. Since I'm using annotations, I'm doing this:

@Table(name = "`Order`")

Which works fine for entities that does not have relations. When I introduce them, it gets this error:

Caused by: org.hibernate.MappingException: Unable to find physical table: Order

Can anyone help me? Here is a more complete code sample:

Blah.java

@Entity
@Table(name = "`Blah`")
public class Blah {
 public int id;
 public String foo;

 public String getFoo() {
 return foo;
 }

 public void setFoo(String foo) {
 this.foo = foo;
 }

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

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

}

Foo.java

@Entity
@Table(name = "`Foo`")
public class Foo {
 public int id;
 public Blah blah;

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

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

 @ManyToOne
 public Blah getBlah() {
 return blah;
 }

 public void setBlah(Blah blah) {
 this.blah = blah;
 }

}

The error:

java.lang.reflect.InvocationTargetException
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.ejb3.ServiceDelegateWrapper.startService(ServiceDelegateWra
.............
.............
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
loop(AbstractDeploymentScanner.java:218)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
run(AbstractDeploymentScanner.java:197)
Caused by: org.hibernate.MappingException: Unable to find physical table: Blah
 at org.hibernate.cfg.Mappings.getLogicalTableName(Mappings.java:473)
 at org.hibernate.cfg.Mappings.getLogicalTableName(Mappings.java:520)
 at org.hibernate.cfg.Ejb3JoinColumn.linkValueUsingDefaultColumnNaming(Ej
b3JoinColumn.java:270)
 at org.hibernate.cfg.annotations.TableBinder.bindFk(TableBinder.java:194
)
 at org.hibernate.cfg.FkSecondPass.doSecondPass(FkSecondPass.java:44)
 at org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(Annotatio
nConfiguration.java:233)
 at org.hibernate.cfg.Configuration.buildMappings(Configuration.java:997)

 at org.hibernate.ejb.Ejb3Configuration.buildMappings(Ejb3Configuration.j
ava:722)
 at org.hibernate.ejb.EventListenerConfigurator.configure(EventListenerCo
nfigurator.java:161)
 at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Co
nfiguration.java:567)
 at org.hibernate.ejb.Ejb3Configuration.createContainerEntityManagerFacto
ry(Ejb3Configuration.java:245)
 at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFa
ctory(HibernatePersistence.java:108)
 at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnit
Deployment.java:260)
 ... 77 more