Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fail to construct descriptor: Unable to resolve type

240037Dec 31 2003 — edited May 6 2004
I'm receiving an error when creating a oracle.sql.STRUCT or ARRAY. the error is java.sql.SQLException: Fail to construct descriptor: Unable to resolve type "X.NAME".

He is the java code.

// Create the StructDescriptor from the connection
StructDescriptor prStructDesc =
StructDescriptor.createDescriptor("X.NAME", conn);


// construct the object array containing the attribute values for the
// X.NAME object to be inserted
Object[] xObjArray =
{
"val1",
"val2",
...
};

// Construct the Struct from the StructDescriptor and xObjStruct
oracle.sql.STRUCT xStruct = new STRUCT(prStructDesc,
conn, xObjArray);


cs = conn.prepareCall("{ call X.PROC(?,?,?)}");
cs.setObject(1, xStruct);

When I run the code within JDeveloper it runs without any errors. When I deploy to 9iAS release 2 and try to run it there, I receive the error. Thanks for any help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2004
Added on Dec 31 2003
2 comments
4,195 views