aspose file tools*
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
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: 3716
    
    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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ArrayDescriptor - SqlException