执行INSERT的时候 会出现SQL列索引无效
但是这个问题一定很常见
我把SQL拿到plsql中执行没有问题
把sql参数写成固定值 还是是列索引无效
由此可见不是SQL本身问题
各位有没有对这个异常 有一定深度的理解
能指出问题的根源在哪??
但是这个问题一定很常见
我把SQL拿到plsql中执行没有问题
把sql参数写成固定值 还是是列索引无效
由此可见不是SQL本身问题
各位有没有对这个异常 有一定深度的理解
能指出问题的根源在哪??
解决方案 »
- 求助ORA-03113: end-of-file on communication channel
- TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
- 【求救,100分悬赏】Oracle生成单位(org)、部门(dept)混合树结构
- 求一条sql语句
- 安装完oracle,不知道怎么连接数据库
- 这样的字符串应该怎样截取,想炸了脑子...
- 请教ORACLE9.2安装
- 继续问:oracle安装,烦死人了
- 在安装到100%的时候弹出启动服务出错。。怎么办。。急。。。
- Oracle中怎样用存储过程将一段字符串以逗号为界截取,并将得到的子串存到另一张表中
- 请教高手怎么写这样一条sql
- Oracle存储过程报错,求助
重新建立索引,试一下了。
这应该能保障DB的结构没有问题
回2楼 重复数据也是不可能的 因为不是这个错而且 update的时候也是同样问题 放到plsql中直接执行就没问题
异常如下
Exception in thread "main" org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQLで例外(SQL=[], Message=[列索引が無効です。], ErrorCode=17003, SQLState=null)が発生しました
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:212)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:184)
at jp.co.tradewin.comet.framework.dao.oracle.CometSelectDynamicCommand.execute(CometSelectDynamicCommand.java:66)
at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)
at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:71)
at jp.co.tradewin.comet.dao.VSbiDummyDao$$EnhancedByS2AOP$$15ad5c6$$MethodInvocation$$foreignStockOrderIkoInsert3.proceed(MethodInvocationClassGenerator.java)
at jp.co.tradewin.comet.dao.VSbiDummyDao$$EnhancedByS2AOP$$15ad5c6.foreignStockOrderIkoInsert(VSbiDummyDao$$EnhancedByS2AOP$$15ad5c6.java)
at jp.co.tradewin.comet.helper.impl.ForeignStockOrderIkoFetchHelperImpl.insert(ForeignStockOrderIkoFetchHelperImpl.java:58)
at jp.co.tradewin.comet.helper.impl.ForeignStockOrderIkoFetchHelperImpl.execute(ForeignStockOrderIkoFetchHelperImpl.java:43)
at jp.co.tradewin.comet.helper.impl.ForeignStockOrderIkoFetchHelperImpl$$EnhancedByS2AOP$$179dce4.$$execute$$invokeSuperMethod$$(ForeignStockOrderIkoFetchHelperImpl$$EnhancedByS2AOP$$179dce4.java)
at jp.co.tradewin.comet.helper.impl.ForeignStockOrderIkoFetchHelperImpl$$EnhancedByS2AOP$$179dce4$$MethodInvocation$$execute0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.requiresNew(JTATransactionManagerAdapter.java:79)
at org.seasar.extension.tx.RequiresNewInterceptor.invoke(RequiresNewInterceptor.java:49)
at jp.co.tradewin.comet.helper.impl.ForeignStockOrderIkoFetchHelperImpl$$EnhancedByS2AOP$$179dce4$$MethodInvocation$$execute0.proceed(MethodInvocationClassGenerator.java)
at jp.co.tradewin.comet.helper.impl.ForeignStockOrderIkoFetchHelperImpl$$EnhancedByS2AOP$$179dce4.execute(ForeignStockOrderIkoFetchHelperImpl$$EnhancedByS2AOP$$179dce4.java)
at jp.co.tradewin.comet.helper.impl.ForeignStockOrderIkoFetchHelperImpl.execute(ForeignStockOrderIkoFetchHelperImpl.java:1)
at org.seasar.dao.tiger.impl.FetchDtoMetaDataResultSetHandler.handle(FetchDtoMetaDataResultSetHandler.java:65)
at org.seasar.dao.tiger.impl.FetchResultSetHandler.handle(FetchResultSetHandler.java:63)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:258)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:210)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:184)
at jp.co.tradewin.comet.framework.dao.oracle.CometSelectDynamicCommand.execute(CometSelectDynamicCommand.java:66)
at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)
at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:71)
at jp.co.tradewin.comet.dao.VSbiDummyDao$$EnhancedByS2AOP$$15ad5c6$$MethodInvocation$$foreignStockOrderIkoSelect0.proceed(MethodInvocationClassGenerator.java)
at jp.co.tradewin.comet.dao.VSbiDummyDao$$EnhancedByS2AOP$$15ad5c6.foreignStockOrderIkoSelect(VSbiDummyDao$$EnhancedByS2AOP$$15ad5c6.java)
at jp.co.tradewin.comet.service.impl.ForeignStockOrderIkoServiceImpl.execute(ForeignStockOrderIkoServiceImpl.java:32)
at jp.co.tradewin.comet.service.impl.ForeignStockOrderIkoServiceImpl$$EnhancedByS2AOP$$1bf3d87.$$execute$$invokeSuperMethod$$(ForeignStockOrderIkoServiceImpl$$EnhancedByS2AOP$$1bf3d87.java)
at jp.co.tradewin.comet.service.impl.ForeignStockOrderIkoServiceImpl$$EnhancedByS2AOP$$1bf3d87$$MethodInvocation$$execute0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)
at jp.co.tradewin.comet.service.impl.ForeignStockOrderIkoServiceImpl$$EnhancedByS2AOP$$1bf3d87$$MethodInvocation$$execute0.proceed(MethodInvocationClassGenerator.java)
at jp.co.tradewin.comet.service.impl.ForeignStockOrderIkoServiceImpl$$EnhancedByS2AOP$$1bf3d87.execute(ForeignStockOrderIkoServiceImpl$$EnhancedByS2AOP$$1bf3d87.java)
at jp.co.tradewin.comet.main.ForeignStockOrderIkoMain.main(ForeignStockOrderIkoMain.java:38)
Caused by: java.sql.SQLException: 列索引が無効です。
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:897)
at org.seasar.extension.jdbc.types.IntegerType.getValue(IntegerType.java:44)
at org.seasar.dao.impl.ObjectResultSetHandler.handle(ObjectResultSetHandler.java:46)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:258)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:210)
... 35 more
但都是浮云 证明不了
诶。