[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2630) Hibernate Dialect is not auto-detected for Sybase ASE and DB2

[Emmanuel Bernard (JIRA)]

Hibernate Dialect is not auto-detected for Sybase ASE and DB2
-------------------------------------------------------------

                 Key: HHH-2630
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2630
             Project: Hibernate3
          Issue Type: Improvement
          Components: metamodel
    Affects Versions: 3.2.4.sp1
            Reporter: Emmanuel Bernard
            Assignee: 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://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira