wood burning stoves 2.0*
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

ArrayDescriptor Urgent

Mazen Mahmoud

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 and JDK 1.3 (and latest JDBC driver for Oracle
Mazen Mahmoud

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.
Consider Paul's rocket mass heater.
subject: ArrayDescriptor Urgent
Similar Threads
invalid name patter error
Passing Array as a parameter to Stored procedures
java.sql.SQLException: invalid name pattern: PFEP.file_import_nestedtable
Getting array of Oracle Objects
OracleConnection and Websphere