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"?>



      <!-- connection pool parameters -->

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

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

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

      <!-- ensure the datasource is not initialized before the database itself -->


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

      <application-policy name = "jbpm">

      <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
      <module-option name="dsJndiName">java:/JbpmDS</module-option>
      <module-option name="principalsQuery">
      <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_=?


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