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

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@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@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&...]