Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version: 3.0[/b]

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using: postgresql 8.0 [/b]

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]

Hi,

Am actually trying to create tables in my db from xdoclet tag placed in each of my class.
For my class User, I've put the following

@hibernate.class
table = "user"

but, table user has not been created. I then made the following modification:

@hibernate.class
table = "my_user"

Now it has been created. It seems that the word 'user' is reserved for Hibernate!! Is this true?
Can anyone please explain why this is so. Or have I made a mistake.

thanks in advance

"User" is a reserved word in most database implementations. Did you try running the DDL manually and see if you got any errors? Hibernate doesn't (AFAIK) have any keyword restrictions, nor should it.

Hi,

Since I'm new to Hibernate can you please explain to me what do you mean by runnning 'DDL manually'. In fact what is DDL?

thanks in advance

DDL is Data Definition Language, the subset of SQL that is used to define tables and such: Google

You are using Postgres, with which I'm not familiar - but I assume there is some way to manually execute SQL commands. I don't know how you're generating the Hibernate schema, but somewhere you probably have a command starting e.g.


I'd highly suggest picking up a good book on database concepts, you'll have a very hard time understanding Hibernate if you don't understand databases.

thank you very much for your explanation