2 Replies Latest reply on Mar 26, 2008 6:43 AM by Ronald van Kuijk

    jBPM-3.2.2 in Tomcat-5.5 and MySQL

    Ramesh R Newbie

      Problem in jBPM-3.2.2 in Tomcat-5.5 and MySQL

      Hi

      I have following problem after deployed jbpm-console.war into the Tomcat. While login into the screen ernie/ernie the next page will not be loaded and it displays "Access to the requested resource has been denied" for the URL "http://localhost:8080/jbpm console/sa/processes.jsf". I have configured MySQL as per the instructions and all the required jar files are in the class path.

      hibernate.cfg.xml contains
      ---------------------------------

      org.hibernate.dialect.MySQLInnoDBDialect

      <!-- JDBC connection properties (begin) === -->
      com.mysql.jdbc.Driver
      jdbc:mysql://localhost:3306/jbpm
      root
      root
      <!--==== JDBC connection properties (end) -->

      org.hibernate.cache.HashtableCacheProvider

      <!-- JTA transaction properties (begin) === -->
      org.hibernate.transaction.JDBCTransactionFactory

      and in jbpm-console.xml
      ------------------------------

      <Realm className="org.apache.catalina.realm.JDBCRealm"
      driverName="com.mysql.jdbc.Driver"
      connectionURL="jdbc:mysql://localhost:3306/jbpm"
      connectionName="root"
      connectionPassword="root"
      userTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
      userNameCol="g.TYPE_ = 'security-role' AND m.GROUP_ = g.ID_ AND m.USER_ = u.ID_ AND u.NAME_"
      userCredCol="DISTINCT u.PASSWORD_"
      userRoleTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
      roleNameCol="g.NAME_" />



      I cannt able to proceed further since there is no error in the log file or in the tomcat console...

      Please help me some one...
      Its very urgent..

      Regards
      Ramesh