I try to run jBPM using a SQL Server database
So I
- placed an mssql-ds.xml containing the correct provider and data source to the deploy directory
- replaced the deploy\jms\hsqldb-jdbc2-service.xml and deploy\jms\hsqldb-jdbc-state-service.xml
- corrected the conf\login-config.xml, conf\standardjaws.xml, conf\standardjbosscmp-jdbc.xml
- corrected the deploy\ejb-deployer.xml and deploy\jbpm.sar\META-INF\jboss-service.xml
- placed the jtds-1.2.jar to the lib directory
Upon starting JBoss AS the following exception is thrown:
WARN [ServiceController] Problem starting service jboss.ejb:persistencePolicy=database,service=EJBTimerService
java.lang.IllegalStateException: Cannot find datasource meta data: jboss.jdbc:datasource=MSSQLDS,service=metadata
at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.init(GeneralPurposeDatabasePersistencePlugin.java:81)
In addition JBoss tells me about incomplete deployment:
ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- MBeans waiting for other MBeans ---
ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
State: FAILED
Reason: java.lang.IllegalStateException: Cannot find datasource meta data: jboss.jdbc:datasource=MSSQLDS,service=metadata
I Depend On:
jboss.jca:name=MSSQLDS,service=DataSourceBinding
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
State: FAILED
Reason: java.lang.IllegalStateException: Cannot find datasource meta data: jboss.jdbc:datasource=MSSQLDS,service=metadata
I Depend On:
jboss.jca:name=MSSQLDS,service=DataSourceBinding
What's wrong here?
Since I wasted days with this problems and I need to know if jBPM is any good for a workflow solution I urgently need to solve this.
j2sdk1.4.2
jbpm-3.1-beta2
SQLS 2000
Forgot the following tag in the DS-file (mssql-ds.xml):
<type-mapping>MS SQLSERVER</type-mapping>
With this tag it works fine.