aspose file tools*
The moose likes JDBC 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
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.
 
 
subject: ArrayDescriptor Urgent