[jboss-user] [jBPM] - Re: Oracle Integration with JBPM5

[vishal sharma]

vishal sharma [http://community.jboss.org/people/2sharma.vishal] created the discussion

"Re: Oracle Integration with JBPM5"

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

--------------------------------------------------------------
I have tried to configure all the files according to the link that <ou have mentioned but it soesn't work.
I am attaching my all the configuration files. I hope that you will be able to help me afterwards.

hibernate.cfg.xml
#################

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        " http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">


<hibernate-configuration>


    <session-factory>


        <!-- Database connection settings 
        <property name="connection.driver_class">org.h2.Driver</property>
        <property name="connection.url">jdbc:h2:tcp://localhost/~/test</property>
        property name="connection.url">jdbc:h2:file:/NotBackedUp/data/mydb</property
        <property name="connection.username">sa</property>
        <property name="connection.password"></property>

        -->




        <!-- Database connection settings -->
        <property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:8087:test</property>
        <property name="connection.username">SYSTEM</property>
        <property name="connection.password">p at zzw0rd</property>
        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>



        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>


        <!-- SQL dialect 
        <property name="dialect">org.hibernate.dialect.H2Dialect</property>-->


        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>


        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>


        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">false</property>


        <!-- Drop and re-create the database schema on startup? -->
        <property name="hbm2ddl.auto">create</property>


        <mapping resource="AuditLog.hbm.xml"/>


    </session-factory>


</hibernate-configuration>



persistance.xml
########################

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<persistence version="1.0"
             xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence
                                  http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
                                  http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm 
                                  http://java.sun.com/xml/ns/persistence/orm_1_0.xsd http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
             xmlns:orm=" http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm"
             xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance"
             xmlns=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence">


  <persistence-unit name="org.drools.persistence.jpa" transaction-type="JTA">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <jta-data-source>java:jdbc/testDS1</jta-data-source>        
    <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
    <class>org.drools.persistence.info.SessionInfo</class>
    <class>org.drools.persistence.info.WorkItemInfo</class>
    <properties>
      <property name="hibernate.dialect" value="org.hibernate.dialect.10gDialect"/>                  
      <property name="hibernate.max_fetch_depth" value="3"/>
      <property name="hibernate.hbm2ddl.auto" value="create" />
      <property name="hibernate.show_sql" value="true" /> 
      <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
    </properties>        
  </persistence-unit>

</persistence>


testDS1-ds.xml
####################

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/testDS1</jndi-name>
    <connection-url>jdbc:oracle:thin:@localhost:8087:test</connection-url>
    <!--connection-url>jdbc:h2:mem:mydb</connection-url-->
    <driver-class>org.h2.jdbcx.JdbcDataSource</driver-class>
    <user-name>SYSTEM</user-name>
    <password>p at zzw0rd</password>
  </local-tx-datasource>
</datasources>
--------------------------------------------------------------

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

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/20110519/27e9f5b1/attachment-0001.html