1 Reply Latest reply on Jan 31, 2006 2:31 AM by Hideo GOTO

    Can't create EJB3.0 POJO entity bean

    Hideo GOTO Newbie

      I have difficulty to make run EJB3.0 POJO entity beans on JBOSS AS 4.0.3SP1 after changing backend DB to PostgreSQL. The related error messages are as follows:

      15:53:42,170 ERROR [SchemaExport] Unsuccessful: create table APPLICANTS (APPLICANT_ID bigint generated by default as identity (start with 1), primary key (APPLICANT_ID))
      15:53:42,170 ERROR [SchemaExport] ERROR: syntax error at or near "generated"

      The generated SQL statement contains words "generated by default" illegal for PostgreSQL. I guess underlying Hibernate still generating SQL for HSQLDB, as I also see in the same log the following message:

      15:53:40,781 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect

      I would be grad if anyone could advise me how to mod or override this Hibernate setting. I tryied creating META-INF/hibernate-properties in my deployment files in vain.

      Thanks in advance.

      Hideo GOTO