NutzCN Logo
问答 Table 'tsoc.dm_instr' doesn't exist
发布于 1804天前 作者 qq_75301de6 1304 次浏览 复制 上一个帖子 下一个帖子
标签:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'tsoc.dm_instr' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:151)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:42)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:242)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:64)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:197)
	at org.nutz.dao.impl.NutDao.query(NutDao.java:379)
	at com.venustech.tsoc.cupid.deviceManage.service.DeviceManageService.getPaging(DeviceManageService.java:60)
	at com.venustech.tsoc.cupid.deviceManage.controller.DeviceManageController.viewList(DeviceManageController.java:81)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:22)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at com.venustech.tsoc.cupid.AccessControlProcessor.process(SourceFile:95)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at com.venustech.tsoc.cupid.logging.LoggingProcessor.process(SourceFile:121)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:40)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:85)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:40)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:64)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:101)
	at com.venustech.tsoc.CupidNutFilter.doFilter(SourceFile:72)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:722)
2019-05-22 13:51:15,124 [http-bio-8888-exec-13] INFO  com.venustech.tsoc.cupid.logging.UserLogger - (1558504275124, 10, 'sysadmin', '127.0.0.1', 'deviceManagement', 'viewList', '指令集列表', 0, 'Table 'tsoc.dm_instr' doesn't exist')
2019-05-22 13:51:15,454 [http-bio-8888-exec-13] INFO  com.venustech.tsoc.cupid.logging.LoggingProcessor - [action failed] Obj = com.venustech.tsoc.cupid.deviceManage.controller.DeviceManageController@371546a5 , Throwable = com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'tsoc.dm_instr' doesn't exist , Method = public com.venustech.tsoc.cupid.commons.mvc.Pager com.venustech.tsoc.cupid.deviceManage.controller.DeviceManageController.viewList(javax.servlet.http.HttpServletRequest,org.nutz.ioc.Ioc,com.venustech.tsoc.cupid.commons.mvc.Pager) , args = [org.apache.catalina.connector.RequestFacade@4883b5c,/*NutIoc*/
{
loader:/*ComboIocLoader*/
{
   "iocMap" :{
      "dataSourceProperties" :{
         ...,com.venustech.tsoc.cupid.commons.mvc.Pager@1c19147d]
3 回复

然后呢?没点描述?

一直提示找不到这个表,但是我有 dm_instr 并没有 tsoc.dm_instr

很明显是你的代码里面有调用到

DeviceManageService

添加回复
请先登陆
回到顶部