I attempted to this advanced install, since I'm installing on a machine that already has MySQL running.

I changed the database logins per the instructions.

When I attempt to start tomcat and the application, tomcat will start and is accessible, but the wflow-wfweb is not. Tomcat returns a 404 indicating the requested resource is not available.

The tomcat logs indicate that the application does not load due to an error.

The localhost log indicates:

Dec 23, 2010 12:03:10 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'setupSessionFactory' defined in class path resource [KB:commonsApplicationContext.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1336)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:471)

I tried changing the hibernate xml file to explicitly name the dialect. That did not help.

I suspect that tomcat does not have drivers for mysql. i added mysql-connector-java-5.1.14-bin.jar to /lib in tomcat. That still did not help.

What am i missing?

  • No labels

2 Comments

  1. Tiensoon

    Since you are looking at custom installation to just reusing an existing MySQL instance running in your machine, may I suggest this simpler approach?

    1. I guess you are installing on Windows (but correct me if I'm having a wrong guess). Go ahead installing Joget Workflow using the .exe installer in a preferred directory (assuming C:\Joget-v2). Yes, in this case, a copy of MySQL database will be created in the installation directory, but no worry, it doesn't write anything into your registry. You could remove the MySQL folder later when Joget Workflow is working.
    2. Create a database named "sampledb" (without quotation marks) in your existing installation of MySQL: create database sampledb
    3. Import C:\Joget-v2\data\wflowdb-sample.sql to "sampledb". Now, you would already have a database called "sampledb", which is populated with all necessary tables needed for Joget Workflow, as well as a sample process
    4. Open C:\Joget-v2\wflow\datasource-sample.properties with text editor, and change all the database URLs, database user/password accordingly. For example, if your MySQL is running at localhost on port 3306, then change the URLs (5 occurrences) to: jdbc\:mysql\://localhost\:3306/sampledb?characterEncoding\=UTF-8
    5. Now, assuming that your MySQL server is already running, you could start the Joget Workflow's Tomcat by executing C:\Joget-v2\tomcat6-run.bat
    6. When Tomcat is completed started, you should now be able to access Joget Workflow Management Console at http://localhost:8080/wflow-wfweb

    1. Brad benton

      Thank you Tiensoon.

      Simpler is better.

      Yes, installing on Windows.

      I was afraid that the installer might do something bad with the existing MySQL install.

      Followed your instructions and everything is running fine.

      Thanks again.