8:31 a.m.
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&...]
8:53 a.m.
Mauricio Salatino [http://community.jboss.org/people/salaboy21] created the discussion
"Re: jBPM 5.1 with SQL Server"
To view the discussion, visit: http://community.jboss.org/message/627503#627503
--------------------------------------------------------------
did you start the transaction provider? take a look at the docs.. and you will see that we
create a PoolingDataSource using bitronix and then we get the transaction manager from the
context instead of instantiating a new one.
Cheers
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/627503#627503]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
9 a.m.
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/627509#627509
--------------------------------------------------------------
Thanks for the feedback,
On my second post (second connection scenario), I can't get past the
PoolingDataSource.init due to the exception presented above, so I can never get to the
point of calling a TransactionManagerServices.getTransactionManager (If this is what you
are refering to.)
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/627509#627509]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
9:54 a.m.
Marco Rietveld [http://community.jboss.org/people/marco.rietveld] created the discussion
"Re: jBPM 5.1 with SQL Server"
To view the discussion, visit: http://community.jboss.org/message/629585#629585
--------------------------------------------------------------
Dominique,
You're almost there!
See
https://github.com/droolsjbpm/drools/blob/master/drools-persistence-jpa/s...
here for the all of the code from the following segment, but the following should work for
SQL server:
PoolingDataSource pds = new PoolingDataSource();
// The name must match what's in the persistence.xml!
pds.setUniqueName("jdbc/testDS1");
//
pds.setClassName("com.microsoft.sqlserver.jdbc.SQLServerXADataSource");
// doesn't really matter
pds.setMaxPoolSize(3);
pds.getDriverProperties().put("user", "thisIsMyUsername");
pds.getDriverProperties().put("password", "thisIsMyPassword");
for (String propertyName : new String[] { "serverName", "portNumber",
"databaseName" })
pds.getDriverProperties().put("serverName",
"The.Server.Name.as.in.DNS.Name");
pds.getDriverProperties().put("portNumber", "portNumber);
pds.getDriverProperties().put("databaseName", "NameOfTheDatabase");
pds.getDriverProperties().put("URL", "jdbcUrl");
pds.getDriverProperties().put("selectMethod", "cursor");
pds.getDriverProperties().put("InstanceName",
"ThisIsTheInstanceNameOfYourDatabase-sortOfLikeTheDatabaseName");
pds.init();
EntityManagerFactory emf =
Persistence.createEntityManagerFactory("persistenceUnitName");
Also, the jta-data-source element should +not+ be commented out in your persistence.xml,
obviously.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/629585#629585]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4839
days inactive
4849
days old
3 comments
3 participants
participants (3)
-
Dominique Paquin -
Marco Rietveld
-
Mauricio Salatino