Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ArrayDescriptor createDescriptor error

588267Jul 2 2009 — edited Oct 15 2014
Hello. I am trying to pass an array to a pl/sql procedure.
I am using jDeveloper 10.1.3.3

Here is the code I am trying to execute:

InitialContext ctx = new InitialContext();
DataSource ds= (DataSource) ctx.lookup ("jdbc/EBIDS");
Connection con;
con = ds.getConnection(username, password);

ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor("HZOPPETT.TEST_ARRAY_TYPE", con);
...

And in the database I have created this object:

CREATE OR REPLACE TYPE HZOPPETT.TEST_ARRAY_TYPE as varray(30) OF NUMBER;

However, when I run this code I get the following error and am not sure how to proceed:

<H1>500 Internal Server Error</H1><PRE>java.lang.IllegalAccessError: tried to access field oracle.sql.TypeDescriptor.m_conn from class oracle.sql.ArrayDescriptor<br> at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1299)<br> at oracle.sql.ArrayDescriptor.&lt;init&gt;(ArrayDescriptor.java:156)<br> at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:113)<br> at servlets.heatherTest._jspService(_heatherTest.java:76)<br> [servlets/heatherTest.jsp]<br> at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.3.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)<br> at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)<br> at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)<br> at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)<br> at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)<br> at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)<br> at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)<br> at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)<br> at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)<br> at java.lang.Thread.run(Thread.java:595)<br></PRE>

Any ideas?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2009
Added on Jul 2 2009
2 comments
3,039 views