1 Reply Latest reply on Apr 20, 2006 11:10 AM by Ronald van Kuijk

    Data base configuration

    pganesh81 Newbie

      Hi all,
      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.

      Ganesh