File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ArrayDescriptor - SqlException

 
Arulanand Dayalan
Ranch Hand
Posts: 126
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3894
16
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ArrayDescriptor are not JDBC, its specific to Oracle so moving this to the Oracle forum..
 
Sunil Vasudevan
Ranch Hand
Posts: 107
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...
 
sri ni
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic