mySql - Error creating bean with name 'identityService' defined in class path resource

getting below issue on setting mySql as database to flowable-task and flowable-rest projects,

T_ID_ VARCHAR(255) NULL, CONSTRAINT PK_ACT_CO_CONTENT_ITEM PRIMARY KEY (ID_))]
INFO 10/5/17 4:17 PM: liquibase: org/flowable/content/db/liquibase/flowable-content-db-changelog.xml::1::activiti: Successfully released change log lock
04:17:56,113 [localhost-startStop-1] WARN org.springframework.web.context.support.AnnotationConfigWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘demoDataConfiguration’: Unsatisfied dependency expressed through field ‘identityService’; nested
exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘identityService’ defined in class path resource [org/flowable/rest/conf/FlowableEngineConfiguration.class]: Bean instantiation via factory
method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flowable.engine.IdentityService]: Factory method ‘identityService’ threw exception; nested exception is org.springframework.s.factory.BeanCreationException: Error creating bean with name ‘processEngin
e’ defined in class path resource [org/flowable/rest/conf/FlowableEngineConfiguration.class]: Bean instantiation via factory method failed; nested exception is
org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flowable.engine.ProcessEngine]: Factory method ‘processEngine’ threw exception;nested exception is java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘processEngineFactoryBean’: FactoryBean threw exception on object creation; nested exception is org.flowable.engine.common.api.FlowableException: Error initialising content data schema

Hi,

It would really help if you gave the version number of MySQL and the web container you’re using (Tomcat?). However, I don’t think there’s enough information in the part of the log output you’ve added here to help. Somewhere in the log output there will be a message within the exception messages that states what it was caused by.

Cheers
Paul.

i am using “mysql-connector-java-5.1.30” at location - apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\lib
mysql version - 5.5.21

and db connections info. as,

datasource.driver=com.mysql.jdbc.Driver
datasource.url=jdbc:mysql://127.0.0.1:3306/flowable?characterEncoding=UTF-8

Stack Trace Exception:

