dcsimg
JBuilder 6 and Oracle trouble
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Piotr_Wocal
Posted On:   Saturday, January 19, 2002 05:17 PM

Hi all, I've just moved to JBuilder 6 from JBuilder5 and have problem. During executing stored procedure by code: ArrayDescriptor desc = ArrayDescriptor.createDescriptor( "IDARRAY", conn ); ARRAY topicIdARRAY = new ARRAY( desc, conn, topicIdArray ); cstmt.setArray( 3, topicIdARRAY ); where idarray is defined as SQL Oracle by: create or replace type idarray as table of number; ARRAY is oracle.sql.ARRAY class from classes12.zip and cstmt is a CallableStatement.java from src.jar I've got error in third line ( cstmt.setArray ( 3, topicIdARRAY ); ) with stack: St   More>>

Hi all,


I've just moved to JBuilder 6 from JBuilder5 and have problem.


During executing stored procedure by code:


ArrayDescriptor desc = ArrayDescriptor.createDescriptor( "IDARRAY", conn );

ARRAY topicIdARRAY = new ARRAY( desc, conn, topicIdArray );

cstmt.setArray( 3, topicIdARRAY );



where idarray is defined as SQL Oracle
by:

create or replace type idarray as table of number;

ARRAY is oracle.sql.ARRAY class from classes12.zip and cstmt is a CallableStatement.java from src.jar


I've got error in third line ( cstmt.setArray ( 3, topicIdARRAY ); )
with stack:

StandardWrapperValve[hfserver]: Servlet.service() for servlet hfserver threw exception javax.servlet.ServletException: Servlet execution threw an exception javax.servlet.ServletException: Servlet execution threw an exception at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106) at java.lang.Thread.run(Thread.java:484)
I didn't have such problem for JBuilder5.


Does anybody know how to overcome it ??

   <<Less
About | Sitemap | Contact