This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
hongwei wang
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 245
  • 0
  • 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