eric jiang
2012-09-18 09:56:56 UTC
eric jiang [https://community.jboss.org/people/kanawalo] created the discussion
"Re: how to export jbpm database tables ?"
To view the discussion, visit: https://community.jboss.org/message/760124#760124
--------------------------------------------------------------
I got it!!!
this is the answer:
these files need to be modified:
* db/persistence.xml
    <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
* task-service/resources/META-INF/persistence.xml
    <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
     <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/>
     <property name="hibernate.connection.url" value="jdbc:oracle:thin:@localhost:1521:test" />
* db/jBPM-ds.xml * If you're using the JBoss AS 5 server
this is on JBPM site, I also changed it.
    <connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url>
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
   <user-name>scott</user-name>
   <password>scott</password>
* standalone.xml * If you're using the JBoss AS 7 server
<datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
                   <connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url>
                   <driver>oracle</driver>
                   <pool>
                       <min-pool-size>1</min-pool-size>
                       <max-pool-size>4</max-pool-size>
                       <prefill>false</prefill>
                       <use-strict-min>false</use-strict-min>
                       <flush-strategy>FailingConnectionOnly</flush-strategy>
                   </pool>
                   <security>
                      <user-name>scott</user-name>
                      <password>scott</password>
                   </security>
                   <validation>
                      <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
                      <validate-on-match>false</validate-on-match>
                      <background-validation>false</background-validation>
                   </validation>
               </datasource>
               <drivers>
                   <driver name="oracle" module="com.oracle">
                       <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                   </driver>
               </drivers>
           </datasources>
* db/driver_jar_moudle.xml
    <resource-root path="ojdbc14.jar"/>
after that, pls run
1. ant install.demo.db
2. ant start.demo.db
:^0
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/760124#760124]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
"Re: how to export jbpm database tables ?"
To view the discussion, visit: https://community.jboss.org/message/760124#760124
--------------------------------------------------------------
I got it!!!
this is the answer:
these files need to be modified:
* db/persistence.xml
    <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
* task-service/resources/META-INF/persistence.xml
    <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
     <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/>
     <property name="hibernate.connection.url" value="jdbc:oracle:thin:@localhost:1521:test" />
* db/jBPM-ds.xml * If you're using the JBoss AS 5 server
this is on JBPM site, I also changed it.
    <connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url>
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
   <user-name>scott</user-name>
   <password>scott</password>
* standalone.xml * If you're using the JBoss AS 7 server
<datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
                   <connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url>
                   <driver>oracle</driver>
                   <pool>
                       <min-pool-size>1</min-pool-size>
                       <max-pool-size>4</max-pool-size>
                       <prefill>false</prefill>
                       <use-strict-min>false</use-strict-min>
                       <flush-strategy>FailingConnectionOnly</flush-strategy>
                   </pool>
                   <security>
                      <user-name>scott</user-name>
                      <password>scott</password>
                   </security>
                   <validation>
                      <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
                      <validate-on-match>false</validate-on-match>
                      <background-validation>false</background-validation>
                   </validation>
               </datasource>
               <drivers>
                   <driver name="oracle" module="com.oracle">
                       <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                   </driver>
               </drivers>
           </datasources>
* db/driver_jar_moudle.xml
    <resource-root path="ojdbc14.jar"/>
after that, pls run
1. ant install.demo.db
2. ant start.demo.db
:^0
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/760124#760124]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]