Shulou(Shulou.com)06/01 Report--

Error report:

2017-12-12 15 dataSource init error 5414 ERROR [com.alibaba.druid.pool.DruidDataSource]-dataSource init error

Java.sql.SQLException: the object name 'DUAL' is invalid.

At net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic (SQLDiagnostic.java:372)

At net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken (TdsCore.java:2988)

At net.sourceforge.jtds.jdbc.TdsCore.nextToken (TdsCore.java:2421)

At net.sourceforge.jtds.jdbc.TdsCore.getMoreResults (TdsCore.java:671)

At net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery (JtdsStatement.java:505)

At net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery (JtdsStatement.java:1427)

At com.alibaba.druid.filter.FilterChainImpl.statement_executeQuery (FilterChainImpl.java:2363)

At com.alibaba.druid.filter.FilterAdapter.statement_executeQuery (FilterAdapter.java:2481)

At com.alibaba.druid.filter.FilterEventAdapter.statement_executeQuery (FilterEventAdapter.java:302)

At com.alibaba.druid.filter.FilterChainImpl.statement_executeQuery (FilterChainImpl.java:2360)

At com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeQuery (StatementProxyImpl.java:211)

At com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection (DruidAbstractDataSource.java:1229)

At com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection (DruidAbstractDataSource.java:1439)

At com.alibaba.druid.pool.DruidDataSource.init (DruidDataSource.java:630)

At sun.reflect.GeneratedMethodAccessor36.invoke (Unknown Source)

At sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)

At java.lang.reflect.Method.invoke (Method.java:498)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod (AbstractAutowireCapableBeanFactory.java:1758)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods (AbstractAutowireCapableBeanFactory.java:1695)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean (AbstractAutowireCapableBeanFactory.java:1624)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean (AbstractAutowireCapableBeanFactory.java:555)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java:483)

At org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject (AbstractBeanFactory.java:306)

At org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton (DefaultSingletonBeanRegistry.java:230)

At org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean (AbstractBeanFactory.java:302)

At org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:197)

At org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference (BeanDefinitionValueResolver.java:351)

At org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary (BeanDefinitionValueResolver.java:108)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues (AbstractAutowireCapableBeanFactory.java:1531)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean (AbstractAutowireCapableBeanFactory.java:1276)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean (AbstractAutowireCapableBeanFactory.java:553)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java:483)

At org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject (AbstractBeanFactory.java:306)

At org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton (DefaultSingletonBeanRegistry.java:230)

At org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean (AbstractBeanFactory.java:302)

At org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:197)

At org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference (BeanDefinitionValueResolver.java:351)

At org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary (BeanDefinitionValueResolver.java:108)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues (AbstractAutowireCapableBeanFactory.java:1531)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean (AbstractAutowireCapableBeanFactory.java:1276)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean (AbstractAutowireCapableBeanFactory.java:553)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java:483)

At org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject (AbstractBeanFactory.java:306)

At org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton (DefaultSingletonBeanRegistry.java:230)

At org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean (AbstractBeanFactory.java:302)

At org.springframework.beans.factory.support.AbstractBeanFactory.getTypeForFactoryBean (AbstractBeanFactory.java:1508)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getTypeForFactoryBean (AbstractAutowireCapableBeanFactory.java:816)

At org.springframework.beans.factory.support.AbstractBeanFactory.isTypeMatch (AbstractBeanFactory.java:558)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType (DefaultListableBeanFactory.java:432)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType (DefaultListableBeanFactory.java:403)

At org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors (BeanFactoryUtils.java:220)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates (DefaultListableBeanFactory.java:1267)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency (DefaultListableBeanFactory.java:1101)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency (DefaultListableBeanFactory.java:1066)

At org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject (AutowiredAnnotationBeanPostProcessor.java:585)

At org.springframework.beans.factory.annotation.InjectionMetadata.inject (InjectionMetadata.java:88)

At org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues (AutowiredAnnotationBeanPostProcessor.java:366)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean (AbstractAutowireCapableBeanFactory.java:1264)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean (AbstractAutowireCapableBeanFactory.java:553)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java:483)

At org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject (AbstractBeanFactory.java:306)

At org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton (DefaultSingletonBeanRegistry.java:230)

At org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean (AbstractBeanFactory.java:302)

At org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:202)

At org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate (DependencyDescriptor.java:208)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency (DefaultListableBeanFactory.java:1138)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency (DefaultListableBeanFactory.java:1066)

At org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject (AutowiredAnnotationBeanPostProcessor.java:585)

At org.springframework.beans.factory.annotation.InjectionMetadata.inject (InjectionMetadata.java:88)

At org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues (AutowiredAnnotationBeanPostProcessor.java:366)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean (AbstractAutowireCapableBeanFactory.java:1264)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean (AbstractAutowireCapableBeanFactory.java:553)

At org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java:483)

At org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject (AbstractBeanFactory.java:306)

At org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton (DefaultSingletonBeanRegistry.java:230)

At org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean (AbstractBeanFactory.java:302)

At org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:197)

At org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons (DefaultListableBeanFactory.java:761)

At org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization (AbstractApplicationContext.java:867)

At org.springframework.context.support.AbstractApplicationContext.refresh (AbstractApplicationContext.java:543)

At org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext (ContextLoader.java:403)

At org.springframework.web.context.ContextLoader.initWebApplicationContext (ContextLoader.java:306)

At com.modules.sys.listener.WebContextListener.initWebApplicationContext (WebContextListener.java:16)

At org.springframework.web.context.ContextLoaderListener.contextInitialized (ContextLoaderListener.java:106)

At org.apache.catalina.core.StandardContext.listenerStart (StandardContext.java:4939)

At org.apache.catalina.core.StandardContext.startInternal (StandardContext.java:5434)

At org.apache.catalina.util.LifecycleBase.start (LifecycleBase.java:150)

At org.apache.catalina.core.ContainerBase$StartChild.call (ContainerBase.java:1559)

At org.apache.catalina.core.ContainerBase$StartChild.call (ContainerBase.java:1549)

At java.util.concurrent.FutureTask.run (FutureTask.java:266)

At java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142)

At java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:617)

At java.lang.Thread.run (Thread.java:748)

Reason: the DUAL table is a virtual table in MySQL, and its function is to satisfy select. From.; but does not exist in SQL service, so the above error is reported. Solution: check whether there is any jdbc.testSql in jdbc.properties. If so, you can cancel the reference of the corresponding connection pool.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.