ArrayDescriptor createDescriptor error
588267Jul 2 2009 — edited Oct 15 2014Hello. 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.<init>(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?