WebSphere Application Server - Use of jdbcPass to construct Oracle STRUCT Fails

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Application Server > September 2005 > Use of jdbcPass to construct Oracle STRUCT Fails





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Use of jdbcPass to construct Oracle STRUCT Fails

2005-09-23, 5:57 pm

We are migrating our application from Weblogic to Websphere and I am trying to use the wrapper classes in Websphere to perform some oracle-specific calls. When I try to use jdbcPass to construct an Oracle STRUCT, I get error :

Invocation of the <init> method on the oracle.sql.STRUCT class is not permitted via jdbcPass.


The code I use is:

STRUCT struct = (STRUCT) WSCallHelper.jdbcPass(STRUCT.class, WSCallHelper.CONSTRUCTOR,
new Object[] { descriptor, connection, values},
new Class[] {StructDescriptor.class,
Connection.class,
Object.class},
new int[]{WSCallHelper.IGNORE,
WSCallHelper.CONNECTION,
WSCallHelper.IGNORE});


I have tried this in WAS 5.1.1.6 as well as 6.0 and get the same error. Can anyone point me in the right direction?

Note that same type of call for an ARRAY works fine using:

ARRAY array = (ARRAY) WSCallHelper.jdbcPass(ARRAY.class,
WSCallHelper.CONSTRUCTOR, new Object[] {
descriptor, connection, values},
new Class[] {ArrayDescriptor.class,
Connection.class, Object.class},
new int[]{WSCallHelper.IGNORE,
WSCallHelper.CONNECTION,
WSCallHelper.IGNORE});

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com