0 Replies Latest reply on Jun 2, 2006 11:43 AM by Sam ja

    Error while finding latest Process Defination.

    Sam ja Newbie

      Hi,
      I am using jbpm-starters-kit-3.1.1 to run the jboss server and Eclipse is 3.1.2. Database is defualt database.

      I created a new jbpm procss project in eclipse and deployed it as per instructions in JbpmGettingStarted guide.
      Now I an trying to start the process as follows:..

      JbpmContext jbpmContext = JbpmConfiguration.getInstance().createJbpmContext();
      processDefinition = jbpmContext.getGraphSession().findLatestProcessDefinition("simple");

      I am getting follwing error :--
      JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
      15:56:19,433 [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]
      15:56:19,664 [main] ERROR GraphSession : org.hibernate.exception.SQLGrammarException: could not execute query
      org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

      Pls tell me what could be going wrong and how to resolve this.
      Thanks in advance.