permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes ArrayDescriptor Urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ArrayDescriptor Urgent" Watch "ArrayDescriptor Urgent" New topic
Author

ArrayDescriptor Urgent

Mazen Mahmoud
Greenhorn

Joined: Oct 25, 2007
Posts: 20
I've created oracle object on database (for ex XTYPE)(contaning varchar2, timestamp and blob) and a varray XARRAY of XTYPE. From the java code (which is 100% correct), when i run the application, i'm receiving the following error:

java.sql.SQLException: Undefined Type: get_next_type
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
at oracle.jdbc.oracore.OracleTypeADT.getNextTypeObject(OracleTypeADT.java:1262)
at oracle.jdbc.oracore.OracleTypeADT.parseTDSrec(OracleTypeADT.java:873)
at oracle.jdbc.oracore.OracleTypeADT.parseTDS(OracleTypeADT.java:808)
at oracle.jdbc.oracore.OracleTypeADT.applyTDSpatches(OracleTypeADT.java:954)
at oracle.jdbc.oracore.OracleTypeADT.parseTDSrec(OracleTypeADT.java:882)
at oracle.jdbc.oracore.OracleTypeADT.parseTDS(OracleTypeADT.java:808)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:412)
at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1952)
at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:199)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:118)
...

Any Help?
N.B: I'm using Oracle Database 9.2.0.5 and JDK 1.3 (and latest JDBC driver for Oracle 9.2.0.5)
Mazen Mahmoud
Greenhorn

Joined: Oct 25, 2007
Posts: 20
I know where the error comes from. It's because i'm using Timestamp which not supported with my current versions of JDK (1.3) and Oracle 9i with old JDBC driver.
 
Have you checked out Aspose?
 
subject: ArrayDescriptor Urgent
 
It's not a secret anymore!