0 Replies Latest reply on Aug 6, 2009 6:53 AM by Otto Gyarmati

    Cannot get all process definition keys - named query missing

    Otto Gyarmati Newbie

      === Environment ==============================
      - jBPM Version : JBPM4
      - Database : Oracle Enterprise
      - JDK : java version "1.6.0_10"
      - Container : java version "1.6.0_10"
      - Configuration : basic configuartion
      - Libraries :

      === Process ==================================
      === Environment ==============================
      - jBPM Version : which version of jBPM are you using?
      - Database : which database and which version of that database
      - JDK : which Java version are you using? use 'java -version' to find out
      - Container : which Java version are you using? use 'java -version' to find out
      - Configuration : is your jbpm.cfg.xml only importing files from the jbpm.jar
      lib itself? or did you create a custom config file?
      - Libraries : are you using the exact versions of the libs from inside the jbpm
      distribution of the version that you're using? or did you change some of the libs?

      === Process ==================================
      <?xml version="1.0" encoding="UTF-8"?>

      <task g="134,223,92,52" name="task2" candidate-groups="sales">

      <task g="129,325,92,52" name="task3" candidate-groups="sales">

      === API ===================================
      public List getAllWorkflows() throws Exception {
      Configuration configuration = new Configuration();
      processEngine = configuration.buildProcessEngine();
      return ((ExecutionServiceImpl)processEngine.getExecutionService()).getCommandService().execute(new FindProcessDefinitionKeysCmd());

      === Stacktrace ==============================

      org.hibernate.MappingException: Named query not known: findProcessDefinitionKeys
      at org.hibernate.impl.AbstractSessionImpl.getNamedQuery(AbstractSessionImpl.java:93)
      at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1287)
      at org.jbpm.pvm.internal.hibernate.DbSessionImpl.findProcessDefinitionKeys(DbSessionImpl.java:110)
      at org.jbpm.pvm.internal.cmd.FindProcessDefinitionKeysCmd.execute(FindProcessDefinitionKeysCmd.java:38)
      at org.jbpm.pvm.internal.cmd.FindProcessDefinitionKeysCmd.execute(FindProcessDefinitionKeysCmd.java:33)
      at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
      at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:54)
      at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
      at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
      at hu.docmgmt.jbpm4.ejb.Jbpm4Bean.getAllWorkflows(JbpmUser.java:61)

      === Debug logs ==============================
      past debug logs here

      === Problem description =========================
      I want to get the all deployed processes using the jbpm engine. It looks like there is no named query findProcessDefinitionKeys, which want the hibernate use in DbSessionImpl class .
      Is there an other way to get all processes?