This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes ArrayDescriptor -- sql exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ArrayDescriptor -- sql exception" Watch "ArrayDescriptor -- sql exception" New topic

ArrayDescriptor -- sql exception

sri ni

Joined: Jul 09, 2008
Posts: 2

I am trying to pass object to stored procedure. I get the below error.

Can any one provide your feedback please?

Exception in thread "main" java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: ".ACTIONPRIORITY"
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.sql.ArrayDescriptor.initPickler(
at oracle.sql.ArrayDescriptor.<init>(
at com.inf.db.DAO613.insertService(
at com.inf.ui.CM613.main(

code in the database:

create or replace TYPE ActionPriority AS OBJECT
Action_id NUMBER,
Priority NUMBER
create public synonym ACTIONPRIORITY for ActionPriority;

create or replace procedure testproc
ap ActionPriority

I can see the description of object in database

SQL> desc ActionPriority
Name Null? Type
----------------------------------------- -------- ----------------------------



I am calling stored procedure from standard JAVA application.
database : oracle 10G

I have oracle 10G classes12.jar, ojdbc14.jar in class path.

JAVA code:

oracle.sql.ArrayDescriptor desc = new oracle.sql.ArrayDescriptor("ACTIONPRIORITY",con);
I agree. Here's the link:
subject: ArrayDescriptor -- sql exception
It's not a secret anymore!