07:51:05,877 [localhost-startStop-1] INFO org.flowable.idm.engine.impl.IdmEngineImpl - IdmEngine default created
07:51:05,880 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing configure() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200
000)
INFO 10/6/17 7:51 PM: liquibase: Successfully acquired change log lock
INFO 10/6/17 7:51 PM: liquibase: Reading from flowable.ACT_DMN_DATABASECHANGELOG
INFO 10/6/17 7:51 PM: liquibase: Successfully released change log lock
07:51:08,611 [localhost-startStop-1] INFO org.flowable.dmn.engine.impl.DmnEngineImpl - DmnEngine default created
07:51:08,614 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing configure() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:3
00000)
INFO 10/6/17 7:51 PM: liquibase: Successfully acquired change log lock
INFO 10/6/17 7:51 PM: liquibase: Reading from flowable.ACT_FO_DATABASECHANGELOG
INFO 10/6/17 7:51 PM: liquibase: Successfully released change log lock
07:51:09,102 [localhost-startStop-1] INFO org.flowable.form.engine.impl.FormEngineImpl - FormEngine default created
07:51:09,104 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing configure() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (prio
rity:400000)
INFO 10/6/17 7:51 PM: liquibase: Successfully acquired change log lock
INFO 10/6/17 7:51 PM: liquibase: Reading from flowable.ACT_CO_DATABASECHANGELOG
SEVERE 10/6/17 7:51 PM: liquibase: org/flowable/content/db/liquibase/flowable-content-db-changelog.xml: org/flowable/content/db/liquibase/flowable-content-db-changelog.xml::1::activiti: Change Set org/flowable/conte
nt/db/liquibase/flowable-content-db-changelog.xml::1::activiti failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(
6) NULL, CREATED_BY_ VARCHAR(255) NULL, LAST_MODIFIED_ timestamp(6) NULL, LAST_’ at line 1 [Failed SQL: CREATE TABLE flowable.ACT_CO_CONTENT_ITEM (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NOT NULL, MIME_TYPE_ V
ARCHAR(255) NULL, TASK_ID_ VARCHAR(255) NULL, PROC_INST_ID_ VARCHAR(255) NULL, CONTENT_STORE_ID_ VARCHAR(255) NULL, CONTENT_STORE_NAME_ VARCHAR(255) NULL, FIELD_ VARCHAR(400) NULL, CONTENT_AVAILABLE_ BIT(1) DEFAULT
0 NULL, CREATED_ timestamp(6) NULL, CREATED_BY_ VARCHAR(255) NULL, LAST_MODIFIED_ timestamp(6) NULL, LAST_MODIFIED_BY_ VARCHAR(255) NULL, CONTENT_SIZE_ BIGINT DEFAULT 0 NULL, TENANT_ID_ VARCHAR(255) NULL, CONSTRAINT
PK_ACT_CO_CONTENT_ITEM PRIMARY KEY (ID_))]
INFO 10/6/17 7:51 PM: liquibase: org/flowable/content/db/liquibase/flowable-content-db-changelog.xml::1::activiti: Successfully released change log lock
07:51:09,442 [localhost-startStop-1] WARN org.springframework.web.context.support.AnnotationConfigWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.sprin
gframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘demoDataConfiguration’: Unsatisfied dependency expressed through field ‘identityService’; nested exception is org.springframewo
rk.beans.factory.BeanCreationException: Error creating bean with name ‘identityService’ defined in class path resource [org/flowable/rest/conf/FlowableEngineConfiguration.class]: Bean instantiation via factory metho
d failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flowable.engine.IdentityService]: Factory method ‘identityService’ threw exception; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘processEngine’ defined in class path resource [org/flowable/rest/conf/FlowableEngineConfiguration.class]: Bean instantiation vi
a factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flowable.engine.ProcessEngine]: Factory method ‘processEngine’ threw exception; nested ex
ception is java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘processEngineFactoryBean’: FactoryBean threw exception on object creation; nested except
ion is org.flowable.engine.common.api.FlowableException: Error initialising content data schema
07:51:09,445 [localhost-startStop-1] INFO com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Close initiated…
07:51:09,458 [localhost-startStop-1] INFO com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Closed.
06-Oct-2017 19:51:09.467 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
06-Oct-2017 19:51:09.484 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/flowable-rest] startup failed due to previous errors
07:51:09,491 [localhost-startStop-1] INFO org.flowable.rest.servlet.WebConfigurer - Destroying Web application
06-Oct-2017 19:51:09.523 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\webapp
s\flowable-rest.war] has finished in [51,315] ms
06-Oct-2017 19:51:09.578 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\webapps\fl
owable-task.war]
06-Oct-2017 19:51:13.227 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete li
st of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
07:51:17,292 [localhost-startStop-1] INFO org.flowable.app.conf.AsyncConfiguration - Creating Async Task Executor
07:51:17,976 [localhost-startStop-1] INFO org.flowable.app.conf.DatabaseConfiguration - Configuring Datasource
07:51:18,006 [localhost-startStop-1] INFO org.flowable.app.conf.DatabaseConfiguration - Configuring Datasource with following properties (omitted password for security)
07:51:18,010 [localhost-startStop-1] INFO org.flowable.app.conf.DatabaseConfiguration - datasource driver : com.mysql.jdbc.Driver
07:51:18,011 [localhost-startStop-1] INFO org.flowable.app.conf.DatabaseConfiguration - datasource url : jdbc:mysql://127.0.0.1:3306/flowable?characterEncoding=UTF-8
07:51:18,011 [localhost-startStop-1] INFO org.flowable.app.conf.DatabaseConfiguration - datasource user name : root
07:51:18,012 [localhost-startStop-1] INFO org.flowable.app.conf.DatabaseConfiguration - Min pool size | Max pool size | acquire increment : 10 | 100 | 5
07:51:18,170 [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.
07:51:18,516 [localhost-startStop-1] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
07:51:18,522 [localhost-startStop-1] WARN com.mchange.v2.c3p0.management.ActiveManagementCoordinator - A C3P0Registry mbean is already registered. This probably means that an application using c3p0 was undeployed,
but not all PooledDataSources were closed prior to undeployment. This may lead to resource leaks over time. Please take care to close all PooledDataSources.
07:51:22,730 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Found 3 Process Engine Configurators in total:
07:51:22,730 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
07:51:22,730 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
07:51:22,730 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
07:51:22,730 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing beforeInit() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:20
0000)
07:51:22,922 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing beforeInit() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:
300000)
07:51:22,973 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing beforeInit() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (pri
ority:400000)
07:51:23,437 [localhost-startStop-1] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -

