RE: EJBTHREE-328

The hibernate auto-detection mechanism was tested with the targeted JBPAPP Tier1 DB/Driver combinations defined in the PRD. Of the 8 listed, two - DB2 and Sybase - 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