This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes BEA/Weblogic and the fly likes cannot create oracle.sql.ArrayDescriptor  using connection from weblogice datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "cannot create oracle.sql.ArrayDescriptor  using connection from weblogice datasource" Watch "cannot create oracle.sql.ArrayDescriptor  using connection from weblogice datasource" New topic
Author

cannot create oracle.sql.ArrayDescriptor using connection from weblogice datasource

hongwei wang
Greenhorn

Joined: Oct 22, 2004
Posts: 2
Hi,

I want to create a Oracle ARRAY passed to the oracle stored procedure, which will return me the result.

If I directly create connection as follows:

String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
......
....
connection = DriverManager.getConnection(url, username, password);

Then I use this connection to create ArrayDescriptor instance as follows, no problem.


oracle.sql.ArrayDescriptor arraydesc
= oracle.sql.ArrayDescriptor.createDescriptor("FIELDIDARRAY", connection);

oracle.sql.ARRAY oracleArray = new ARRAY(arraydesc, connection, elements);


But I retrieve the connection from weblogic server DataSource configed using the exactly same parameter, but cannot create oracle ArrayDescriptor
and oracle.sql.ARRAY instances, I got following errors:

Fail to construct descriptor: Unable to resolve type: "UUM.FIELDIDARRAY"
where UUM is database schema name. I checked the database, we have FIELDIDARRAY object defined in Oracle under this schema.

Would someone help me out about this issue?
[ October 22, 2004: Message edited by: hongwei wang ]
Scott Dunbar
Ranch Hand

Joined: Sep 23, 2004
Posts: 245
You're trying to use an Oracle proprietary extension. There is no way that WLS or anything else can support that in a way that would work with every driver. You'll have to do it like you are doing it to use Oracle arrays.


<a href="http://forums.hotjoe.com/forums/list.page" target="_blank" rel="nofollow">Java forums using Java software</a> - Come and help get them started.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: cannot create oracle.sql.ArrayDescriptor using connection from weblogice datasource
 
Similar Threads
Class Cast exception in oracle.sql.ArrayDescriptor
Array objects using connection pooling in WebSphere
Calling a stored procedure with an ARRAY
Non supported character set: oracle-character-set-178
Oracle Array objects using connection pooling in Websphere