[jboss-user] [jBPM] - [jBPM 5.3 - SQL] - Setting up jBPM5.3 with MS SQL Server 2008 (jtds)

Thomas Setiabudi [https://community.jboss.org/people/thomas.setiabudi] created the discussion "[jBPM 5.3 - SQL] - Setting up jBPM5.3 with MS SQL Server 2008 (jtds)" To view the discussion, visit: https://community.jboss.org/message/751586#751586 -------------------------------------------------------------- Hi, I try to setup jBPM5.3 with MS SQL Server 2008 but still cant get it works. I have done the following steps 1. Download "jbpm-5.3.0.Final-installer-full.zip" 2. Download "eclipse-java-helios-SR2-win32-x86_64.zip" as my dev PC does not have Internet connection 3. unzip the "jbpm-5.3.0.Final-installer-full.zip" and I get the "jbpm-installer" folder 4. copy the "eclipse-java-helios-SR2-win32-x86_64.zip" to "jbpm-installer\lib" 5. modify the build.xml in "jbpm-installer" :     I made change from: <!-- Download Eclipse -->   <condition property="download.type" value="win32">     <os family="windows" />   </condition> to <!-- Download Eclipse -->   <condition property="download.type" value="win32-x86_64">     <os family="windows" />   </condition> in order to make the ant install.demo detect my eclipse installer 6. Then I start to refer the instruction to change the DB in http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e597 http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e597 7. changed hibernate dialect in "db/persistence.xml" to SQLServerDialect (attached file db_persistence.xml) <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/> 8. changed another persistence.xml in "task-service/resources/META-INF/persistence.xml" (attached task-service_resources_meta-inf_persistence.xml) <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>       <property name="hibernate.connection.driver_class" value="net.sourceforge.jtds.jdbc.Driver"/>       <property name="hibernate.connection.url" value="jdbc:jtds:sqlserver://DBName:1433/MyTaskDB" /> 9. As the jBPM 5.3 full installer comes with JBoss AS 7, so I modified the "standalone.xml" (attached standalone.xml) <datasources>                 <datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" jta="true" use-java-context="true" use-ccm="true">                     <connection-url>jdbc:jtds:sqlserver://DBName:1433/MyJBPMDB</connection-url>                     <driver>JTDS</driver>                     <pool>                         <min-pool-size>1</min-pool-size>                         <max-pool-size>4</max-pool-size>                         <prefill>false</prefill>                         <use-strict-min>false</use-strict-min>                         <flush-strategy>FailingConnectionOnly</flush-strategy>                     </pool>                     <security>                        <user-name>test</user-name>                        <password>12345</password>                     </security>                     <validation>                        <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>                        <validate-on-match>false</validate-on-match>                        <background-validation>false</background-validation>                     </validation>                 </datasource>                 <drivers>                    <driver name="JTDS" module="net.sourceforge.jtds">                             <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>                      </driver>                 </drivers>             </datasources> 10. Because I use SQL Server, I continue to section "3.7.4. Using a different database" in http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e597 http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e597 I choose to install the DB Driver in JBoss AS 7 as module, so..: 11. in build.xml, I change the db.driver.jar.name to <property name="db.driver.jar.name" value="jtds-1.2.4.jar" /> 12. reopen the standalone.xml and make sure the driver name <driver>JTDS</driver> match with <drivers>                    <driver name="JTDS" module="net.sourceforge.jtds">                             <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>                      </driver>                 </drivers> 13. open build.xml again, and change the db.driver.module.prefix to <property name="db.driver.module.prefix" value="net/sourceforge/jtds"/> 14. modify the "db/driver_jar_module.xml" (attached as db_driver_jar_module.xml) <module xmlns="urn:jboss:module:1.0" name="net.sourceforge.jtds">    <resources>      <resource-root path="jtds-1.2.4.jar"/>    </resources>    <dependencies>       <module name="javax.api"/>       <module name="javax.transaction.api"/>     </dependencies> </module> 15. ok, up to this step, I tried to run ant install.demo.db      and then followed by ant start.demo.db The DB Tables are created properly in my MS SQL Server. But I cannot use the jbpm-console, it turns out that the jbpm-console has its own persistence.xml that needs to be modified, as does the human task war so I go and modify those two persistence.xml (by exploding the war and re-war it again) and fix the hibernate dialect in those two persistence.xml try again with fresh unzip of full installer but still no luck, I still got the resteasy error when opening the jbpm-console, and if I start the sample from eclipse, I got the could not connect to taskclient error, mentioning something about the hornetq. anything i miss out? -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/751586#751586] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]