Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

hongwei wang
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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";
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
Posts: 245
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!