linkedin/glu — Issue #111: Console server initialization fails with Oracle 11g
Author: lucasmcgrew
Created: 2011-12-08 21:30:17+00:00
State: open

The problem is the table named 'user' which is a reserved word in oracle, so the table cannot be created:

10148 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table user (id number(19,0) not null, version number(19,0) not null, username varchar2(255 char) not null unique, primary key (id))
10148 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - ORA-00903: invalid table name

I assume the same issue will be present with Postgres database servers and perhaps others. Hibernate 3.5+ appears to have a potential solution, but I'm not too familiar with grails/hibernate version compatibility:

http://docs.jboss.org/hibernate/core/3.5/api/org/hibernate/cfg/Environment.html#GLOBALLY_QUOTED_IDENTIFIERS