日期:2014-05-17  浏览次数:20704 次

jbpm+ssh2集成问题
2012-03-15 12:04:04 [main] - [INFO] Using DataSource [org.apache.commons.dbcp.BasicDataSource@b3f01d] of Hibernate SessionFactory for HibernateTransactionManager
Hibernate: select top 1 propertyim0_.KEY_ as KEY1_17_, propertyim0_.VERSION_ as VERSION2_17_, propertyim0_.VALUE_ as VALUE3_17_ from JBPM4_PROPERTY propertyim0_
2012-03-15 12:04:04 [main] - [WARN] SQL Error: 208, SQLState: S0002
2012-03-15 12:04:04 [main] - [ERROR] 对象名 'JBPM4_PROPERTY' 无效。
Hibernate: select top 1 executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_
2012-03-15 12:04:04 [main] - [WARN] SQL Error: 208, SQLState: S0002
2012-03-15 12:04:04 [main] - [ERROR] 对象名 'JBPM4_EXECUTION' 无效。
2012-03-15 12:04:04 [main] - [INFO] exception while executing command org.jbpm.pvm.internal.cmd.CheckDbCmd@bb5def
org.jbpm.api.JbpmException: no jBPM DB schema: no JBPM4_EXECUTION table. Run the create.jbpm.schema target first in the install tool. at org.jbpm.pvm.internal.cmd.CheckDbCmd.execute(CheckDbCmd.java:50)
at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at org.jbpm.pvm.internal.processengine.ProcessEngineImpl.checkDb(ProcessEngineImpl.java:152)
at org.jbpm.pvm.internal.processengine.SpringProcessEngine.create(SpringProcessEngine.java:70)
at org.jbpm.pvm.internal.cfg.ConfigurationImpl.buildProcessEngine(ConfigurationImpl.java:90)
at org.jbpm.pvm.internal.processengine.SpringHelper.createProcessEngine(SpringHelper.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)



红色部分是错误, 请教大侠。 

数据库是sql server05

------解决方案--------------------
没有生成JBPM相关表吧!
------解决方案--------------------
你集成的时候有没有 jbpm.hibernate.cfg.xml 这个文件 然后看看里面的数据库配置是否配置正确
jbpm会在配置的库中创建表
------解决方案--------------------
jbpm.hibernate.cfg.xml 中没有表的配置