[jboss-user] [JBoss jBPM] - Re: Problem with changing backend database to mysql

[mputz]

First, if you really want to use the datasource as defined in jbpm-ds.xml, you should alter hibernate.cfg.xml to resemble this:


  |         <!-- DON'T USE DIRECT HIBERNATE CONFIGS, USE DATASOURCE INSTEAD  -->
  |     <!--
  |     <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  |     <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpmbackend</property>
  |     <property name="hibernate.connection.username">root</property>
  |     <property name="hibernate.connection.password">password</property>
  |     -->
  |     <!-- JDBC connection properties (end) -->
  |         <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
  |         <!-- DataSource properties (begin) -->    <property name="hibernate.connection.datasource">java:/JbpmDS</property>    <!-- DataSource properties (end) -->

Next, do you have users in your database? What does this SQL query return?
SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_='manager'

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135206#4135206

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