Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi,
I've already pulled the last of hairs, so I turn to you guys. Please help me.
I already followed the instructions of this page http://dev.joget.org/community/display/KBv4/Building+from+Source
And I'm already in the Build Project Section.
Here's the datasource config of my local server:
Also, there is no password for the root account. The page automatically inserts those input mask "dots" in the Password field whenever I save it blank.
The result of this is:
D:\SVEN\joget\wflow\app_datasource-default.properties
# #Thu Mar 05 16:51:44 ULAT 2015 workflowDriver=com.mysql.jdbc.Driver workflowUrl=jdbc\:mysql\://localhost\:3307/jwdb?characterEncoding\=UTF-8 workflowUser=root encryption=\u0019\uFFFD\uFFFD\r'4Q\uFFFD9\uFFFDYf\u0004ce\uFFFD\u0015\uFFFDsz\uFFFD_jg profileName= workflowPassword=%%%%QJvMiQJCBHj1PBOFeSMEPA\=\=%%%%
*root does not have a password
According to the instructions and other forum posts, I should also modify:
C:\Users\SVEN\wflow\app_datasource-default.properties
so here it is:
# #Thu Mar 05 16:51:44 ULAT 2015 workflowDriver=com.mysql.jdbc.Driver workflowUrl=jdbc\:mysql\://localhost\:3307/jwdb?characterEncoding\=UTF-8 workflowUser=root encryption=\u0019\uFFFD\uFFFD\r'4Q\uFFFD9\uFFFDYf\u0004ce\uFFFD\u0015\uFFFDsz\uFFFD_jg profileName= workflowPassword=%%%%QJvMiQJCBHj1PBOFeSMEPA\=\=%%%%
But I still get the error:
SUREFIRE FILES:
org.joget.directory.model.service.TestDirectoryManager.txt
org.joget.directory.model.service.TestDirectoryManager.xml
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.joget.directory.model.service.TestDirectoryManager
INFO 05 Mar 2015 16:47:45 org.joget.commons.util.SetupManager - Using base directory: C:\Users\SVEN\wflow\
No org.slf4j.impl.StaticLoggerBinder found in ClassPath, trying with log4j...
INFO 05 Mar 2015 16:47:45 com.atomikos.logging.LoggerFactory - Using Log4j for logging.
WARN 05 Mar 2015 16:47:45 com.atomikos.icatch.config.UserTransactionServiceImp - No properties path set - looking for transactions.properties in classpath...
WARN 05 Mar 2015 16:47:45 com.atomikos.icatch.config.UserTransactionServiceImp - transactions.properties not found - looking for jta.properties in classpath...
WARN 05 Mar 2015 16:47:45 com.atomikos.icatch.config.UserTransactionServiceImp - Failed to open transactions properties file - using default values
INFO 05 Mar 2015 16:47:45 com.atomikos.persistence.imp.FileLogStream - Starting read of logfile D:\SVEN\joget\wflow-directory\.\tmlog8.log
INFO 05 Mar 2015 16:47:45 com.atomikos.persistence.imp.FileLogStream - Done read of logfile
INFO 05 Mar 2015 16:47:45 com.atomikos.persistence.imp.FileLogStream - Logfile closed: D:\SVEN\joget\wflow-directory\.\tmlog8.log
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING core version: 3.8.0
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_name = tm.out
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_count = 1
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.automatic_resource_registration = true
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.client_demarcation = false
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.threaded_2pc = false
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.serial_jta_transactions = true
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.log_base_dir = .\
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_log_level = WARN
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.max_actives = 50
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.checkpoint_interval = 500
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.enable_logging = true
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.output_dir = .\
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.log_base_name = tmlog
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_limit = -1
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.max_timeout = 300000
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.tm_unique_name = 192.168.56.1.tm
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING java.naming.provider.url = rmi://localhost:1099
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.service = com.atomikos.icatch.standalone.UserTransactionServiceFactory
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.force_shutdown_on_vm_exit = false
INFO 05 Mar 2015 16:47:45 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.default_jta_timeout = 10000
INFO 05 Mar 2015 16:47:51 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8, user=root
ERROR 05 Mar 2015 16:47:52 org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
INFO 05 Mar 2015 16:47:52 com.atomikos.persistence.imp.FileLogStream - Logfile closed: D:\SVEN\joget\wflow-directory\.\tmlog9.log
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.imp.thread.TaskManager - THREADS: using JDK thread pooling...
ERROR 05 Mar 2015 16:47:52 org.springframework.test.context.TestContextManager - Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5505ae1a] to prepare test instance [org.joget.directory.model.service.TestDirectoryManager@73cd37c0]
java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:201)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:109)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:75)
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:255)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:111)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:148)
at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'setupSessionFactory' defined in class path resource [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:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
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.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:84)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:42)
at org.springframework.test.context.TestContext.loadApplicationContext(TestContext.java:173)
at org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:197)
... 21 more
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(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 37 more
WARN 05 Mar 2015 16:47:52 com.atomikos.icatch.config.UserTransactionServiceImp - No properties path set - looking for transactions.properties in classpath...
WARN 05 Mar 2015 16:47:52 com.atomikos.icatch.config.UserTransactionServiceImp - transactions.properties not found - looking for jta.properties in classpath...
WARN 05 Mar 2015 16:47:52 com.atomikos.icatch.config.UserTransactionServiceImp - Failed to open transactions properties file - using default values
INFO 05 Mar 2015 16:47:52 com.atomikos.persistence.imp.FileLogStream - Starting read of logfile D:\SVEN\joget\wflow-directory\.\tmlog9.log
INFO 05 Mar 2015 16:47:52 com.atomikos.persistence.imp.FileLogStream - Done read of logfile
INFO 05 Mar 2015 16:47:52 com.atomikos.persistence.imp.FileLogStream - Logfile closed: D:\SVEN\joget\wflow-directory\.\tmlog9.log
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING core version: 3.8.0
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_name = tm.out
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_count = 1
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.automatic_resource_registration = true
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.client_demarcation = false
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.threaded_2pc = false
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.serial_jta_transactions = true
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.log_base_dir = .\
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_log_level = WARN
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.max_actives = 50
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.checkpoint_interval = 500
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.enable_logging = true
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.output_dir = .\
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.log_base_name = tmlog
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_limit = -1
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.max_timeout = 300000
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.tm_unique_name = 192.168.56.1.tm
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING java.naming.provider.url = rmi://localhost:1099
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.service = com.atomikos.icatch.standalone.UserTransactionServiceFactory
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.force_shutdown_on_vm_exit = false
INFO 05 Mar 2015 16:47:52 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.default_jta_timeout = 10000
INFO 05 Mar 2015 16:47:53 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8, user=root
ERROR 05 Mar 2015 16:47:53 org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
INFO 05 Mar 2015 16:47:53 com.atomikos.persistence.imp.FileLogStream - Logfile closed: D:\SVEN\joget\wflow-directory\.\tmlog10.log
ERROR 05 Mar 2015 16:47:53 org.springframework.test.context.TestContextManager - Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5505ae1a] to prepare test instance [org.joget.directory.model.service.TestDirectoryManager@4331d187]
java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:201)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:109)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:75)
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:255)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:111)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:148)
at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'setupSessionFactory' defined in class path resource [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:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
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.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:84)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:42)
at org.springframework.test.context.TestContext.loadApplicationContext(TestContext.java:173)
at org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:197)
... 21 more
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(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 37 more
WARN 05 Mar 2015 16:47:53 com.atomikos.icatch.config.UserTransactionServiceImp - No properties path set - looking for transactions.properties in classpath...
WARN 05 Mar 2015 16:47:53 com.atomikos.icatch.config.UserTransactionServiceImp - transactions.properties not found - looking for jta.properties in classpath...
WARN 05 Mar 2015 16:47:53 com.atomikos.icatch.config.UserTransactionServiceImp - Failed to open transactions properties file - using default values
INFO 05 Mar 2015 16:47:53 com.atomikos.persistence.imp.FileLogStream - Starting read of logfile D:\SVEN\joget\wflow-directory\.\tmlog10.log
INFO 05 Mar 2015 16:47:53 com.atomikos.persistence.imp.FileLogStream - Done read of logfile
INFO 05 Mar 2015 16:47:53 com.atomikos.persistence.imp.FileLogStream - Logfile closed: D:\SVEN\joget\wflow-directory\.\tmlog10.log
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING core version: 3.8.0
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_name = tm.out
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_count = 1
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.automatic_resource_registration = true
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.client_demarcation = false
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.threaded_2pc = false
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.serial_jta_transactions = true
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.log_base_dir = .\
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_log_level = WARN
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.max_actives = 50
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.checkpoint_interval = 500
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.enable_logging = true
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.output_dir = .\
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.log_base_name = tmlog
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.console_file_limit = -1
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.max_timeout = 300000
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.tm_unique_name = 192.168.56.1.tm
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING java.naming.provider.url = rmi://localhost:1099
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.service = com.atomikos.icatch.standalone.UserTransactionServiceFactory
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.force_shutdown_on_vm_exit = false
INFO 05 Mar 2015 16:47:53 com.atomikos.icatch.config.imp.AbstractUserTransactionService - USING com.atomikos.icatch.default_jta_timeout = 10000
INFO 05 Mar 2015 16:47:53 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8, user=root
ERROR 05 Mar 2015 16:47:53 org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
INFO 05 Mar 2015 16:47:53 com.atomikos.persistence.imp.FileLogStream - Logfile closed: D:\SVEN\joget\wflow-directory\.\tmlog11.log
ERROR 05 Mar 2015 16:47:53 org.springframework.test.context.TestContextManager - Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5505ae1a] to prepare test instance [org.joget.directory.model.service.TestDirectoryManager@2ea6e30c]
java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:201)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:109)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:75)
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:255)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:111)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:148)
at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'setupSessionFactory' defined in class path resource [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:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
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.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:84)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:42)
at org.springframework.test.context.TestContext.loadApplicationContext(TestContext.java:173)
at org.springframework.test.context.TestContext.getApplicationContext(TestContext.java:197)
... 21 more
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(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 37 more
Tests run: 3, Failures: 0, Errors: 3, Skipped: 0, Time elapsed: 10.858 sec <<< FAILURE!
Results :
Tests in error:
testDeletion(org.joget.directory.model.service.TestDirectoryManager)
testUsersAndGroups(org.joget.directory.model.service.TestDirectoryManager)
testOrganizationChart(org.joget.directory.model.service.TestDirectoryManager)
Tests run: 3, Failures: 0, Errors: 3, Skipped: 0
------------------------------------------------------------------------
Reactor Summary:
wflow-jdbc ........................................ SUCCESS [32.198s]
wflow-commons ..................................... SUCCESS [6.361s]
wflow-plugin-base ................................. SUCCESS [6.900s]
wflow-plugin-archetype ............................ SUCCESS [11.209s]
wflow-directory ................................... FAILURE [17.363s]
wflow-wfengine .................................... SKIPPED
wflow-core ........................................ SKIPPED
wflow-consoleweb .................................. SKIPPED
wflow-designer .................................... SKIPPED
wflow-designerweb ................................. SKIPPED
wflow-app ......................................... SKIPPED
------------------------------------------------------------------------
BUILD FAILURE
------------------------------------------------------------------------
Total time: 1:14.531s
Finished at: Thu Mar 05 16:47:53 ULAT 2015
Final Memory: 29M/115M
------------------------------------------------------------------------
Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.4.3:test (default-test) on project wflow-directory: There are test failures.
Please refer to D:\SVEN\joget\wflow-directory\target\surefire-reports for the individual test results.
-> [Help 1]
To see the full stack trace of the errors, re-run Maven with the -e switch.
Re-run Maven using the -X switch to enable full debug logging.
For more information about the errors and possible solutions, please read the following articles:
[Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
After correcting the problems, you can resume the build with the command
mvn <goals> -rf :wflow-directory
9 Comments
Hugo
Hi there,
It is still complaining about lack of database access by this line.
Try to use clear text password as the build test may not be using the new enhanced security manager implementation for password encryption.
You should be looking at this file.
Set workflowPassword to blank or clear text password
Remove encryption attribute.
Then try again.
Hope this helps.
Thanks.
Jaronloch
Hi Hugo,
Here's a run thru on what I did:
I have edited D:\Users\SVEN\wflow\app_datasource-default.properties to:
And tried to run mvn install but it still returned the same error as above.
So I changed D:\sven\joget\wflow\app_datasource-default.properties from: (encrypted)
in to: (cleartext)
And it still did not continue building.
I ran mysql to check the user, port and databases.
Also, I have set a new password for mysql so that I will be able to set a cleartext password for the D:\USERS\SVEN\app_datasource-default.properties file.
So I edited the D:\USERS\SVEN\app_datasource-default.properties to contain an encrypted password, and the result was this:
Access denied.
So I edited the D:\USERS\SVEN\app_datasource-default.properties to contain cleartext password, and the result was this:
The Cleartext managed to connect, but we still experienced errors.
Here are the Surefire files from the Cleartext result:
03102015_org.joget.directory.model.service.TestDirectoryManager.txt
03102015_TEST-org.joget.directory.model.service.TestDirectoryManager.xml
Thank you
Hugo
Hi there,
Try to
at /wflow-app so that it will purge existing build and its possible problems and try to build again, fresh.
Thanks.
Jaronloch
Hi Hugo,
MVN Clean
MVN Install
Still the same error.
Thanks
Hugo
Hi there,
I'm seeing the following.
A quick google suggests that you may have missing library. You may need the following library loaded into your maven repo - http://mvnrepository.com/artifact/backport-util-concurrent/backport-util-concurrent/3.1\\
I have tried to use maven 2.2 and 3.2.1 to build before without problem. What is your maven version?
You can also probably try to follow the video tutorial as well at https://www.youtube.com/watch?v=5k-mqaaT5RQ
Cheers.
Jaronloch
Hi Hugo,
I installed the backport dependency but still no luck.
I am using:
Joget Enterprise 4.0.14
Maven 3.2.5
The video tutorial is for Joget V3, will there be no problem if I'm using V4?
Jaronloch
Hi Hugo,
I have reinstalled joget V4 and rerun the whole Build from Source process, but I still get the same error.
Thanks,
JCB
Jaronloch
Hi,
I will just post my progress here in case someone would be also kind enough to help and for future reference
I reverted to Joget V3 and to maven 3.2.5
I have cleaned the mvn installation.
Installed the backport-util-concurrent, and the latest error is this:
------------
Caused by: org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from URL location [classpath:commonsApplicationContext.xml]
Offending resource: class path resource [directoryApplicationContext.xml]; nested exception is org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 13 in XML document from class path resource [commonsApplicationContext.xml] is invalid; nested exception is org.xml.sax.SAXParseException; lineNumber: 13; columnNumber: 6; The processing instruction target matching "[xX][mM][lL]" is not allowed.
------------
I am currently tinkering on
wflow-commons\target\classes\commonsApplicationContext.xml
and
wflow-directory\target\classes\directoryApplicationContext.xml
changing the directory definition format inside the setupSessionFactory bean from
org/joget/commons/spring/model/Setting.hbm.xml (linux format)
to
org\joget\commons\spring\model\Setting.hbm.xml (windows format)
to
D:\joget\3.1-SNAPSHOT\wflow-commons\target\classes\org\joget\commons\spring\model\Setting.hbm.xml (full path windows format)
---------
All attempts returned the same error.
Jaronloch
So it seems that Spring could not find classpath:commonsApplicationContext.xml thus failing to import it in line 11 of directoryApplicationContext.xml
<import resource="classpath:commonsApplicationContext.xml" />
Where can I find the value of the classpath variable? How will I be able to change or set it?
Thanks.