Since the jboss seam console (jbpm-enterprise.ear) does not contain a hibernate.cfg.xml file, it is my assumption that seam/hibernate takes the dialect from the <type-mapping> in the jbpm-ds.xml which contains in my case : <type-mapping>Oracle9i</type-mapping> I can see in the log file that the oracle 10G dialect is used for datasource java:/JbpmDS : 2008-11-05 08:18:58,128 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 2008-11-05 08:18:58,128 INFO [org.hibernate.connection.DatasourceConnectionProvider] Using datasource: java:/JbpmDS 2008-11-05 08:18:58,331 INFO [org.hibernate.cfg.SettingsFactory] RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options 2008-11-05 08:18:58,331 INFO [org.hibernate.cfg.SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.2.0.4.0 2008-11-05 08:18:58,347 INFO [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect 2008-11-05 08:18:58,347 INFO [org.hibernate.transaction.TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory ) BUT ... then further in the log I see this: 2008-11-05 08:20:16,184 DEBUG [org.jbpm.persistence.db.DbPersistenceServiceFactory] building hibernate session factory 2008-11-05 08:20:16,184 DEBUG [org.jbpm.db.hibernate.HibernateHelper] creating hibernate configuration resource 'hibernate.cfg.xml' 2008-11-05 08:20:16,184 INFO [org.hibernate.cfg.Configuration] configuring from resource: hibernate.cfg.xml 2008-11-05 08:20:16,184 INFO [org.hibernate.cfg.Configuration] Configuration resource: hibernate.cfg.xml 2008-11-05 08:20:16,184 DEBUG [org.hibernate.util.DTDEntityResolver] trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] 2008-11-05 08:20:16,184 DEBUG [org.hibernate.util.DTDEntityResolver] recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/ 2008-11-05 08:20:16,184 DEBUG [org.hibernate.util.DTDEntityResolver] located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath 2008-11-05 08:20:16,184 DEBUG [org.hibernate.cfg.Configuration] hibernate.dialect=org.hibernate.dialect.HSQLDialect2008-11-05 08:20:16,184 DEBUG [org.hibernate.cfg.Configuration] hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider 2008-11-05 08:20:16,184 DEBUG [org.hibernate.cfg.Configuration] hibernate.connection.datasource=java:comp/env/jdbc/JbpmDataSource Which raises my question: Is defining the jbpm datasource xml not enough for the jbpm-console to specify the database to use??? What more do we need to change / add??? (We do have deployed an application build with seam in the same app.server that does contain a hibernate.cfg.xml but that one is pointing to a DB2 database (with a DB2Dialect)) Any help would be appriciated! Jan View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4186920#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...