HI all,

currently my application is running with HIbernate 3.3.2 and Oracle by using dialect org.hibernate.dialect.Oracle10gDialect
Now we want to migrate to Sybase IQ Server Suite 15.4 (64-bit) I replaced it with "
jdbc.url= jdbc:sybase:Tds:172.16.1.115:2638/iqdemo
jdbc.username=bizscore_application
jdbc.password=Welcome1
jdbc.driverClassName=com.sybase.jdbc3.jdbc.SybDriver
hibernate.dialect=org.hibernate.dialect.SybaseDialect" but when Iam executing HQL with one to many mappings Iam not getting exact results.

Is the mappings in xml file is specific to DB?

Should I make any changes in configuration file specific to Sybase?

One aspect I know off which sometimes is an issue is the ID generation logic. For example, SQL Server does not support sequences while Oracle does. In SQL Server you use identity columns. Never worked with the database you are referring to though.