user table with javaDB and Hibernate from within grails
- by Ralf
let's see if I can ask this in an understandable way...
I started with grails and created a domain class called user. As far as I understand, Hibernate is used to map this domain class to the database. This works pretty fine with hsqldb.
Now I tried to switch to javaDB and get an error message because the table is called "user" (which seems to be a reserved word for javaDB).
So a statement like
create table user ...
will result in an error message.
create table "user" ...
works, but Hibernate seems not put put the table name in quotes.
How can I configure Hibernate to use quotes in order to make it work with my table name?
PS: yes, I know, I could map the domain class to another table name... :-)
