注册

启动连接报无效的表或视图名

来日方长 2023/04/20 1567 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:windows
【CPU】:
【问题描述】*:
驱动配置OK,启动连接报错,原来是使用mysql-mybatis,驱动改了链接url和用户信息更改了运行报错如下

Error querying database. Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误:

无效的表或视图名[SYS_ACCESSINFO]

The error may exist in file [D:\ZZN\IDEAProject\CloudProject\cmsv2\cms.dao\target\classes\mapper\AccessInfoMapper.xml]

The error may involve com.base.cms.dao.mapper.AccessInfoMapper.queryAll

The error occurred while executing a query

SQL: select * from sys_accessinfo

Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误:

无效的表或视图名[SYS_ACCESSINFO]
; 第1 行附近出现错误:
无效的表或视图名[SYS_ACCESSINFO]; nested exception is dm.jdbc.driver.DMException: 第1 行附近出现错误:
无效的表或视图名[SYS_ACCESSINFO]
2023-04-20 17:11:14.974 [main] INFO org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener [142]
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#7c588adc': Invocation of init method failed; nested exception is org.springframework.dao.DataIntegrityViolationException:

Error querying database. Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误:

无效的表或视图名[SYS_ACCESSINFO]

The error may exist in file [D:\ZZN\IDEAProject\CloudProject\cmsv2\cms.dao\target\classes\mapper\AccessInfoMapper.xml]

The error may involve com.base.cms.dao.mapper.AccessInfoMapper.queryAll

The error occurred while executing a query

SQL: select * from sys_accessinfo

Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误:

无效的表或视图名[SYS_ACCESSINFO]
; 第1 行附近出现错误:
无效的表或视图名[SYS_ACCESSINFO]; nested exception is dm.jdbc.driver.DMException: 第1 行附近出现错误:
无效的表或视图名[SYS_ACCESSINFO]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:139)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:419)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1737)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:576)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:312)
... 33 common frames omitted
Caused by: org.springframework.dao.DataIntegrityViolationException:

Error querying database. Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误:

无效的表或视图名[SYS_ACCESSINFO]

The error may exist in file [D:\ZZN\IDEAProject\CloudProject\cmsv2\cms.dao\target\classes\mapper\AccessInfoMapper.xml]

The error may involve com.base.cms.dao.mapper.AccessInfoMapper.queryAll

The error occurred while executing a query

SQL: select * from sys_accessinfo

Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误:

无效的表或视图名[SYS_ACCESSINFO]
; 第1 行附近出现错误:
无效的表或视图名[SYS_ACCESSINFO]; nested exception is dm.jdbc.driver.DMException: 第1 行附近出现错误:
无效的表或视图名[SYS_ACCESSINFO]
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy101.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy102.queryAll(Unknown Source)
at com.base.cms.api.filter.ApFilter.getClientkey(ApFilter.java:178)
at com.base.cms.api.filter.ApFilter.init(ApFilter.java:74)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:363)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:307)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)
... 38 common frames omitted
Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误:
无效的表或视图名[SYS_ACCESSINFO]
at dm.jdbc.driver.DBError.throwException(DBError.java:711)
at dm.jdbc.a.b.o.x(MSG.java:591)
at dm.jdbc.a.b.o.C(MSG.java:526)
at dm.jdbc.a.b.o.B(MSG.java:507)
at dm.jdbc.a.a.a(DBAccess.java:245)
at dm.jdbc.a.a.a(DBAccess.java:718)
at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(DmdbPreparedStatement.java:303)
at dm.jdbc.driver.DmdbPreparedStatement.allocateHandle(DmdbPreparedStatement.java:229)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:131)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:181)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:722)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:708)
at dm.jdbc.driver.DmdbConnection.prepareStatement(DmdbConnection.java:1332)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:1100)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:402)
at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:375)
at com.github.pagehelper.PageHelper.intercept(PageHelper.java:252)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy103.query(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.base.cms.api.datasource.SqlPrintInterceptor.intercept(SqlPrintInterceptor.java:51)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy103.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
... 53 common frames omitted
Disconnected from the target VM, address: '127.0.0.1:15625', transport: 'socket'

Process finished with exit code 1
不知是原来数据源配置有问题还什么样

回答 0
暂无回答
扫一扫
联系客服