MS SqlServer Configuration for JBPM 6.0

[Tim McClure]

Below is my SQL Server configuration for JBPM 6.1:

<datasource jta="true" jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" use-java-context="true" use-ccm="true">

  <connection-url>jdbc:jtds:sqlserver://localhost:1433/jbpm;instance=SQLEXPRESS;user=sa;password=Miami1Heat</connection-url>

  <driver>JTDS</driver>

  <pool>

    <min-pool-size>1</min-pool-size>

    <max-pool-size>4</max-pool-size>

    <prefill>false</prefill>

    <use-strict-min>false</use-strict-min>

    <flush-strategy>FailingConnectionOnly</flush-strategy>

  </pool>

  <security>

    <user-name>root</user-name>

    <password>Miami1Heat</password>

  </security>

  <validation>

    <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

    <validate-on-match>false</validate-on-match>

    <background-validation>false</background-validation>

  </validation>

</datasource>

<drivers>

  <driver name="mysql" module="com.mysql">

    <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

  </driver>

  <driver name="JTDS" module="net.sourceforge.jtds">

    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

  </driver>

</drivers>  

I get the following error:

JBAS014775:    New missing/unsatisfied dependencies:

      service jboss.jdbc-driver.JTDS (missing) dependents: [service jboss.data-source.java:jboss/datasources/jbpmDS] 

Any ideas?

Thanks,

Tim

[Kris Verlaenen]

It can't find / access module net.sourceforge.jtds or class net.sourceforge.jtds.Driver?

Kris

--
You received this message because you are subscribed to the Google Groups "jBPM Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-usage+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-usage/415271b5-49c2-4e93-90b9-c4ac2dae2572%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[SATISH POLASI]

Hi,

You need to create a directory structure under wildfly/module/net/sourceforge/jds/mail and place the driver and the module.xml file to recognize the dependency.

Thanks,

Satish.