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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3920597#3920597 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3920597 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
