[jboss-user] [JBoss jBPM] - Re: jbpm-db readme followed to point 10 - then errors on ant

[cdart_rrr]

hi,
yes I'm doing similar to you, same problems. But I've got one step further on. With your problem it's getting class not found for com/mchange/v2/c3p0/PoolConfig, so I located this on the www (as c3p0-0.9.0.jar - which wants to then go in ...\jbpm\lib\jboss). 

So then on to the next problem

  | [junit] 11:22:51,022 [main] DEBUG BasicResourcePool : trace com.mchange.v2.resourcepool.BasicResourcePool at 3b8b49 [managed: 0, unused: 0, excluded: 0]
  | [junit] 11:22:51,444 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] DEBUG BasicResourcePool : trace com.mchange.v2.resourcepool.BasicResourcePool at 3b8b49 [managed: 1, unused: 1, excluded: 0]
  | [junit] 11:22:51,444 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG BasicResourcePool : trace com.mchange.v2.resourcepool.BasicResourcePool at 3b8b49 [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection at 3c9217)
  | [junit] 11:22:51,460 [main] DEBUG BasicResourcePool : trace com.mchange.v2.resourcepool.BasicResourcePool at 3b8b49 [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection at 3c9217)
  | [junit] alter table JBPM_ACTION drop constraint FK_ACTION_EVENT
  | [junit] 11:22:51,491 [main] DEBUG NewPooledConnection : com.mchange.v2.c3p0.impl.NewPooledConnection at 3c9217 handling a throwable.
  | [junit] java.sql.SQLException: Table not found: JBPM_ACTION in statement [alter table JBPM_ACTION]
  | [junit]     at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
  | 
So this looks like it can't find the table on the db to drop the constraint. I've created the db (jbpmtest) on mssql and checked that I can indeed create, drop etc the tables with the scripts. I've updated hibernate.properties for my db, user, pw etc. So I guess it's not connecting to the right db? ALthough I may have expected an error to say db (name) not present rather than table not found.

So just the last bit to get the test to connect. I should think from the test failure (above) that it's just the final connection to the right db...

Any ideas?

Brgds...

rr

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4006749#4006749

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4006749