0 Replies Latest reply on Jan 11, 2006 8:43 AM by Nakul Rajurkar

    Maximum number of preocesses reached in Oracle while using j

    Nakul Rajurkar Newbie

      Hi,

      After running my jBPM 3.0 code for couple of times. I get
      "ORA-00020: maximum number of processes (160) exceeded".

      My jBPM code looks like this -

      static JbpmSessionFactory jbpmSessionFactory = JbpmSessionFactory.buildJbpmSessionFactory();

      public void addTask() throws Exception
      {
      JbpmSession jbpmSession = null;
      try
      {
      jbpmSession = jbpmSessionFactory.openJbpmSession();
      jbpmSession.beginTransaction();

      .......................
      jbpmSession.commitTransaction();
      }
      catch (RuntimeException runtimeException)
      {
      jbpmSession.rollbackTransaction();
      throw new Exception(runtimeException);
      }
      finally
      {
      if(jbpmSession!=null)
      {
      jbpmSession.close();
      }
      }
      }

      Does anyone have any idea what may be causing problem here? Or is there any possiblity that the connections dont get closed in some standard pre delivered code?

      Nakul