栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > .Net

java socketexception

.Net 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

java socketexception

还有个问题 新增的时候没问题 编辑删除的时候

[DEBUG] 12:40:06.223 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) - Found mapping for [POST] path=/user/update : UserModule.update(UserModule.java:74)

[DEBUG] 12:40:06.223 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:166) - Get 'userModule'

[DEBUG] 12:40:06.224 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:391) - UPDATE t_user SET name=?,age=?,location=? WHERe id=?

| 1 | 2 | 3 | 4 |

|----|----|------|---|

| 张丽 | 22 | NULL | 4 |

For example:> "UPDATE t_user SET name='张丽',age=22,location=NULL WHERe id=4"

[DEBUG] 12:40:06.228 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:103) - SQLException

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ds_0.t_user_0' doesn't exist

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.Util.getInstance(Util.java:408)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)

at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)

at io.shardingjdbc.core.executor.type.prepared.PreparedStatementExecutor$3.execute(PreparedStatementExecutor.java:101)

at io.shardingjdbc.core.executor.type.prepared.PreparedStatementExecutor$3.execute(PreparedStatementExecutor.java:97)

at io.shardingjdbc.core.executor.ExecutorEngine.executeInternal(ExecutorEngine.java:187)

at io.shardingjdbc.core.executor.ExecutorEngine.syncExecute(ExecutorEngine.java:167)

at io.shardingjdbc.core.executor.ExecutorEngine.execute(ExecutorEngine.java:131)

at io.shardingjdbc.core.executor.ExecutorEngine.executePreparedStatement(ExecutorEngine.java:98)

at io.shardingjdbc.core.executor.type.prepared.PreparedStatementExecutor.execute(PreparedStatementExecutor.java:97)

at io.shardingjdbc.core.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:141)

at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:311)

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)

at org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:23)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)

at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:163)

at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:130)

at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:97)

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:86)

at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:242)

at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:254)

at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:58)

at org.nutz.dao.impl.NutDao.update(NutDao.java:275)

at dccb.ebank.dataOperation.module.UserModule.update(UserModule.java:74)

at dccb.ebank.dataOperation.module.UserModule$FM$update$6529ba3002a83603241ee38dfd3a2d89.invoke(UserModule.java)

at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:38)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)

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:44)

at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)

at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)

at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)

at org.nutz.mvc.WhaleFilter.doFilter(WhaleFilter.java:171)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)

at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:214)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1711)

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1347)

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1678)

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1249)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)

at org.eclipse.jetty.server.Server.handle(Server.java:505)

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)

at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)

at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)

at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)

at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:781)

at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:917)

at java.lang.Thread.run(Thread.java:745)

[DEBUG] 12:40:06.230 org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:28) - time=6ms, sql=UPDATE t_user SET name='张丽',age=22,location=NULL WHERe id=4

[WARN ] 12:40:06.230 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) - Error@/user/update :

org.nutz.dao.DaoException: !Nutz SQL Error: 'UPDATE t_user SET name='张丽',age=22,location=NULL WHERe id=4'

PreparedStatement:

'UPDATE t_user SET name=?,age=?,location=? WHERe id=?'

CaseMessage=Table 'ds_0.t_user_0' doesn't exist

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:110)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)

at org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:23)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)

at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:163)

at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:130)

at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:97)

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:86)

at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:242)

at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:254)

at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:58)

at org.nutz.dao.impl.NutDao.update(NutDao.java:275)

at dccb.ebank.dataOperation.module.UserModule.update(UserModule.java:74)

at dccb.ebank.dataOperation.module.UserModule$FM$update$6529ba3002a83603241ee38dfd3a2d89.invoke(UserModule.java)

at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:38)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)

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:44)

at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)

at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)

at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)

at org.nutz.mvc.WhaleFilter.doFilter(WhaleFilter.java:171)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)

at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:214)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1711)

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1347)

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1678)

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1249)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)

at org.eclipse.jetty.server.Server.handle(Server.java:505)

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)

at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)

at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)

at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)

at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:781)

at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:917)

at java.lang.Thread.run(Thread.java:745)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ds_0.t_user_0' doesn't exist

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.Util.getInstance(Util.java:408)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)

at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)

at io.shardingjdbc.core.executor.type.prepared.PreparedStatementExecutor$3.execute(PreparedStatementExecutor.java:101)

at io.shardingjdbc.core.executor.type.prepared.PreparedStatementExecutor$3.execute(PreparedStatementExecutor.java:97)

at io.shardingjdbc.core.executor.ExecutorEngine.executeInternal(ExecutorEngine.java:187)

at io.shardingjdbc.core.executor.ExecutorEngine.syncExecute(ExecutorEngine.java:167)

at io.shardingjdbc.core.executor.ExecutorEngine.execute(ExecutorEngine.java:131)

at io.shardingjdbc.core.executor.ExecutorEngine.executePreparedStatement(ExecutorEngine.java:98)

at io.shardingjdbc.core.executor.type.prepared.PreparedStatementExecutor.execute(PreparedStatementExecutor.java:97)

at io.shardingjdbc.core.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:141)

at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:311)

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)

... 67 more

[DEBUG] 12:40:06.237 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) - Found mapping for [GET] path=/user/query : UserModule.query(UserModule.java:49)

[DEBUG] 12:40:06.238 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:166) - Get 'userModule'

[DEBUG] 12:40:06.238 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:391) - SELECT * FROM t_user ORDER BY id DESC LIMIT 0, 3

[DEBUG] 12:40:06.244 org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:28) - time=6ms, sql=SELECt * FROM t_user ORDER BY id DESC LIMIT 0, 3

[DEBUG] 12:40:06.244 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:391) - SELECt COUNT(*) FROM t_user

[DEBUG] 12:40:06.250 org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:28) - time=6ms, sql=SELECt COUNT(*) FROM t_user

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/954274.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号