[jboss-user] [jBPM] - Re: jBPM 5.1 with SQL Server

[Dominique Paquin]

Dominique Paquin [http://community.jboss.org/people/paqman] created the discussion

"Re: jBPM 5.1 with SQL Server"

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

--------------------------------------------------------------
While waiting for feedback on the above, I decided to try approach number 2

It will use this persistence.xml file (contrary to the above post, I uncommented the node "jta-data-source" ):
<?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.jbpm.persistence.jpa" transaction-type="JTA">


    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <jta-data-source>jdbc/processInstanceDS</jta-data-source>
    <class>org.drools.persistence.info.SessionInfo</class>
    <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
    <class>org.drools.persistence.info.WorkItemInfo</class>


    <properties>
      <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>
      <property name="hibernate.max_fetch_depth" value="3"/>
      <property name="hibernate.hbm2ddl.auto" value="update"/>
      <property name="hibernate.show_sql" value="true"/>
      <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.BTMTransactionManagerLookup"/>
    </properties>


  </persistence-unit>


</persistence>

I try to initiate the database connection like proposed in the jBPM documentation:

        PoolingDataSource ds = new PoolingDataSource();
        ds.setUniqueName("jdbc/processInstanceDS");
        ds.setClassName("net.sourceforge.jtds.jdbc.Driver");
        ds.setMaxPoolSize(3);
        ds.setAllowLocalTransactions(true);
        ds.getDriverProperties().setProperty("user", "myUser");
        ds.getDriverProperties().setProperty("password", "myPassword");
        ds.getDriverProperties().put("URL", "jdbc:jtds:sqlserver://192.168.117.129:1433;databaseName=myDatabase");


        ds.init();
But when I start everything, the above code crashes with:

        ...
        Caused by: bitronix.tm.utils.PropertyException: no writeable property 'URL' in class 'net.sourceforge.jtds.jdbc.Driver'
        at bitronix.tm.utils.PropertyUtils.getSetter(PropertyUtils.java:318)
        at bitronix.tm.utils.PropertyUtils.setDirectProperty(PropertyUtils.java:217)
        at bitronix.tm.utils.PropertyUtils.setProperty(PropertyUtils.java:83)
        at bitronix.tm.resource.common.XAPool.createXAFactory(XAPool.java:314)
        at bitronix.tm.resource.common.XAPool.<init>(XAPool.java:63)
        at bitronix.tm.resource.jdbc.PoolingDataSource.buildXAPool(PoolingDataSource.java:85)
        at bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:72)
        ... 58 more

I looked this up on the net for a while and found that I could defin each parts of the URL in separate components like this (Though I have no clue as to how the connection will be initiaterd since the server type is not provided):

        ...
        ds.getDriverProperties().setProperty("serverName", "192.168.117.129");
        ds.getDriverProperties().setProperty("portNumber", "1433");
        ds.getDriverProperties().setProperty("databaseName", "racm_identity_data");
In anycase, this also crashes with:

        Caused by: bitronix.tm.utils.PropertyException: no writeable property 'user' in class 'net.sourceforge.jtds.jdbc.Driver'
        at bitronix.tm.utils.PropertyUtils.getSetter(PropertyUtils.java:318)
        at bitronix.tm.utils.PropertyUtils.setDirectProperty(PropertyUtils.java:217)
        at bitronix.tm.utils.PropertyUtils.setProperty(PropertyUtils.java:83)
        at bitronix.tm.resource.common.XAPool.createXAFactory(XAPool.java:314)
        at bitronix.tm.resource.common.XAPool.<init>(XAPool.java:63)
        at bitronix.tm.resource.jdbc.PoolingDataSource.buildXAPool(PoolingDataSource.java:85)
        at bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:72)
        ... 58 more

So with one technique or the other, I always get countered by some obscure problems time after time
--------------------------------------------------------------

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

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/20110920/8a2de6ef/attachment.html