This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman 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 Elasticsearch in Action this week in the Big Data 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
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3739
    
  10

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


[OCA 8 Book] [Blog]
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)
 
 
subject: ArrayDescriptor - SqlException