Before I try to develop a custom appplication for deploying and creating a new process instance, do i need to configure hibernate.config.xml and jbpm.config.xml. I want to use the hsql db only. I tried to execute a code parsing the process definition and deploying it. I got error while deploying it. It shows sqlgrammarexception.
17:41:29,918 [main] DEBUG DbPersistenceService : beginning hibernate transaction
17:41:30,012 [main] WARN JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
17:41:30,012 [main] ERROR JDBCExceptionReporter : Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
org.hibernate.exception.SQLGrammarException: could not execute query
could anyone help me in solving this problem.
Thanks in advance.
Table not found in statement
make sure your config points to the right db or if it points to the right db, make sure the tables are created