This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes ArrayDescriptor - SqlException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ArrayDescriptor - SqlException" Watch "ArrayDescriptor - SqlException" New topic
Author

ArrayDescriptor - SqlException

Arulanand Dayalan
Ranch Hand

Joined: Aug 10, 2005
Posts: 124
Hi,

I am struck with this issue.I am creating an ArrayDescriptor,
ArrayDescriptor objArrDesc = ArrayDescriptor.createDescriptor("PRD_SGMN", con);
i am getting the following exception.Has anyone come across it?


java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: "TEST.PRD_SGMN"
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1776)
at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:272)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:196)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:165)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:150)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:115)

Thanks in Advance.

Regards,
Arul.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

ArrayDescriptor are not JDBC, its specific to Oracle so moving this to the Oracle forum..


My Blog: Down Home Country Coding with Scott Selikoff
Sunil Vasudevan
Ranch Hand

Joined: Mar 05, 2007
Posts: 107
Run the following SQL on your Oracle database:
desc PRD_SGMN;

If it returns "ERROR: object PRD_SGMN does not exist", then you do not have this user defined type created in Oracle database. It is then a database issue rather than a java code issue.

Let me know what you find...


Sunil.V<br />SCJP2, SCWCD1.4, SCBCD1.3
sri ni
Greenhorn

Joined: Jul 09, 2008
Posts: 2
I am facing same problem. when I do a desc <object>, I get the output correctly.

but I still get below exception
Exception in thread "main" java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: "SMSREQ.ACTIONPRIORITY"
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: ArrayDescriptor - SqlException
 
Similar Threads
SQLXML problem
classcast exception only with websphere server not for weblogic
trouble passing array to stored procedure in spring HELP
passing arrays to oracle
Getting array of Oracle Objects