[jboss-user] [jBPM] - Re: JBPM5 - How can I change the database?

[Brian Lavender]

Brian Lavender [http://community.jboss.org/people/brieweb] created the discussion

"Re: JBPM5 - How can I change the database?"

To view the discussion, visit: http://community.jboss.org/message/626965#626965

--------------------------------------------------------------
Try modifying the persistence.xml file which is stored in the db folder and add modify the properties so that it matches the Oracle database.

<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
    <property name="hibernate.connection.password">mypassword</property>
    <property name="hibernate.connection.url">jdbc:Oracle:thin:@192.168.1.1:1521/mydb</property>
    <property name="hibernate.connection.username">my_user</property>
    <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>

Then, you will need to drop the Oracle +ojdbc6.jar+ jdbc driver into the db/driver folder. I believe that will do it.

brian
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/626965#626965]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110916/94498fee/attachment.html