30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> c
om.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 2rxr4s9q1v5vzynkr3hls|8fbf7e, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass ->
com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 2rxr4s9q1v5v
zynkr3hls|8fbf7e, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://127.0.0.1:3306/flowable?characterEncoding=UTF-8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1
800, maxIdleTimeExcessConnections -> 1800, maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> fa
lse, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0,
userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
07:51:23,499 [localhost-startStop-1] WARN com.mchange.v2.resourcepool.BasicResourcePool - Bad pool size config, start 3 < min 10. Using 10 as start.
07:51:26,494 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing configure() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200

INFO 10/6/17 7:51 PM: liquibase: Successfully acquired change log lock
INFO 10/6/17 7:51 PM: liquibase: Reading from flowable.ACT_DMN_DATABASECHANGELOG
INFO 10/6/17 7:51 PM: liquibase: Successfully released change log lock
07:51:31,394 [localhost-startStop-1] INFO org.flowable.dmn.engine.impl.DmnEngineImpl - DmnEngine default created
07:51:31,396 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing configure() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:3
00000)
INFO 10/6/17 7:51 PM: liquibase: Successfully acquired change log lock
INFO 10/6/17 7:51 PM: liquibase: Reading from flowable.ACT_FO_DATABASECHANGELOG
INFO 10/6/17 7:51 PM: liquibase: Successfully released change log lock
07:51:31,706 [localhost-startStop-1] INFO org.flowable.form.engine.impl.FormEngineImpl - FormEngine default created
07:51:31,710 [localhost-startStop-1] INFO org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl - Executing configure() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (prio
rity:400000)
INFO 10/6/17 7:51 PM: liquibase: Successfully acquired change log lock
INFO 10/6/17 7:51 PM: liquibase: Reading from flowable.ACT_CO_DATABASECHANGELOG
SEVERE 10/6/17 7:51 PM: liquibase: org/flowable/content/db/liquibase/flowable-content-db-changelog.xml: org/flowable/content/db/liquibase/flowable-content-db-changelog.xml::1::activiti: Change Set org/flowable/conte
nt/db/liquibase/flowable-content-db-changelog.xml::1::activiti failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(
6) NULL, CREATED_BY_ VARCHAR(255) NULL, LAST_MODIFIED_ timestamp(6) NULL, LAST_’ at line 1 [Failed SQL: CREATE TABLE flowable.ACT_CO_CONTENT_ITEM (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NOT NULL, MIME_TYPE_ V
ARCHAR(255) NULL, TASK_ID_ VARCHAR(255) NULL, PROC_INST_ID_ VARCHAR(255) NULL, CONTENT_STORE_ID_ VARCHAR(255) NULL, CONTENT_STORE_NAME_ VARCHAR(255) NULL, FIELD_ VARCHAR(400) NULL, CONTENT_AVAILABLE_ BIT(1) DEFAULT
0 NULL, CREATED_ timestamp(6) NULL, CREATED_BY_ VARCHAR(255) NULL, LAST_MODIFIED_ timestamp(6) NULL, LAST_MODIFIED_BY_ VARCHAR(255) NULL, CONTENT_SIZE_ BIGINT DEFAULT 0 NULL, TENANT_ID_ VARCHAR(255) NULL, CONSTRAINT
PK_ACT_CO_CONTENT_ITEM PRIMARY KEY (ID_))]
INFO 10/6/17 7:51 PM: liquibase: org/flowable/content/db/liquibase/flowable-content-db-changelog.xml::1::activiti: Successfully released change log lock
07:51:32,013 [localhost-startStop-1] WARN org.springframework.web.context.support.AnnotationConfigWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.sprin
gframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘deploymentServiceImpl’: Unsatisfied dependency expressed through field ‘repositoryService’; nested exception is org.springframe
work.beans.factory.BeanCreationException: Error creating bean with name ‘repositoryService’ defined in class path resource [org/flowable/app/conf/FlowableEngineConfiguration.class]: Bean instantiation via factory me
thod failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flowable.engine.RepositoryService]: Factory method ‘repositoryService’ threw exception; nested except
ion is java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘processEngine’: FactoryBean threw exception on object creation; nested exception is org.flow
able.engine.common.api.FlowableException: Error initialising content data schema
06-Oct-2017 19:51:32.023 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
06-Oct-2017 19:51:32.024 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/flowable-task] startup failed due to previous errors
07:51:32,027 [localhost-startStop-1] INFO org.flowable.app.servlet.WebConfigurer - Destroying Web application
06-Oct-2017 19:51:32.029 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [flowable-task] created a ThreadLocal with key of type [java.l
ang.ThreadLocal] (value [java.lang.ThreadLocal@133e695]) and a value of type [org.apache.ibatis.executor.ErrorContext] (value [

The error may exist in org/flowable/content/db/mapping/entity/TableData.xml

The error occurred while processing mapper_resultMap[deploymentResultMap]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable mem

ory leak.
06-Oct-2017 19:51:32.032 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\webapp
s\flowable-task.war] has finished in [22,453] ms
06-Oct-2017 19:51:32.033 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\we
bapps\docs]
06-Oct-2017 19:51:32.298 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete li
st of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
06-Oct-2017 19:51:32.301 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.1
5\webapps\docs] has finished in [267] ms
06-Oct-2017 19:51:32.301 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\we
bapps\examples]
06-Oct-2017 19:51:36.281 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete li
st of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
06-Oct-2017 19:51:36.526 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.1
5\webapps\examples] has finished in [4,225] ms
06-Oct-2017 19:51:36.527 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\we
bapps\host-manager]
06-Oct-2017 19:51:36.860 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete li
st of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
06-Oct-2017 19:51:36.898 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.1
5\webapps\host-manager] has finished in [371] ms
06-Oct-2017 19:51:36.899 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\we
bapps\manager]
06-Oct-2017 19:51:37.220 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete li
st of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
06-Oct-2017 19:51:37.236 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.1
5\webapps\manager] has finished in [337] ms
06-Oct-2017 19:51:37.237 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.15\we
bapps\ROOT]
06-Oct-2017 19:51:37.501 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete li
st of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
06-Oct-2017 19:51:37.504 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\Softwares\apache-tomcat-8.5.15-windows-x86\apache-tomcat-8.5.1
5\webapps\ROOT] has finished in [267] ms
06-Oct-2017 19:51:37.509 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [“http-nio-8080”]
06-Oct-2017 19:51:37.609 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [“ajp-nio-8009”]
06-Oct-2017 19:51:37.615 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 152679 ms

can i have any update on this

You indicated that you are using mysql version - 5.5.21 (that is version 5.5) and I believe there is an issue with declaring a timestamp datatype. Can you try using a 5.6 version and see if things work? There were signification changes with timestamp between those two versions.