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]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
