[jboss-user] [JBoss jBPM] - Re: Problem with changing backend database to mysql
Sorry I should have posted more details in my first message.
In jbpm-ds.xml I have changed the code to the following
| <?xml version="1.0" encoding="UTF-8"?>
|
| <datasources>
|
| <local-tx-datasource>
| <jndi-name>JbpmDS</jndi-name>
|
<connection-url>jdbc:mysql://localhost:3306/jbpmbackend</connection-url>
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| <user-name>root</user-name>
| <password>password</password>
| <metadata>
| <type-mapping>MySQL</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| </datasources>
|
In login-config.xml I have added the following to the end of the file
| <application-policy name = "jbpm">
| <authentication>
| <login-module
code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
| flag="required">
| <module-option
name="dsJndiName">java:/JbpmDS</module-option>
| <module-option name="principalsQuery">
| SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=?
| </module-option>
| <module-option name="rolesQuery">
| SELECT g.NAME_ ,'Roles'
| FROM JBPM_ID_USER u,
| JBPM_ID_MEMBERSHIP m,
| JBPM_ID_GROUP g
| WHERE g.TYPE_='security-role'
| AND m.GROUP_ = g.ID_
| AND m.USER_ = u.ID_
| AND u.NAME_=?
| </module-option>
| </login-module>
| </authentication>
| </application-policy>
|
In standardjaws.xml I have changed it to
| <jaws>
| <datasource>java:/JbpmDS</datasource>
| <type-mapping>mySQL</type-mapping>
| <debug>false</debug>
| ......
|
In the hibernate.cfg.xml file, I have changed it to the following:
<?xml version='1.0' encoding='utf-8'?>
|
| <!DOCTYPE hibernate-configuration PUBLIC
| "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
|
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
|
| <hibernate-configuration>
| <session-factory>
|
| <!-- hibernate dialect -->
| <!--<property
name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
-->
| <property
name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
|
| <!-- JDBC connection properties (begin) -->
| <!--<property
name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
-->
| <!--<property
name="hibernate.connection.url">jdbc:hsqldb:mem:jbpm</property> -->
| <!--<property
name="hibernate.connection.username">sa</property> -->
| <!--<property
name="hibernate.connection.password"></property> -->
| <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) -->
|
| <!-- JTA transaction properties (begin) -->
| <property
name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
| <property
name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
| <!-- JTA transaction properties (end) -->
|
Any help would be appreciated.
Thanks
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135184#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...