hongwei wang

Greenhorn
+ Follow
since Oct 22, 2004
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by hongwei wang

final is allowed for the object reference as the variable in the class
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 ]
19 years ago