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