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

santayan do-not-reply at jboss.com
Mon Dec 8 23:17:31 EST 2008

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

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

More information about the jboss-user mailing list