I have a fresh install of Joget v3. I am unable to start the server. I get

== Starting MySQL from .\mysql-5.0.22-win32 ==
== Starting Tomcat from .\apache-tomcat-6.0.18 ==
Using CATALINA_BASE:   .\apache-tomcat-6.0.18
Using CATALINA_HOME:   .\apache-tomcat-6.0.18
Using CATALINA_TMPDIR: .\apache-tomcat-6.0.18\temp
Using JRE_HOME:        .\jdk1.6.0
...
Feb 13, 2013 7:10:10 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive jw.war
No properties path set - looking for transactions.properties in classpath...
transactions.properties not found - looking for jta.properties in classpath...
Failed to open transactions properties file - using default values
INFO  13 Feb 2013 19:10:22 org.joget.commons.util.SetupManager  - Using base dir
ectory: ./wflow/
INFO  13 Feb 2013 19:10:22 org.joget.commons.util.DynamicDataSource  - datasourc
eName=workflow, url=jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8, us
er=root
ERROR 13 Feb 2013 19:10:23 org.hibernate.util.JDBCExceptionReporter  - Cannot cr
eate PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using
 password: NO))
ERROR 13 Feb 2013 19:10:23 org.springframework.web.context.ContextLoader  - Cont
ext initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'setupSessionFactory' defined in class path resource [commonsApplicationC
ontext.xml]: Invocation of init method failed; nested exception is org.hibernate
.HibernateException: Hibernate Dialect must be explicitly set
== Starting MySQL from .\mysql-5.0.22-win32 ==

== Starting Tomcat from .\apache-tomcat-6.0.18 ==

Using CATALINA_BASE:   .\apache-tomcat-6.0.18

Using CATALINA_HOME:   .\apache-tomcat-6.0.18

Using CATALINA_TMPDIR: .\apache-tomcat-6.0.18\temp

Using JRE_HOME:        .\jdk1.6.0

...

Feb 13, 2013 7:10:10 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive jw.war

No properties path set - looking for transactions.properties in classpath...

transactions.properties not found - looking for jta.properties in classpath...

Failed to open transactions properties file - using default values

INFO  13 Feb 2013 19:10:22 org.joget.commons.util.SetupManager  - Using base dir

ectory: ./wflow/

INFO  13 Feb 2013 19:10:22 org.joget.commons.util.DynamicDataSource  - datasourc

eName=workflow, url=jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8, us

er=root

ERROR 13 Feb 2013 19:10:23 org.hibernate.util.JDBCExceptionReporter  - Cannot cr

eate PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using

 password: NO))

ERROR 13 Feb 2013 19:10:23 org.springframework.web.context.ContextLoader  - Cont

ext initialization failed

org.springframework.beans.factory.BeanCreationException:

...

I found another message in the forum that said the problem is with the hibernate util. Unfortunately, I cannot find that message again. In any case, it said something about connecting the wflow folder to the database. I would have no idea how to do this if that is the fix. 

Could someone please point me in the right direction on how to fix this? I want to use Joget to model business processes, but I am not technical in the sense of configuring databases and servers (I can do a little). 

  • No labels

5 Comments

  1. ERROR 13 Feb 2013 19:10:23 org.hibernate.util.JDBCExceptionReporter  - Cannot cr

    eate PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using

     password: NO))

    Please check your database connection.

    1. CS

      How do I check the database connection? Sorry, but as I said, I am not technical. 

    1. CS

      Thanks, this looks helpful. 

    2. getting page not found error for below link - Advanced Installation for Apache Tomcat and MySQL