Hi
I tried changing some settings in the system setup page, i changed the Profile from sample to default. upon saving i am not able to do anything.. joget does not work.
Following is the error:
== 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
14-Sep-2011 14:03:56 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in produ
ction environments was not found on the java.library.path: C:\Joget-v2\jdk1.6.0\bin;.;C:\W
indows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Python25\;C:\Program Files\Common Fi
les\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;
C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Google\Google Apps Sync\;C:\P
rogram Files\Google\Google Apps Migration\;C:\Program Files\Windows Live\Shared;C:\Users\N
ikhil\Dropbox\Google\google_appengine\
14-Sep-2011 14:03:56 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
14-Sep-2011 14:03:56 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 315 ms
14-Sep-2011 14:03:56 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
14-Sep-2011 14:03:56 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
INFO 14 Sep 2011 14:04:00 org.joget.commons.util.SetupManager - Using base directory: ./
wflow/
INFO 14 Sep 2011 14:04:00 org.joget.commons.util.DynamicDataSource - datasourceName=work
flow, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
ERROR 14 Sep 2011 14:04:00 org.hibernate.util.JDBCExceptionReporter - Cannot create Poola
bleConnectionFactory (Unknown database 'wflowdb')
ERROR 14 Sep 2011 14:04:00 org.springframework.web.context.ContextLoader - Context initia
lization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'se
tupSessionFactory' defined in class path resource [commonsApplicationContext.xml]: Invocat
ion of init method failed; nested exception is org.hibernate.HibernateException: Hibernate
Dialect must be explicitly set
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in
itializeBean(AbstractAutowireCapableBeanFactory.java:1336)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.do
CreateBean(AbstractAutowireCapableBeanFactory.java:471)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.
run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cr
eateBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstr
actBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingl
eton(DefaultSingletonBeanRegistry.java:220)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstrac
tBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB
eanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB
eanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstant
iateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactor
yInitialization(AbstractApplicationContext.java:729)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstract
ApplicationContext.java:381)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Conte
xtLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Context
Loader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Contex
tLoaderListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:384
3)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j
ava:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
va:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2090)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2086)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1311)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(Lo
calSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(
LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSe
t(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in
vokeInitMethods(AbstractAutowireCapableBeanFactory.java:1367)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in
itializeBean(AbstractAutowireCapableBeanFactory.java:1333)
... 39 more
14-Sep-2011 14:04:00 org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
14-Sep-2011 14:04:00 org.apache.catalina.core.StandardContext start
SEVERE: Context [/wflow-wfweb] startup failed due to previous errors
14-Sep-2011 14:04:00 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
14-Sep-2011 14:04:00 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
14-Sep-2011 14:04:00 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
14-Sep-2011 14:04:00 org.apache.catalina.startup.Catalina start
INFO: Server startup in 4560 ms
== 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
14-Sep-2011 14:03:56 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in produ
ction environments was not found on the java.library.path: C:\Joget-v2\jdk1.6.0\bin;.;C:\W
indows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Python25\;C:\Program Files\Common Fi
les\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;
C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Google\Google Apps Sync\;C:\P
rogram Files\Google\Google Apps Migration\;C:\Program Files\Windows Live\Shared;C:\Users\N
ikhil\Dropbox\Google\google_appengine\
14-Sep-2011 14:03:56 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
14-Sep-2011 14:03:56 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 315 ms
14-Sep-2011 14:03:56 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
14-Sep-2011 14:03:56 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
INFO 14 Sep 2011 14:04:00 org.joget.commons.util.SetupManager - Using base directory: ./
wflow/
INFO 14 Sep 2011 14:04:00 org.joget.commons.util.DynamicDataSource - datasourceName=work
flow, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
ERROR 14 Sep 2011 14:04:00 org.hibernate.util.JDBCExceptionReporter - Cannot create Poola
bleConnectionFactory (Unknown database 'wflowdb')
ERROR 14 Sep 2011 14:04:00 org.springframework.web.context.ContextLoader - Context initia
lization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'se
tupSessionFactory' defined in class path resource [commonsApplicationContext.xml]: Invocat
ion of init method failed; nested exception is org.hibernate.HibernateException: Hibernate
Dialect must be explicitly set
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in
itializeBean(AbstractAutowireCapableBeanFactory.java:1336)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.do
CreateBean(AbstractAutowireCapableBeanFactory.java:471)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.
run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cr
eateBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstr
actBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingl
eton(DefaultSingletonBeanRegistry.java:220)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstrac
tBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB
eanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractB
eanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstant
iateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactor
yInitialization(AbstractApplicationContext.java:729)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstract
ApplicationContext.java:381)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Conte
xtLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Context
Loader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Contex
tLoaderListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:384
3)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j
ava:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
va:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2090)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2086)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1311)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(Lo
calSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(
LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSe
t(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in
vokeInitMethods(AbstractAutowireCapableBeanFactory.java:1367)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.in
itializeBean(AbstractAutowireCapableBeanFactory.java:1333)
... 39 more
14-Sep-2011 14:04:00 org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
14-Sep-2011 14:04:00 org.apache.catalina.core.StandardContext start
SEVERE: Context [/wflow-wfweb] startup failed due to previous errors
14-Sep-2011 14:04:00 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
14-Sep-2011 14:04:00 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
14-Sep-2011 14:04:00 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
14-Sep-2011 14:04:00 org.apache.catalina.startup.Catalina start
INFO: Server startup in 4560 ms
5 Comments
Nikhil Rishi
Upon re-running the setup, the issue was resolved.
but the same issue comes up again if i select the default profile.
Tiensoon
The datasource of "default" profile is configured as:
url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8
However, the default MySQL database bundled with Joget Workflow v2 is running on port 3307, and with "sampledb" as the database name.
So, if you would like to try switching database profile, you will have to edit the "default" profile by correcting this file: joget-installation-dir/wflow/datasource-default.properties
Nikhil Rishi
what is the purpose of default profile?
Tiensoon
It's a concept in Joget Workflow - supports multiple datasource profile, but only 1 profile is activated at anytime. So you can technically have a profile pointing to development environment, and another profile pointing to staging.
Nikhil Rishi
Thanks for the information Tiensoon, would appreciate if you advice me on the username validation post. I am stuck up on that.