Invalid MySQL data source to SQL server data source Dual in the project
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.
