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]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by Simal
, 1 year ago
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]
via Stack Overflow by Vishal Nadikudi
, 2 years ago
The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 32 seconds BEA1-00003CA049AA50DAD185]'. No further JDBC access is allowed within this transaction.
via Stack Overflow by veote
, 2 years ago
DSRA9500E: Negative values are not allowed for fetch size. FailedObject: SELECT u FROM user_table u WHERE lower(u.username) = lower(:name) [java.lang.String]
via james-server-user by raghunath.umapathi@xyramsoft.com, 1 year ago
The column index is out of range: 2, number of columns: 1. FailedObject: SELECT rrt FROM JamesRecipientRewrite rrt WHERE (rrt.user LIKE :user OR rrt.user='*') and (rrt.domain like :domain or rrt.domain='*') ORDER BY rrt.domain DESC [java.lang.String]
via james-server-user by Eric Charles, 1 year ago
The column index is out of range: 2, number of columns: 1. FailedObject: SELECT rrt FROM JamesRecipientRewrite rrt WHERE (rrt.user LIKE :user OR rrt.user='*') and (rrt.domain like :domain or rrt.domain='*') ORDER BY rrt.domain DESC [java.lang.String]
via nabble.com by Unknown author, 2 years ago
ORA-00936: missing expression {prepstmnt 328799129 SELECT t0.ID, t1.EXPORT_ORDER_ID, t1.VM_ID, t2.ID, t2.NAME     FROM INFOP_SYSTEM.EXPORT_ORDER t0,         INFOP_SYSTEM.EXPORT_ORDER_VM t1,         INFOP_SYSTEM.EXPORT_ORDER t2     WHERE (t0.ID
com.microsoft.sqlserver.jdbc.SQLServerException: The index 0 is out of range.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.verifyValidColumnIndex(SQLServerResultSet.java:531)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getterGetColumn(SQLServerResultSet.java:2049)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getInt(SQLServerResultSet.java:2310)
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getInt(DelegatingResultSet.java:159)
at org.apache.openjpa.jdbc.sql.DBDictionary.getInt(DBDictionary.java:837)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getIntInternal(ResultSetResult.java:336)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:389)
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
at org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.getObjectInternal(MappedQueryResultObjectProvider.java:419)
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
at org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy.getPrimaryKeyValue(PrimitiveFieldStrategy.java:305)
at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:188)
at org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:147)
at com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:112)
at org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.load(MappedQueryResultObjectProvider.java:191)
at org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.load(MappedQueryResultObjectProvider.java:180)
at org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider$MappingResult.load(MappedQueryResultObjectProvider.java:171)
at org.apache.openjpa.jdbc.kernel.MappedQueryResultObjectProvider.getResultObject(MappedQueryResultObjectProvider.java:99)
at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:36)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:315)
at org.abpeds.moc.persistence.test.PersonNamedNativeQueryTest.testCurrentRawCertSame(PersonNamedNativeQueryTest.java:447)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

Users with the same issue

4 times, 1 month ago
Once, 3 months ago
6 times, 5 months ago
4 times, 6 months ago
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.