SEAM 2.2 Hibernate and PostgreSQL 8.4

[arturfriesen]

I try to get SEAM 2.2 with PostgreSQL 8.4 running.
If i try to add an entity (via the generated xhtml pages) to the database i get the following error:

16:43:06,455 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 42601
16:43:06,456 ERROR [JDBCExceptionReporter] Batch-Eintrag 0 insert into User (email, name, version, id) values (NULL, 'ccds', '0', '10') wurde abgebrochen.  Rufen Sie 'getNextException' auf, um die Ursache zu erfahren.
16:43:06,456 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 42601
16:43:06,456 ERROR [JDBCExceptionReporter] ERROR: syntax error at or near "User"

Hibernate tries to execute the following on the database:

insert into User (email, name, version, id) values (NULL, 'ccds', '0', '10')

But PostgreSQL only understands the following (The tablename has to be in apostrophe):

insert into "User" (email, name, version, id) values (NULL, 'ccds', '0', '10')

i tried jdbc connectors:
postgresql-8.4-701.jdbc3, postgresql-8.4-701.jdbc4

With both the same issue...

has anybody an idea how to fix this?

[robshep]

Artur,

Specifically, the word user is a PostgreSQL keyword, and wrapping it in double quotes removes any ambiguity and postgres will then treat it as you intend: as a table name.

Try adding the following to User.java

 @Entity
+@Table(name="Person")
 public class User {

- OR -

 @Entity
+@Table(name="Users")
 public class User

comment is another such keyword. There's probably more.

Hope this helps

Rob

[arturfriesen]

Thank you vey much Rob!!