操作数据库,遇到“索引中丢失  IN 或 OUT 参数:: 1”问题

使用dao层操作数据库时,出现如下错误,主要是“索引中丢失 IN 或 OUT 参数:: 1”,查看sql语句 是简单的插入语句,?与插入字段也是一一对应,后来讲过检查发现,是在dao层传参数时,参数字段没有添加进去,参数为空导致!希望出现同样错误的,可以先查查入参,然后在看看sql语句!

索引中丢失  IN 或 OUT 参数:: 1
语句:insert into MOBILE_SKB_USER_QUESTION (uuid,qsuuid,yhuuid) VALUES(?,?,?)
本次请求会话ID:0f1e12e2424e4a2b95dc4a7b7578c327
当前应用服务器:myserver_zxg
本次请求经过的应用服务器:
  myserver_zxg
当前服务器执行耗时(ms):9883
简要异常堆栈信息:
  at com.css.sword.persistence.database.handler.SwordPreparedStatement.executeUpdate(SwordPreparedStatement.java:96)
  at com.css.sword.persistence.dao.SwordPersistSession.executeUpdate(SwordPersistSession.java:312)
  at com.css.sword.persistence.dao.PersistenceDAO.executeByKey(PersistenceDAO.java:248)
  at com.css.sword.kernel.utils.SwordServiceUtils.callLocalServiceByServiceContainer(SwordServiceUtils.java:449)
  at com.css.sword.kernel.platform.component.service.LocalInvocationSender.send(LocalInvocationSender.java:48)
  at com.css.sword.kernel.platform.component.service.LocalInvocationSender.send(LocalInvocationSender.java:55)
  at com.css.sword.kernel.utils.SwordServiceUtils.callServiceByProtocolID(SwordServiceUtils.java:225)
  at com.css.sword.kernel.utils.SwordServiceUtils.callService(SwordServiceUtils.java:168)
  at com.css.sword.platform.web.controller.DoController._fc01fa5551af436dac0b44d0f3a5a063_(DoController.java:65)
  at com.css.sword.platform.web.controller.DoController.execute(DoController.java:-1)
  at com.css.sword.platform.web.servlet.Sword._15fba8320e154ccc816b10eede667e1d_(Sword.java:495)
  at com.css.sword.platform.web.servlet.Sword.doCtrl(Sword.java:-1)
  at com.css.sword.platform.web.servlet.Sword._0e8087dab8d142b995df20b7c831cd0e_(Sword.java:428)
  at com.css.sword.platform.web.servlet.Sword.doDelegate(Sword.java:-1)
  at com.css.sword.platform.web.servlet.Sword._05b21e73a0824df1bdc2784684919993_(Sword.java:246)
  at com.css.sword.platform.web.servlet.Sword.service(Sword.java:-1)
  at com.css.sword.platform.web.comm.CharacterEncodingFilter._73f2934882414f9abe8c0e1fcfc09338_(CharacterEncodingFilter.java:52)
  at com.css.sword.platform.web.comm.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:-1)
完整异常堆栈信息:
  at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
  at com.css.sword.persistence.database.handler.SwordPreparedStatement.executeUpdate(SwordPreparedStatement.java:96)
  at com.css.sword.persistence.dao.SwordPersistSession.executeUpdate(SwordPersistSession.java:312)
  at com.css.sword.persistence.dao.PersistenceDAO.executeByKey(PersistenceDAO.java:248)
  at sword.mobile.dao.MobileQuestionReleaseDao.questionRelease(MobileQuestionReleaseDao.java:49)
  at sword.mobile.service.MobileQuestionReleaseService.questionRelease(MobileQuestionReleaseService.java:35)
  at sword.mobile.service.MobileQuestionReleaseService$$469713290260516.callService(null:7)
  at com.css.sword.kernel.utils.SwordServiceUtils.callLocalServiceByServiceContainer(SwordServiceUtils.java:449)
  at com.css.sword.kernel.platform.component.service.LocalInvocationSender.send(LocalInvocationSender.java:48)
  at com.css.sword.kernel.platform.component.service.LocalInvocationSender.send(LocalInvocationSender.java:55)
  at com.css.sword.kernel.utils.SwordServiceUtils.callServiceByProtocolID(SwordServiceUtils.java:225)
  at com.css.sword.kernel.utils.SwordServiceUtils.callService(SwordServiceUtils.java:168)
  at sword.mobile.web.MobileQuestionReleaseCtrl.questionRelease(MobileQuestionReleaseCtrl.java:67)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at com.css.sword.platform.web.controller.DoController._fc01fa5551af436dac0b44d0f3a5a063_(DoController.java:65)
  at com.css.sword.platform.web.controller.DoController.execute(DoController.java:-1)
  at com.css.sword.platform.web.servlet.Sword._15fba8320e154ccc816b10eede667e1d_(Sword.java:495)
  at com.css.sword.platform.web.servlet.Sword.doCtrl(Sword.java:-1)
  at com.css.sword.platform.web.servlet.Sword._0e8087dab8d142b995df20b7c831cd0e_(Sword.java:428)
  at com.css.sword.platform.web.servlet.Sword.doDelegate(Sword.java:-1)
  at com.css.sword.platform.web.servlet.Sword._05b21e73a0824df1bdc2784684919993_(Sword.java:246)
  at com.css.sword.platform.web.servlet.Sword.service(Sword.java:-1)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.css.sword.platform.web.comm.CharacterEncodingFilter._73f2934882414f9abe8c0e1fcfc09338_(CharacterEncodingFilter.java:52)
  at com.css.sword.platform.web.comm.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:-1)
  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:220)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
  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:745)
