-
1. Re: change database
kukeltje Jan 22, 2007 12:19 PM (in response to jbmpuser)@estaub: Do you respond or do I?
-
2. Re: change database
jbmpuser Jan 22, 2007 1:22 PM (in response to jbmpuser)???????????
I don't understand.
Please, excuse me for my english. -
4. Re: change database
jbmpuser Jan 22, 2007 1:41 PM (in response to jbmpuser)I am sorry, but i don't understand nothing!!!
Because you tell me this url??? What is???
Please, tell me something!!! -
5. Re: change database
kukeltje Jan 22, 2007 1:48 PM (in response to jbmpuser)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
-
6. Re: change database
jbmpuser Jan 23, 2007 3:45 AM (in response to jbmpuser)Somebody tell me step by step instructions for change database? more or less, please!!!
Thank you. -
7. Re: change database
fuligj Jan 23, 2007 4:55 AM (in response to jbmpuser)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! -
8. Re: change database
jbmpuser Jan 23, 2007 5:49 AM (in response to 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!!!! -
9. Re: change database
fuligj Jan 23, 2007 6:23 AM (in response to jbmpuser)To change DB for jbpm 3 use http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnPostgreSQL.
It's works. -
10. Re: change database
jbmpuser Jan 23, 2007 6:37 AM (in response to jbmpuser)but I would like use a sql database, no a postgree database :(
-
11. Re: change database
morpheus_jboss Jan 23, 2007 11:14 AM (in response to jbmpuser)pls read chapter 8 of the jbpm user guide
-
12. Re: change database
estaub Jan 23, 2007 3:08 PM (in response to jbmpuser)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 -
13. Re: change database
jbmpuser Jan 24, 2007 4:00 AM (in response to jbmpuser)Very, very, thanks, expecially to yoyoyoyo!!!
Now I have a sql database to work for it!!!!
Thank very much!!! -
14. Re: change database
fuligj Jan 24, 2007 8:01 AM (in response to jbmpuser)Well. Can anyone help me to change the db in jbpm-jpdl-3.2.Beta1?
Thanks.