-
1. Re: Changing from H2 database to MSQL database
swiderski.maciej Sep 6, 2012 3:37 AM (in response to tmmaluleke)if you changed data base you should not use:
ant install.demo.db
ant start.demo.db
as you use a sepearate data base that is most likely already started.
What error do you get? I don't see any relationship between eclipse and data base....
HTH
-
2. Re: Changing from H2 database to MSQL database
loaone Sep 6, 2012 4:47 AM (in response to swiderski.maciej)Hello
The how do you start the demo then?
-
3. Re: Changing from H2 database to MSQL database
tmmaluleke Sep 6, 2012 4:48 AM (in response to swiderski.maciej)Hello,
So how do i start jbpm do i use the ant start.demo or something?
cheers
-
4. Re: Changing from H2 database to MSQL database
loaone Sep 6, 2012 4:51 AM (in response to tmmaluleke)Yes i use the ant start.demo but it still shows the H2 database
Thanx
-
5. Re: Changing from H2 database to MSQL database
tmmaluleke Sep 21, 2012 3:50 AM (in response to swiderski.maciej)Hello Maciej Swiderski,
I want to understand something after modifying the files because I followed the steps of chapter 3. Installer from the user guide, so how do I start because you saying I should not use the ant install.demo.db what am I suppose to do after modifying the xml files?
Please Help I will appritiate it and thanx in advanced.
cheers
-
6. Re: Changing from H2 database to MSQL database
tmmaluleke Sep 27, 2012 5:12 AM (in response to tmmaluleke)Hello Maciej Swiderski,
I have managed to change the database thanx for the help.
cheers
-
7. Re: Changing from H2 database to MSQL database
gvino Oct 15, 2012 7:54 AM (in response to tmmaluleke)Hi,
I have the same question.
after I configured those xml files, how should I do to start the Eclipse with mysql database?
any help will be appreciated!
-
8. Re: Changing from H2 database to MSQL database
tmmaluleke Oct 16, 2012 2:43 AM (in response to gvino)Hello gvino,
After editing the xml files you need to run your database, then ant start.demo.
HTP
cheers
-
9. Re: Changing from H2 database to MSQL database
gvino Oct 16, 2012 10:57 PM (in response to tmmaluleke)Hello tmmaluleke,
Thanks for your answer.
My database already generated some tables after ant start.demo.db
But when I use "ant start.demo" , it will launch h2 database.
my question is how can i launch eclipse using "ant start.demo" with my database (MySQL)
Thanks!
-
10. Re: Changing from H2 database to MSQL database
tmmaluleke Oct 17, 2012 3:33 AM (in response to gvino)Hello gvino,
This is what I did: I downloaded mysql-connector( mysql-connector-java-5.1.18) then copied the jar file to the jbpm-installer\db\driver\mysql-connector-java-5.1.18-bin.jar,
then after installing the ant.install.db there will be mysql folder in C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main then you edit the module.xml
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java-5.1.18-bin.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
After you run your database and ant start.demo it won't start the H2 coz you have edited all the xml files to mysqlDialect and the drivers. Please update me after doing this what happen.
-
11. Re: Changing from H2 database to MSQL database
gvino Oct 17, 2012 11:16 PM (in response to tmmaluleke)Hi tmmaluleke,
This is what I did:
1. modified those xml files which mentioned on the Chatper3.Installer http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html
http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html2. copied "mysql-connector-java-5.1.22-bin.jar" to jbpm-installer\db\driver folder
3. ant clean.demo4. ant install.demo.db
5. after that, I can't find mysql folder in jbpm-installer\jboss-as-7.0.2.Final\modules\com
there are only "google", "h2" , "sun" three folder.
I found following that in build.xml
line17:
<property name="mysql.download.url"
line43:
<!-- Download JDBC driver jar (MySQL is default)-->
<property name="db.driver.jar.name" value="mysql-connector-java.jar" />
Am I need to change them to "mysql-connector-java-5.1.22-bin.jar" ??
Thanks.
-
12. Re: Changing from H2 database to MSQL database
tmmaluleke Oct 18, 2012 2:58 AM (in response to gvino)Hello gvino,
Download myqsl-connector5.1.18 jar file
cheers
-
13. Re: Changing from H2 database to MSQL database
gvino Oct 19, 2012 3:42 AM (in response to tmmaluleke)Hi ,
I downloaded mysql-connector-java.jar file and put it in my db/driver folder.
after I user "ant install.demo.db" , It won't have com/mysql folder.
then I check build.xml file, found that it will execute "install.db.files" when I use "start.demo.db"
so after I done this , I can find my con/mysql folder.
Then I run my database, I can find the tables created in my database.
after these operation, I think that I alredy succeed in connecting my jBPM to MySQL database.
But when I try to use "ant start.demo", I got Build failed and following is the error messages
BUILD FAILED
jbpm-installer\build.xml:808: Execute failed: java.io.IOException: Cannot run program ".\eclipse\eclipse.exe": C
reateProcess error=2, ?t?Χ??????
I thought that was because my eclipse didn't install successfully.
so I tried to user "ant install.eclipse"
finally I use "ant start.demo"
but the script always show that start h2 database.
How can I sure that eclipse open up with my own database(mysql).
Plus , after those operation, I can't open my web console http://localhost:8080/jbpm-console/
HTTP Status 404 - /jbpm-console/
type Status report
message /jbpm-console/
description The requested resource (/jbpm-console/) is not available.
btw,I am using jbpm5.3 on windows7 64bits
Thanks!