JBoss Community

Re: JBPM's persistence reusing existing connection

created by Pooja Arora in jBPM - View the full discussion

Hi

 

I am trying to integrate JBPM5(5.1.0.Final) with Sybase.

so, I have picked persistence.xml  and copied it in meta-inf directory of my application. now when I try to run below code.

 

            EntityManagerFactory emf = Persistence.createEntityManagerFactory("org.jbpm.persistence.jpa" );

            Environment env = KnowledgeBaseFactory.newEnvironment();

            env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);

            env.set(EnvironmentName.TRANSACTION_MANAGER, TransactionManagerServices.getTransactionManager());   

            ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, null, env);

I got mentioned exception while creating ksession

 

Caused by: java.lang.NullPointerException

    at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:138)

It comes up at below line in SingleSessionCommandService.java

((InternalKnowledgeRuntime) ksession).setId( this.sessionInfo.getId() );

as this.sessionInfo.getId() is returning null.

 

My persistence.xml has below contents

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

<?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/persistence_1_0.xsd

                                 http://java.sun.com/xml/ns/persistence/orm

                                 http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"

    xmlns:orm="http://java.sun.com/xml/ns/persistence/orm" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xmlns="http://java.sun.com/xml/ns/persistence">

 

    <persistence-unit name="org.jbpm.persistence.jpa" transaction-type="RESOURCE_LOCAL">

        <provider>org.hibernate.ejb.HibernatePersistence</provider>

        <!--<jta-data-source>java:/jdbc/testDS1</jta-data-source> mapping-file>META-INF/JBPMorm.xml</mapping-file -->

        <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>

        <class>org.drools.persistence.info.SessionInfo</class>

        <class>org.drools.persistence.info.WorkItemInfo</class>

        <properties>

            <property name="connection.driver_class" value="com.sybase.jdbc2.jdbc.SybDriver" />

            <property name="connection.url" value="<sybase.url>" />

            <property name="hibernate.dialect" value="org.hibernate.dialect.SybaseDialect" />

            <property name="connection.username" value="<username>" />

            <property name="connection.password" value="<password>" />

            <property name="hibernate.max_fetch_depth" value="3" />

            <property name="hibernate.hbm2ddl.auto" value="create" />

            <property name="hibernate.show_sql" value="true" />

        </properties>

    </persistence-unit>

 

</persistence>

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

Please let me know if I am heading in right direction and your suggestions on the same.

 

Cheers

Pooja

Reply to this message by going to Community

Start a new discussion in jBPM at Community