3 Replies Latest reply on Sep 28, 2005 3:40 AM by Ronald van Kuijk

    a begginer Conceptual question!

    Farinaz Ghasemi Newbie

      Dear friends,
      I am a begginer with JBPM , I have some conceptual questions and I'll be so thankful if some one can help me:)

      I can't understand the difference between hypersonic in memory data base and the real database(e.g MySql),must we use both of them for running a java application or a web application?
      for example when we use jbpmSession.getGraphSession().saveProcessDefinition(processDefinition),
      where are the process definition will be saved?on a hypersonic sql data base or in our database?I know the form parameters and process variables are saving in our real database.
      I wrote a web application like WebSale application and
      make a (process project)in eclipse which contains all the needed libraries,
      and wrote the following code in my struts Action class
      :

      static JbpmSessionFactory jbpmSessionFactory =
      JbpmSessionFactory.buildJbpmSessionFactory();
      static
      {
      jbpmSessionFactory.getJbpmSchema().createSchema();
      }
      ProcessDefinition processDefinition=
      ProcessDefinition.parseXmlString("//..the xml defenition...");
      JbpmSession jbpmSession = jbpmSessionFactory.openJbpmSession();
      jbpmSession.beginTransaction();
      jbpmSession.getGraphSession().saveProcessDefinition(processDefinition);
      jbpmSession.commitTransaction();
      jbpmSession.close();


      when I tried to run it following exception has been occured
      java.sql.SQLException: socket creation error
      at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
      at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
      at org.hsqldb.jdbcDriver.connect(Unknown Source)
      at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
      at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
      at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
      at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
      at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
      at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
      at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)
      ...
      1-should I include more extra settings?
      2-Is it a hibernate problem? I'm begginer with hibernate too.
      3-what are the refrences I should study to find the answers?