13 Replies Latest reply on Oct 19, 2012 3:42 AM by gvino

Changing from H2 database to MSQL database

tmmaluleke Sep 5, 2012 6:35 AM

Hello,

I have moved fron the H2 database to MSQL database. these are the steps that I did:

db/persistence.xml
task-service/resources/META-INF/persistence.xml
db/jBPM-ds.xml
standalone.xml
ant clean.demo
ant install.demo.db
ant start.demo.db

I' currently using jboss 7 but the Eclipse editor is not starting and when I do the ant start.demo it's gives me and error for which i understand coz I have changed the database.

My question is how can I start the Eclipse editor together with mysql database?

cheers

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
Actions
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?
Actions
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
Actions
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
Actions
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
Actions
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
Actions
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!
Actions
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
Actions
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!
Actions
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"/>
        
</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.
Actions
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.demo
4. 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"
value="https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18.jar" />

line43:

<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.
Actions
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
Actions
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!
Actions

Go to original post

HTTP Status 404 - /jbpm-console/