1 Reply Latest reply on Dec 9, 2008 2:17 PM by Mauricio Salatino

    Problem facing configuraing JBPM with SQL Server

    Santayan Biswas Newbie

      Anyone plz help me to configure JBPM with SQL Server. It is very helpful if anyone can share a document regarding that. I have tried a lot to solve the problem. But whenever I loged in it automatically go to Hypersonic DB and SQLServer is not getting used. Plz help. Its very urgent.

      I have used JBOSS4.2.3 and jbpm-installer-3.3.0.GA.

      My jbpm-mssqldb-ds.xml looks like...........

      <?xml version="1.0" encoding="UTF-8"?>


      <local-tx-datasource>
      <jndi-name>JbpmDS</jndi-name>

      <connection-url>jdbc:jtds:sqlserver://inkolsaljnj01:1433/FRAMEWORK</connection-url>
      <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
      <user-name></user-name>


      <!-- connection pool parameters -->
      <min-pool-size>1</min-pool-size>
      <max-pool-size>5</max-pool-size>

      <!-- disable idle connection removal, hsqldb does not reap threads on closed connections -->
      <idle-timeout-minutes>0</idle-timeout-minutes>
      <!-- check all statements are closed when the connection is returned to the pool -->
      <track-statements />
      <!-- hsqldb benefits from prepared statement caching -->
      <prepared-statement-cache-size>32</prepared-statement-cache-size>

      <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml -->

      <type-mapping>MS SQLSERVER2000</type-mapping>


      <!-- ensure the datasource is not initialized before the database itself -->
      <!--jboss:service=Hypersonic,database=jbpmDB-->
      </local-tx-datasource>

      <!--
      jbpmDB
      true
      -->



      I have also added the below in login-config.xml

      <application-policy name = "jbpm">

      <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
      flag="required">
      <module-option name="dsJndiName">java:/JbpmDS</module-option>
      <module-option name="principalsQuery">
      SELECT PASSWORD_ FROM itrinno.JBPM_ID_USER WHERE NAME_=?
      </module-option>
      <module-option name="rolesQuery">
      SELECT g.NAME_ ,'Roles'
      FROM itrinno.JBPM_ID_USER u,
      itrinno.JBPM_ID_MEMBERSHIP m,
      itrinno.JBPM_ID_GROUP g
      WHERE g.TYPE_='security-role'
      AND m.GROUP_ = g.ID_
      AND m.USER_ = u.ID_
      AND u.NAME_=?
      </module-option>
      </login-module>

      </application-policy>


      Should I need to change anything in hibernate config files...or any other files...plz advise...