[jboss-user] [jBPM] - Re: JBPM + Oracle integration

[kavinkumar sengottaiyan]

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&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120628/b0b71373/attachment-0001.html