EJB3, Sybase database, MappingException: Dialect does not su

[yujianming]

We are using Jboss4.2.1GA. I am adding a new Sybase data source. But when I start Jboss, the error message is as following. The .ear is not even deployed. May I know how to solve this problem?

Thank you very much!

James
**************************************Error Message***********************

Caused by: org.hibernate.MappingException: could not instantiate id generator
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:98)
at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:152)
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:192)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730)
... 145 more
Caused by: org.hibernate.MappingException: Dialect does not support sequences
at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:596)
at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
at org.hibernate.id.SequenceHiLoGenerator.configure(SequenceHiLoGenerator.java:43)
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:94)

[jaikiran]

Caused by: org.hibernate.MappingException: Dialect does not support sequences

As per this message, the dialect that you have mentioned in your hibernate configuration file does not support SEQUENCE to generate a ID column value.

[yujianming]

Thank you. My setup is as following. May I know what the dialect that I should use for Sybase database?
James
***********************************************************
<persistence-unit name="SybaseDB">
org.hibernate.ejb.HibernatePersistence
<jta-data-source>java:/SybaseDB</jta-data-source>




</persistence-unit>

[yujianming]

The .xml file is not shown properly. The setup in our appliation is as following:

property name="hibernate.dialect" value="org.hibernate.dialect.SybaseDialect"
property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"