File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem while accesing collection from stored procedure using Oracle10g

 
phani babu
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
java.sql.SQLException: Internal Error
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.oracore.OracleTypeCOLLECTION.initCollElemTypeName(OracleT
ypeCOLLECTION.java:1074)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType(OracleTypeC
OLLECTION.java:1107)
at oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:
81)
at oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:
68)
at oracle.sql.TypeDescriptor.initSQLName(TypeDescriptor.java:238)
at oracle.sql.TypeDescriptor.getName(TypeDescriptor.java:199)
at oracle.sql.StructDescriptor.getClass(StructDescriptor.java:1105)
at oracle.sql.STRUCT.toJdbc(STRUCT.java:575)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT(OracleTypeUPT.java:50
2)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec(OracleTypeUPT.java:45
6)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBodyElements(Or
acleTypeCOLLECTION.java:1011)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBody(OracleType
COLLECTION.java:952)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81(OracleTypeCOLLECT
ION.java:764)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearizeInternal(OracleTy
peCOLLECTION.java:243)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearize(OracleTypeCOLLEC
TION.java:217)
at oracle.sql.ArrayDescriptor.toJavaArray(ArrayDescriptor.java:891)
at oracle.sql.ARRAY.getArray(ARRAY.java:315)
at weblogic.jdbc.wrapper.Array_oracle_sql_ARRAY.getArray(Unknown Source)

at com.bt.ngn.dao.InventoryDao.searchInventory(Unknown Source)
at com.bt.ngn.ejb.TAPSLBean.searchInventory(Unknown Source)
at com.bt.ngn.ejb.TAPSLBean_lljdz4_EOImpl.searchInventory(TAPSLBean_lljd
z4_EOImpl.java:670)
at com.bt.ngn.ejb.TAPSLBean_lljdz4_EOImpl_CBV.searchInventory(Unknown So
urce)
at com.bt.ngn.util.TAPDelegate.searchInventory(Unknown Source)
at com.bt.ngn.action.LoadSearchInventory.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:480)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:142
0)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:520)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:6452)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
root; 2007-09-08 12:04:54,824; ERROR; [TAPDao]; SQLException in getSessionHistor
yDetails (TAPSLDao) :Internal Error
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.RangeCheck(ArrayList.java:507)
at java.util.ArrayList.get(ArrayList.java:324)
at com.bt.ngn.action.LoadSearchInventory.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:480)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:142
0)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:520)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:6452)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
 
Srikanth Basa
Ranch Hand
Posts: 241
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hard to say without looking at your code
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic