[jboss-user] [JBoss jBPM] - Problem facing configuraing JBPM with SQL Server

[santayan]

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...

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4195203#4195203

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4195203