Hibernate Dialect is not auto-detected for Sybase ASE and DB2 ------------------------------------------------------------- Key: HIBERNATE-64 URL: http://jira.jboss.com/jira/browse/HIBERNATE-64 Project: Hibernate Issue Type: Bug Reporter: Shelly McGowan Assigned To: Emmanuel Bernard The hibernate auto-detection mechanism was tested with the following Databases. DB2 and Sybase ASE - are not automatically detected. DB2 v8.0: javax.persistence.PersistenceException: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: DB2/LINUX NOTE: looks like it will be auto-detected for DB2/NT Sybase ASE 12.5: [SettingsFactory] RDBMS: Adaptive Server Enterprise, version: Adaptive Server Enterprise/12.5.3/EBF 13332 ESD#7/P/Linux Intel/Enterprise Linux/ase1253/1951/32-bit/OPT/Fri Mar 24 00:40:52 2006 16:52:09,234 INFO [SettingsFactory] JDBC driver: jConnect (TM) for JDBC (TM), version: jConnect (TM) for JDBC(TM)/5.5(Build 25827)/P/EBF13045/JDK13/Mon Oct 3 7:31:59 2005 javax.persistence.PersistenceException: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Adaptive Server Enterprise The following were auto-detected: Oracle 9i: OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.1.0.3.0 [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect Oracle 10g: [org.hibernate.cfg.SettingsFactory] RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production [org.hibernate.cfg.SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.1.0.3.0 [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect MsSQLServer 2005: [org.hibernate.cfg.SettingsFactory] RDBMS: Microsoft SQL Server, version:9.00.2047 14:25:23,808 INFO [SettingsFactory] JDBC driver: Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101 [Dialect] Using dialect: org.hibernate.dialect.SQLServerDialect PostgresSQL 8.1: [SettingsFactory] RDBMS: PostgreSQL, version: 8.2.3 [SettingsFactory] JDBC driver: PostgreSQL Native Driver,version: PostgreSQL 8.2 JDBC3 with SSL (build 504) [Dialect] Using dialect: org.hibernate.dialect.PostgreSQLDialect MySQL 5.0: SettingsFactory] RDBMS: MySQL, version:5.0.27-standard-log [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ ) [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira