[jboss-user] [jBPM] - [jBPM 5.3 - SQL] - Setting up jBPM5.3 with MS SQL Server 2008 (jtds)
Thomas Setiabudi
do-not-reply at jboss.com
Thu Aug 2 00:54:06 EDT 2012
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&containerType=14&container=2034]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120802/62812ac9/attachment.html
More information about the jboss-user
mailing list