org.apache.openjpa.persistence.PersistenceException: The index 0 is out of range. FailedObject: select c.xyz, ev.abc, ev.def, ctc.ghi from Test c inner join EKView ev on c.ekid = ev.ekid inner join CTypeCode ctc on c.CType = ctc.CType where c.PID = ? and csc.ShortName = 'FOUND' and c.OrgID = 100 and CONVERT(DATE, ?) <= CONVERT(date,c.EndDate) order by c.EffDate desc [java.lang.String]

Stack Overflow | Simal | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    OpenJPA 2.0 : The index 0 is out of range error

    Stack Overflow | 8 months ago | Simal
    org.apache.openjpa.persistence.PersistenceException: The index 0 is out of range. FailedObject: select c.xyz, ev.abc, ev.def, ctc.ghi from Test c inner join EKView ev on c.ekid = ev.ekid inner join CTypeCode ctc on c.CType = ctc.CType where c.PID = ? and csc.ShortName = 'FOUND' and c.OrgID = 100 and CONVERT(DATE, ?) <= CONVERT(date,c.EndDate) order by c.EffDate desc [java.lang.String]
  2. 0

    Using Resultset in Java Program

    Stack Overflow | 7 years ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The result set has no current row.
  3. 0

    Hibernate Community • View topic - Trouble Loading a collection

    hibernate.org | 2 years ago
    org.hibernate.exception.GenericJDBCException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using Resultset in Java Program

    xluat.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The result set has no current row.
  6. 0

    Resultset y una funcion sql server 2005 (java)

    chuidiang.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: El conjunto de resultados no ti ene fila actual.
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    The index 0 is out of range.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError()
  2. com.microsoft.sqlserver
    SQLServerResultSet.getInt
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
    2. com.microsoft.sqlserver.jdbc.SQLServerResultSet.verifyValidColumnIndex(SQLServerResultSet.java:531)
    3. com.microsoft.sqlserver.jdbc.SQLServerResultSet.getterGetColumn(SQLServerResultSet.java:2049)
    4. com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082)
    5. com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067)
    6. com.microsoft.sqlserver.jdbc.SQLServerResultSet.getInt(SQLServerResultSet.java:2310)
    6 frames
  3. OpenJPA Aggregate Jar
    JDBCStoreManager.load
    1. org.apache.openjpa.lib.jdbc.DelegatingResultSet.getInt(DelegatingResultSet.java:159)
    2. org.apache.openjpa.jdbc.sql.DBDictionary.getInt(DBDictionary.java:837)
    3. org.apache.openjpa.jdbc.sql.ResultSetResult.getIntInternal(ResultSetResult.java:336)
    4. org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:389)
    5. org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
    6. org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.getObjectInternal(MappedQueryResultObjectProvider.java:419)
    7. org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
    8. org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:305)
    9. org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:188)
    10. org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:147)
    11. org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1031)
    11 frames
  4. com.ibm.ws
    WsJpaJDBCStoreManager.load
    1. com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:112)
    1 frame
  5. OpenJPA Aggregate Jar
    QueryImpl.getResultList
    1. org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.load(MappedQueryResultObjectProvider.java:191)
    2. org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.load(MappedQueryResultObjectProvider.java:180)
    3. org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.load(MappedQueryResultObjectProvider.java:171)
    4. org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider.getResultObject(MappedQueryResultObjectProvider.java:99)
    5. org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36)
    6. org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
    7. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
    8. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
    9. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
    10. org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
    11. org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:315)
    12. org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:331)
    12 frames
  6. org.abpeds.moc
    PersonNamedNativeQueryTest.testCurrentRawCertSame
    1. org.abpeds.moc.persistence.test.PersonNamedNativeQueryTest.testCurrentRawCertSame(PersonNamedNativeQueryTest.java:447)
    1 frame
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    4. java.lang.reflect.Method.invoke(Method.java:611)
    4 frames
  8. JUnit
    ParentRunner.run
    1. org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    2. org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    3. org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    4. org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    5. org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    6. org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    7. org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    8. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    9. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    10. org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    11. org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    12. org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    13. org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    14. org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    15. org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    16. org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    17. org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    17 frames
  9. JUnit4 Runner
    JUnit4TestReference.run
    1. org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49)
    1 frame
  10. JUnit3 Runner
    RemoteTestRunner.main
    1. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
    5 frames