1 Reply Latest reply on Jun 6, 2016 7:38 AM by Nicklas Karlsson

    Regarding DB connection problem in Wildfly10.0.0

    sivaraman viswanathan Newbie

      I have created the DataSource and JNDI using standalone.xml and its get properly created, unable to get the DB connection using JNDI, please find the below exception am getting:

       

      19:38:12,950 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (default task-3) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:343)

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:350)

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:285)

            at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1319)

            at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:496)

            at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:626)

            at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:598)

            at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:590)

            at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:429)

            at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:747)

            at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)

            at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:66)

            at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)

            at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

            at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)

            at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)

            at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:315)

            at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:75)

            at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)

            at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)

            at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

            at java.lang.reflect.Method.invoke(Unknown Source)

            at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:408)

            at com.sun.proxy.$Proxy29.insert(Unknown Source)

            at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:254)

            at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:52)

            at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)

            at com.sun.proxy.$Proxy30.saveLogin(Unknown Source)

            at com.svn.business.TransactionBoImpl.addLogin(TransactionBoImpl.java:17)

            at com.svn.rest.LoginService.addLogin(LoginService.java:37)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

            at java.lang.reflect.Method.invoke(Unknown Source)

            at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)

            at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)

            at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)

            at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)

            at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)

            at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)

            at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)

            at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)

            at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:317)

            at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)

            at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)

            at org.glassfish.jersey.internal.Errors.process(Errors.java:315)

            at org.glassfish.jersey.internal.Errors.process(Errors.java:297)

            at org.glassfish.jersey.internal.Errors.process(Errors.java:267)

            at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)

            at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:298)

            at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)

            at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)

            at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)

            at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)

            at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)

            at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)

            at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)

            at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

            at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

            at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

            at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

            at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

            at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)

            at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)

            at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)

            at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:284)

            at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:263)

            at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)

            at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:174)

            at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202)

            at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:793)

            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

            at java.lang.Thread.run(Unknown Source)

      Caused by: java.sql.SQLException: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;useSSL=false;useUnicode=true;characterEncoding=UTF-8' is not in this set.

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:695)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:663)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:653)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:638)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:606)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:624)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:620)

            at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:77)

            at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:652)

            at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:349)

            at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:221)

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:319)

            ... 87 more

      Caused by: com.mysql.cj.core.exceptions.WrongArgumentException: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;useSSL=false;useUnicode=true;characterEncoding=UTF-8' is not in this set.

            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

            at java.lang.reflect.Constructor.newInstance(Unknown Source)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:93)

            at com.mysql.cj.core.conf.DefaultPropertySet.initializeProperties(DefaultPropertySet.java:154)

            at com.mysql.cj.jdbc.ConnectionImpl.initializeDriverProperties(ConnectionImpl.java:2387)

            at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:643)

            ... 90 more

      Caused by: com.mysql.cj.core.exceptions.CJException: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;useSSL=false;useUnicode=true;characterEncoding=UTF-8' is not in this set.

            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

            at java.lang.reflect.Constructor.newInstance(Unknown Source)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)

            at com.mysql.cj.core.conf.AbstractPropertyDefinition.validateAllowableValues(AbstractPropertyDefinition.java:186)

            at com.mysql.cj.core.conf.BooleanPropertyDefinition.parseObject(BooleanPropertyDefinition.java:45)

            at com.mysql.cj.core.conf.BooleanPropertyDefinition.parseObject(BooleanPropertyDefinition.java:29)

            at com.mysql.cj.core.conf.AbstractRuntimeProperty.setFromString(AbstractRuntimeProperty.java:86)

            at com.mysql.cj.core.conf.AbstractRuntimeProperty.initializeFrom(AbstractRuntimeProperty.java:81)

            at com.mysql.cj.core.conf.ModifiableBooleanProperty.initializeFrom(ModifiableBooleanProperty.java:42)

            at com.mysql.cj.core.conf.AbstractRuntimeProperty.initializeFrom(AbstractRuntimeProperty.java:65)

            at com.mysql.cj.core.conf.DefaultPropertySet.initializeProperties(DefaultPropertySet.java:151)

            ... 92 more

       

      19:38:12,966 ERROR [io.undertow.request] (default task-3) UT005023: Exception handling request to /SVNPoc/rest/login/addlogin: javax.servlet.ServletException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

      ### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

      ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

            at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:489)

            at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)

            at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)

            at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)

            at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)

            at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)

            at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

            at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

            at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

            at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

            at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

            at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)

            at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)

            at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)

            at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

            at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:284)

            at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:263)

            at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)

            at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:174)

            at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202)

            at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:793)

            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

            at java.lang.Thread.run(Unknown Source)

      Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

      ### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

      ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

            at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:76)

            at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:421)

            at com.sun.proxy.$Proxy29.insert(Unknown Source)

            at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:254)

            at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:52)

            at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)

            at com.sun.proxy.$Proxy30.saveLogin(Unknown Source)

            at com.svn.business.TransactionBoImpl.addLogin(TransactionBoImpl.java:17)

            at com.svn.rest.LoginService.addLogin(LoginService.java:37)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

            at java.lang.reflect.Method.invoke(Unknown Source)

            at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)

            at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)

            at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)

            at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)

            at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)

            at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)

            at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)

            at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)

            at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:317)

            at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)

            at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)

            at org.glassfish.jersey.internal.Errors.process(Errors.java:315)

            at org.glassfish.jersey.internal.Errors.process(Errors.java:297)

            at org.glassfish.jersey.internal.Errors.process(Errors.java:267)

            at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)

            at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:298)

            at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)

            at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)

            ... 31 more

      Caused by: org.apache.ibatis.exceptions.PersistenceException:

      ### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

      ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

            at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:172)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

            at java.lang.reflect.Method.invoke(Unknown Source)

            at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:408)

            ... 60 more

      Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

            at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)

            at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)

            at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)

            at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:315)

            at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:75)

            at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)

            at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)

            at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)

            ... 66 more

      Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

            at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)

            at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:66)

            at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)

            at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

            ... 74 more

      Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/svndemo

            at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:656)

            at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:429)

            at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:747)

            at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)

            ... 77 more

      Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:343)

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:350)

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:285)

            at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1319)

            at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:496)

            at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:626)

            at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:598)

            at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:590)

            ... 80 more

      Caused by: java.sql.SQLException: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;useSSL=false;useUnicode=true;characterEncoding=UTF-8' is not in this set.

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:695)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:663)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:653)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:638)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:606)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:624)

            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:620)

            at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:77)

            at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:652)

            at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:349)

            at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:221)

            at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:319)

            ... 87 more

      Caused by: com.mysql.cj.core.exceptions.WrongArgumentException: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;useSSL=false;useUnicode=true;characterEncoding=UTF-8' is not in this set.

            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

            at java.lang.reflect.Constructor.newInstance(Unknown Source)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:93)

            at com.mysql.cj.core.conf.DefaultPropertySet.initializeProperties(DefaultPropertySet.java:154)

            at com.mysql.cj.jdbc.ConnectionImpl.initializeDriverProperties(ConnectionImpl.java:2387)

            at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:643)

            ... 90 more

      Caused by: com.mysql.cj.core.exceptions.CJException: The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;useSSL=false;useUnicode=true;characterEncoding=UTF-8' is not in this set.

            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

            at java.lang.reflect.Constructor.newInstance(Unknown Source)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)

            at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)

            at com.mysql.cj.core.conf.AbstractPropertyDefinition.validateAllowableValues(AbstractPropertyDefinition.java:186)

            at com.mysql.cj.core.conf.BooleanPropertyDefinition.parseObject(BooleanPropertyDefinition.java:45)

            at com.mysql.cj.core.conf.BooleanPropertyDefinition.parseObject(BooleanPropertyDefinition.java:29)

            at com.mysql.cj.core.conf.AbstractRuntimeProperty.setFromString(AbstractRuntimeProperty.java:86)

            at com.mysql.cj.core.conf.AbstractRuntimeProperty.initializeFrom(AbstractRuntimeProperty.java:81)

            at com.mysql.cj.core.conf.ModifiableBooleanProperty.initializeFrom(ModifiableBooleanProperty.java:42)

            at com.mysql.cj.core.conf.AbstractRuntimeProperty.initializeFrom(AbstractRuntimeProperty.java:65)

            at com.mysql.cj.core.conf.DefaultPropertySet.initializeProperties(DefaultPropertySet.java:151)

            ... 92 more

       

       

      Kindly guide me the rectify this problem ASAP.