[jBPM] - [jBPM 5.3 - SQL] - Setting up jBPM5.3 with MS SQL Server 2008 (jtds)
by Thomas Setiabudi
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&con...]
14 years
[jBPM] - Re: Which Designer?
by Tihomir Surdilovic
Tihomir Surdilovic [https://community.jboss.org/people/tsurdilovic] created the discussion
"Re: Which Designer?"
To view the discussion, visit: https://community.jboss.org/message/751532#751532
--------------------------------------------------------------
*******
Inside the web designer the process keeps its original name with Test although the name in the imported file is different (same for Asset in the defaultPackage tree browser on the left)
******
The name of your process asset and the actual process name and id attributes are not related. You can name your process asset "MyProcess" but set the name and id attributes inside it to something completely different if you so wish..that is up to you and not Designer :) Designer however when you create a new process auto-fills the name of your process and the id using the package name and the asset name for you for convenience..this is for new processes only.
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/751532#751532]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
14 years
[jBPM] - Re: Which Designer?
by Tihomir Surdilovic
Tihomir Surdilovic [https://community.jboss.org/people/tsurdilovic] created the discussion
"Re: Which Designer?"
To view the discussion, visit: https://community.jboss.org/message/751458#751458
--------------------------------------------------------------
>> Another question by the way : is there a more simple way to get web designer version directly under drools-gubnor ;) ? <<
You can click on the "Info" button in the Designer navigation bar which will give you it's version. It is a round button with an "i" in it ;)
>> many input fields are free and there is not much assistance on what to input <<
This was made easier in Designer 2.3.0.Final, as you now have task-type specific properties. So by changing your task type, the properties shown are specific to it rather than showing general task properties.
>> I don't not know what mistake I must have made but now I have nothing the Evaluation process. No matter I will use the import BPMN2 function, but when you paste the orignal source code of the Evaluation.bpmn file, I have an error in the server log of JAS 7.0.2 (NPE). <<
What is this error? There are some minor differences in the generated BPMN2 code with the Eclipse editor so there could be some problems moving it to Designer, but if you show us the BPMN2 we can point you in the right direction quickly
>> I try to use a "Reusable Subprocess" when in the window "Editor for Called Elements" i have no process in the list although I have other defined in drools guvnor... <<
I have not encountered this problem yet, in Guvnor if you go to the Administration tab and then Import/Export, can you export your repository (it will generate a .zip file that you can save) and show it so can test?
>> I try to save all other processes and export bpmn2 files and same for process images (png) and then I have some processes displayed in the list but not all :( and I don't understand why... <<
Not sure either without seeing some errors in logs or a better, reproducible description of what you are doing
>> How do you use Boundary Events ? In my version I don't think I am able to specify a Boundary Event on a specific Task, no graphical component named Boundary Event available in the Shape Repository... <<
You can drag an even to the edge of a task/subprocess and you will see its edges turn green color. Dropping your even when the edges are green will make it a boundary event automatically for you.
>> When writing this, I told myself I must give another try : with a task, miracle it's working. In fact I think I am not used to clicking on the Morph Shape Function. I thought all the possible components were avaibable in the Shape Repository but it seems that it is not the case. (ex: Throwing Error Intermediate Event displayed in blue color not avaibable directly (you must use Morph Shape to get it) although Catching Error Intermediate Event displayed in brown color available in the Shape Repository). Actually I tried till now to put a Boundary Event on a Reusable SubProcess directly and with this web designer version it don't think it is possible : you must first put the Boundary Event on a Basic Task first and then Morph the Basic Task to a Reusable Subprocess so that it works. <<
I will try this out..but best for you would be if you encounter issues like this to open a jBPM Jira so we can fix it.
>> 1- I read in the 5.3.0 Final User Guide that there were a way to directly use an xml file describing a BPM process so it means that the web designer does not offer all the functionnalities the jBPM engine is able to handle, is that correct? <<
Nope, from the current jBPM BPMN2 Editors Designer is the only one what actually supports everything that the jBPM runtime can execute.
>> 2- If I use New BPMN2 modeler unde eclipse will the JBPM Engine be able to handle everything coming from eclipse New BPMN2 Modeler file? <<
With Eclipse you have to at times modify the BPMN2 XML by hand to some constructs in there.
>> I must say that I really enjoy jBPM solution through the documentaiton even if I think in my case and opinion the first steps are not easy to handle when using the differents tools. <<
Well we give you free help here or on IRC or if you raise Jiras we fix them also for free ... so you could maybe help with the documentation as well if you feel like contributing something back ;)
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/751458#751458]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
14 years