1 Reply Latest reply on Jul 30, 2008 3:17 AM by Sangeetha M

    Not able to connect to Database

    Sangeetha M Newbie

      Hi,

      I want to develop a struts application using JBPM workflow engine.I tried to implement login functionality from struts Action class.

      I want to check the existence of username and password given by user in database. I passed jbpm.cfg.xml as string. Its giving message as "hibernate.properties" not found.

      I gave the datasource name in hibernate.cfg.xml. but its not detecting and connection to database.

      Please correct me if i am wrong somewhere and direct me on the correct path.

      Thanks in Advance.

      Here is my code:

      static JbpmConfiguration jbpmConfiguration = null;
      static {

      jbpmConfiguration = JbpmConfiguration.parseXmlString(
      "<jbpm-configuration>" +

      // A jbpm-context mechanism separates the jbpm core
      // engine from the services that jbpm uses from
      // the environment.

      " <jbpm-context>" +
      " <service name='persistence' " +
      " factory='org.jbpm.persistence.db.DbPersistenceServiceFactory' />" +
      " </jbpm-context>" +

      // Also all the resource files that are used by jbpm are
      // referenced from the jbpm.cfg.xml

      " <string name='resource.hibernate.cfg.xml' " +
      " value='hibernate.cfg.xml' />" +
      " <string name='resource.business.calendar' " +
      " value='org/jbpm/calendar/jbpm.business.calendar.properties' />" +
      " <string name='resource.default.modules' " +
      " value='org/jbpm/graph/def/jbpm.default.modules.properties' />" +
      " <string name='resource.converter' " +
      " value='org/jbpm/db/hibernate/jbpm.converter.properties' />" +
      " <string name='resource.action.types' " +
      " value='org/jbpm/graph/action/action.types.xml' />" +
      " <string name='resource.node.types' " +
      " value='org/jbpm/graph/node/node.types.xml' />" +
      " <string name='resource.varmapping' " +
      " value='org/jbpm/context/exe/jbpm.varmapping.xml' />" +
      "</jbpm-configuration>"
      );
      }

      JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();

      IdentitySession iSession = new IdentitySession(jbpmContext.getSession());

      final Object id = iSession.verify(username, password);
      if (id == null) {
      System.out.println(".............Invalid user name or password...............");
      return mapping.findForward("invalidUser");
      }
      else if(id != null) {
      System.out.println(".............User is valid...............");
      return mapping.findForward("validUser");
      }

      Stacktrace:

      INFO [STDOUT] 14:08:02,890 INFO [Environment] Hibernate 3.2.3
      14:08:02,890 INFO [STDOUT] 14:08:02,890 INFO [Environment] hibernate.propertie
      s not found
      14:08:02,906 INFO [STDOUT] 14:08:02,906 INFO [Environment] Bytecode provider n
      ame : javassist
      14:08:02,921 INFO [STDOUT] 14:08:02,921 INFO [Environment] using JDK 1.4 java.
      sql.Timestamp handling
      14:08:03,281 INFO [STDOUT] 14:08:03,281 INFO [Configuration] configuring from
      resource: hibernate.cfg.xml
      14:08:03,281 INFO [STDOUT] 14:08:03,281 INFO [Configuration] Configuration res
      ource: hibernate.cfg.xml



      hibernate.cfg.xml:

      <?xml version='1.0' encoding='utf-8'?>

      <!DOCTYPE hibernate-configuration PUBLIC
      "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

      <hibernate-configuration>
      <session-factory>

      <!-- hibernate dialect -->
      org.hibernate.dialect.MySQLInnoDBDialect


      <!-- JDBC connection properties (begin)
      org.hsqldb.jdbcDriver

      org.hibernate.cache.HashtableCacheProvider

      <!-- DataSource properties (begin) ===-->
      java:/jpdlDS
      <!--==== DataSource properties (end) -->

      <!-- JTA transaction properties (begin) ===
      org.hibernate.transaction.JTATransactionFactory
      org.hibernate.transaction.JBossTransactionManagerLookup
      ==== JTA transaction properties (end) -->

      <!-- CMT transaction properties (begin) ===
      org.hibernate.transaction.CMTTransactionFactory
      org.hibernate.transaction.JBossTransactionManagerLookup
      ==== CMT transaction properties (end) -->

      <!-- logging properties (begin) === -->
      true
      true
      <!--true
      ==== logging properties (end) -->

      <!-- ############################################ -->
      <!-- # mapping files with external dependencies # -->
      <!-- ############################################ -->

      <!-- following mapping file has a dependendy on -->
      <!-- 'bsh-{version}.jar'. -->
      <!-- uncomment this if you don't have bsh on your -->
      <!-- classpath. you won't be able to use the -->
      <!-- script element in process definition files -->


      <!-- following mapping files have a dependendy on -->
      <!-- 'jbpm-identity.jar', mapping files -->
      <!-- of the pluggable jbpm identity component. -->
      <!-- Uncomment the following 3 lines if you -->
      <!-- want to use the jBPM identity mgmgt -->
      <!-- component. -->
      <!-- identity mappings (begin) -->



      <!-- identity mappings (end) -->

      <!-- following mapping files have a dependendy on -->
      <!-- the JCR API -->
      <!-- jcr mappings (begin) ===

      ==== jcr mappings (end) -->


      <!-- ###################### -->
      <!-- # jbpm mapping files # -->
      <!-- ###################### -->

      <!-- hql queries and type defs -->


      <!-- graph.action mapping files -->


      <!-- graph.def mapping files -->









      <!-- graph.node mapping files -->










      <!-- context.def mapping files -->



      <!-- taskmgmt.def mapping files -->





      <!-- module.def mapping files -->


      <!-- bytes mapping files -->


      <!-- file.def mapping files -->


      <!-- scheduler.def mapping files -->



      <!-- graph.exe mapping files -->





      <!-- module.exe mapping files -->


      <!-- context.exe mapping files -->












      <!-- job mapping files -->





      <!-- taskmgmt.exe mapping files -->





      <!-- logging mapping files -->































      </session-factory>
      </hibernate-configuration>