[jbpm-users] [JBoss jBPM] - Problem facing configuraing JBPM with SQL Server

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...