change database

[jbmpuser]

Hi, I am new user jbpm.
I read the starter guide (the post above). It is wonderful and helpful for me, but
how I can change the database?? I would like use a sql database, no hypersonic.

Anyone can to help me??
It is urgent, please!!

Thank you.

[kukeltje]

@estaub: Do you respond or do I?

[jbmpuser]

???????????
I don't understand.
Please, excuse me for my english.

[kukeltje]

http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4004797#4004797

[jbmpuser]

I am sorry, but i don't understand nothing!!!
Because you tell me this url??? What is???

Please, tell me something!!!

[kukeltje]

it is an indirect way to tell you to read the documentation, wiki etc... first and if you cannot get something to work, post a question again with the errors

[jbmpuser]

Somebody tell me step by step instructions for change database? more or less, please!!!

Thank you.

[fuligj]

To change the database for jBPM 3.1.* there is a pretty wiki: http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnPostgreSQL.
But the jbpm-jpdl-3.2.Beta1's frame a little bit other and I can't change the DB among this wiki.
Can anyone tell, how can I change the DB in jbpm-3.2.1?

best regards!

[jbmpuser]

I read also this document: http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnMSSQLServer
but it is not actuallity, because it is for jbpm 2 and I am using jbpm 3

I think is very difficult to change database!!!!

[fuligj]

To change DB for jbpm 3 use http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnPostgreSQL.
It's works.

[jbmpuser]

but I would like use a sql database, no a postgree database :(

[morpheus_jboss]

pls read chapter 8 of the jbpm user guide

[estaub]

I just switched to Oracle today, so this is all pretty fresh in my head (unlike most of the rotten stuff in there).

First, if you haven't already, see http://docs.jboss.org/jbpm/v3/userguide/persistence.html#changingthejbpmdb and the surrounding context.

So you need to change the jdbc connection info in the hibernate configuration file. In the starter kit, it's called hibernate.cfg.xml.
The lines of interest are:

<!-- jdbc connection properties -->
 <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
 <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
 <property name="hibernate.connection.url">jdbc:hsqldb:mem:.;sql.enforce_strict_size=true</property>
 <property name="hibernate.connection.username">sa</property>
 <property name="hibernate.connection.password"></property>

I started by getting the HelloWorldDbTest in the tutorials to work.
If you do this, note that it creates the needed schema in the database in setup() and deletes it all at teardown(). This had me confused for a while - I had set up the schema by script first, and after I ran the test - poof - all my tables had disappeared!

If you want scripts for creating the schema, they're in the starter's kit under jbpm-db/build for most DBs. For Oracle, you have to run the target in the jbpm-db antfile yourself - it's called "oracle.scripts" if I remember right. This will create them under the "build" subtree.

-Ed Staub

[jbmpuser]

Very, very, thanks, expecially to yoyoyoyo!!!

Now I have a sql database to work for it!!!!

Thank very much!!!

[fuligj]

Well. Can anyone help me to change the db in jbpm-jpdl-3.2.Beta1?
Thanks.