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
I found out the Hibernate.properties in the file:
deploy/ejb3.deployer/META-INF/persistence.properties
and could solve my issue.
Sorry for my careless distubance.
Hideo GOTO