kavinkumar sengottaiyan [
https://community.jboss.org/people/kavinks] created the
discussion
"Re: JBPM + Oracle integration"
To view the discussion, visit:
https://community.jboss.org/message/744851#744851
--------------------------------------------------------------
implemented JBPM with oracle DB. The sample JBPM working fine now.
1. Modified the persistance.xml like below.
<persistence-unit name="org.jbpm.persistence.jpa"
transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<mapping-file>META-INF/JBPMorm.xml</mapping-file>
<class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.info.WorkItemInfo</class>
<class>org.drools.persistence.info.SessionInfo</class>
<properties>
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@localhost:1521:test"/>
<property name="hibernate.connection.driver_class"
value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.username" value=""/>
<property name="hibernate.connection.password" value=""/>
<property name="hibernate.dialect"
value="org.hibernate.dialect.OracleDialect"/>
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="create" />
<property name="hibernate.show_sql" value="false" />
<property name="hibernate.connection.autocommit" value="true"
/>
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.BTMTransactionManagerLookup" />
</properties>
</persistence-unit>
Thanks,
Kavin
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/744851#744851]
Start a new discussion in jBPM at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]