Sorry to be going through some of these so late...
I think in this case I would go one step further and suggest using Oracle's
driver built-in connection pooling. Generally, we recommend using
vendor-provided JDBC pooling when available because we hope/expect it to be
more finely tuned than our general purpose JDBC connection pool (which is
mainly there to provide pooling for drivers that don't support the JDBC 2.0
optional extensions).
Scott Stirling
Allaire Corporation
http://www.allaire.com/developer/jrunreferencedesk/
> -----Original Message-----
> From: Jay Walters [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 6:39 AM
> To: JRun-Talk
> Subject: RE: Error While Using VARRAY
>
>
> The JRun connection pooling mechanism is placing a proxy between your
> program and the Oracle connection, there should be a method
> in the JRun API
> that lets you get the 'real' connection from your variable
> conn, and then
> you can do the Oracle specific stuff using that. You'll need
> to look in the
> manuals or online docs to find the method name, sorry I don't
> know it off
> the top of my head.
>
> Cheers
> Jay Walters
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 4:46 AM
> To: JRun-Talk
> Subject: Error While Using VARRAY
>
>
>
>
> Hi All,
>
> I have a Oracle Stored procedure which will return VARRAY.
>
> I am using following script to get the value in to an array.
>
> Connection conn=getDBConn();
>
> ArrayDescriptor ardesc=ArrayDescriptor.createDescriptor(
> "css_config.tst_varray",conn);
> OracleCallableStatement ocs =
> (OracleCallableStatement)conn.prepareCall("begin
> f_test_varray(?);end;");
>
> ocs.registerOutParameter
> (1, OracleTypes.ARRAY,"tst_varray"); //tst_varray name of the
> variable
> of type VARRAY.
> ocs.execute();
>
> oracle.sql.ARRAY array = ocs.getARRAY(1);
>
>
> But at runtime this is giving me
> java.lang.ClassCastException: allaire.jrun.sql.ConnectionProxy
>
>
> Could anybody help me to fix this problem?
>
> Thanks in Advance
>
> Savant
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
