JBPM 2.0 with SQL Server

[nadim_sd]

I'm trying to run JBPM 2.0 with an sql server database. I followed the steps descriped in the following wiki document:
http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnMSSQLServer

But still, when I try to deploy a process using the ant tool (ant deploy.process.archives) I get the following error:
net.sf.hibernate.HibernateException: JDBC Driver class not found: net.sourceforge.jtds.jdbc.Driver

althoug I have the the jtds-1.1.jar under ...\jbpm-2.0\lib\mssql\, should I put it somewhere else also?

How can I fix the problem???

[nadim_sd]

can anyone help me with that?

[nadim_sd]

Finally I have managed to run jbpm with an sql server database, and I deployed a process.

However I still have the following problem:

In the generated sql schema, the tables: JBPM_TOKEN, JBPM_PROCESSINSTANCE each has 2 columns of type timestamp and SQL server won't allow to create a table with 2 timestamp:
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]A table can only have one timestamp column.

does anyone have a solution to this problem?
Thank you...

[danielywoo]

I faced the similiar problem, I put the JDBC driver into lib/mysql but also get a ClassNotFoundException. How did you resolve this problem? Really thanks!!!

Daniel

[nadim_sd]

I tried to put the driver in many places but it finally worked when I added it under: jbpm-2.0\lib\commons

Good Luck