2 Replies Latest reply on May 14, 2010 8:56 AM by Artur Friesen

    SEAM 2.2 Hibernate and PostgreSQL 8.4

    Artur Friesen Newbie

      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?