mysql 查询dual报错_项目中MySQL数据源转SQL server数据源Dual无效

最新推荐文章于 2024-08-19 03:43:21 发布

模数哥

最新推荐文章于 2024-08-19 03:43:21 发布

阅读量566

点赞数

文章标签： mysql 查询dual报错

本文链接：https://blog.csdn.net/weixin_36302268/article/details/113346449

版权

博客内容讲述了在项目中将MySQL数据源切换为SQL Server时遇到的'DUAL'对象名无效错误。错误源于'DUAL'表是MySQL中的虚拟表，而在SQL Server中并不存在。解决方案是检查并移除配置文件中可能存在的使用'DUAL'表的jdbc.testSql属性，从而避免此类报错。

摘要由CSDN通过智能技术生成

报错：

2017-12-12 15:54:54,279 ERROR [com.alibaba.druid.pool.DruidDataSource] - dataSource init error

java.sql.SQLException: 对象名 'DUAL' 无效。

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(AbstractAutowir

关注