[jboss-user] [JBoss jBPM] - Re: Problem with JBPM running on Oracle

[janvandeklok]

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#4186920

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4186920