14:16:52,480 DEBUG [DBTracer] 会话ID:0f1e12e2424e4a2b95dc4a7b7578c327:60:1: 回滚会话0f1e12e2424e4a2b95dc4a7b7578c327的数据源sworddev的数据库连接1646744863的事务
14:16:52,503 DEBUG [DBTracer] 会话ID:0f1e12e2424e4a2b95dc4a7b7578c327:60:1: 会话0f1e12e2424e4a2b95dc4a7b7578c327的数据库连接1646744863的事务成功回滚
14:16:52,503 DEBUG [DBTracer] 会话ID:0f1e12e2424e4a2b95dc4a7b7578c327:60:1: 关闭会话0f1e12e2424e4a2b95dc4a7b7578c327的数据源sworddev的数据库连接1646744863
14:16:52,503 DEBUG [DBTracer] 会话ID:0f1e12e2424e4a2b95dc4a7b7578c327:60:1: 成功关闭数据源sworddev的数据库连接1646744863
14:16:52,503 ERROR [Sword] 会话ID:0f1e12e2424e4a2b95dc4a7b7578c327:60:1:0
java.lang.RuntimeException: 执行类[MobileQuestionReleaseCtrl]的方法[questionRelease]时出错
    at com.css.sword.platform.web.controller.DoController._fc01fa5551af436dac0b44d0f3a5a063_(DoController.java:90)
    at com.css.sword.platform.web.controller.DoController.execute(DoController.java)
    at com.css.sword.platform.web.servlet.Sword._15fba8320e154ccc816b10eede667e1d_(Sword.java:495)
    at com.css.sword.platform.web.servlet.Sword.doCtrl(Sword.java)
    at com.css.sword.platform.web.servlet.Sword._0e8087dab8d142b995df20b7c831cd0e_(Sword.java:428)
    at com.css.sword.platform.web.servlet.Sword.doDelegate(Sword.java)
    at com.css.sword.platform.web.servlet.Sword._05b21e73a0824df1bdc2784684919993_(Sword.java:246)
    at com.css.sword.platform.web.servlet.Sword.service(Sword.java)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.css.sword.platform.web.comm.CharacterEncodingFilter._73f2934882414f9abe8c0e1fcfc09338_(CharacterEncodingFilter.java:52)
    at com.css.sword.platform.web.comm.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java)
    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:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
    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:745)
Caused by: com.css.sword.persistence.database.handler.SwordSQLException: 1019900000001
    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
    at com.css.sword.persistence.database.handler.SwordPreparedStatement.executeUpdate(SwordPreparedStatement.java:96)
    at com.css.sword.persistence.dao.SwordPersistSession.executeUpdate(SwordPersistSession.java:312)
    at com.css.sword.persistence.dao.PersistenceDAO.executeByKey(PersistenceDAO.java:248)
    at sword.mobile.dao.MobileQuestionReleaseDao.questionRelease(MobileQuestionReleaseDao.java:49)
    at sword.mobile.service.MobileQuestionReleaseService.questionRelease(MobileQuestionReleaseService.java:35)
    at sword.mobile.service.MobileQuestionReleaseService$$469713290260516.callService(Unknown Source)
    at com.css.sword.kernel.utils.SwordServiceUtils.callLocalServiceByServiceContainer(SwordServiceUtils.java:449)
    at com.css.sword.kernel.platform.component.service.LocalInvocationSender.send(LocalInvocationSender.java:48)
    at com.css.sword.kernel.platform.component.service.LocalInvocationSender.send(LocalInvocationSender.java:55)
    at com.css.sword.kernel.utils.SwordServiceUtils.callServiceByProtocolID(SwordServiceUtils.java:225)
    at com.css.sword.kernel.utils.SwordServiceUtils.callService(SwordServiceUtils.java:168)
    at sword.mobile.web.MobileQuestionReleaseCtrl.questionRelease(MobileQuestionReleaseCtrl.java:67)
    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:606)
    at com.css.sword.platform.web.controller.DoController._fc01fa5551af436dac0b44d0f3a5a063_(DoController.java:65)
    ... 31 more
14:16:52,506 DEBUG [SwordDataSet] 会话ID:0f1e12e2424e4a2b95dc4a7b7578c327:60:1:初始化ResDataObject。
14:16:52,506 DEBUG [DataBuilder] 会话ID:0f1e12e2424e4a2b95dc4a7b7578c327:60:1:JsonString:{"debugMes":"com.css.sword.persistence.database.handler.SwordSQLException: 1019900000001\r\nPS-03007:通过数据源sworddev执行数据库操作时发生错误!\n索引中丢失  IN 或 OUT 参数:: 1\n语句:insert into MOBILE_SKB_USER_QUESTION (uuid,qsuuid,yhuuid) VALUES(?,?,?)\r\n本次请求会话ID:0f1e12e2424e4a2b95dc4a7b7578c327\r\n当前应用服务器:myserver_zxg\r\n本次请求经过的应用服务器:\r\n  myserver_zxg\r\n当前服务器执行耗时(ms):9883\r\n简要异常堆栈信息:\r\n  at 

 

 

 

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值