How to retrive abstract data type via jdbc?

How to retrive abstract data type via jdbc?

Post by Jzho » Sun, 31 Dec 1899 09:00:00



There are an abstract data type dt1(id, content), and a table tb(id, dt1)
where dt1 is the above defined abstract data type. (both data created by
oracle 8.04)

I am trying to retrive values from table tb (above table) and failed(using
jdbc). It gave an error message "Unsurpported Network datatype or
representation". Do someone know how to solve this problem on jdbc?

Thanks.

Jing

 
 
 

How to retrive abstract data type via jdbc?

Post by C. Ferguso » Sun, 31 Dec 1899 09:00:00


Hi Jing,
  I'm not sure if jdbc can give you what you are looking for.  Even if you
used the
ResultSet.getObject(dt1) call, I'm not sure what type of Java object it could
get mapped to.  You may have to rearchitect your db table....
Look at the jdbc documentation for result sets and the different get methods.
Sorry I can't be of more help...you are treading in new waters...
Good Luck,
Cindy

> There are an abstract data type dt1(id, content), and a table tb(id, dt1)
> where dt1 is the above defined abstract data type. (both data created by
> oracle 8.04)

> I am trying to retrive values from table tb (above table) and failed(using
> jdbc). It gave an error message "Unsurpported Network datatype or
> representation". Do someone know how to solve this problem on jdbc?

> Thanks.

> Jing


 
 
 

1. How to retrive abstract data type using jdbc with oracle8.04

There are an abstract data type dt1(id, content), and a table tb(id, dt1)
where dt1 is the above defined abstract data type. (both data created by
oracle 8.04)

I am trying to retrive values from table tb (above table) and failed(using
jdbc). It gave an error message "Unsurpported Network datatype or
representation". Do someone know how to solve this problem on jdbc?

Thanks.

Jing

2. AD--For UK readers only

3. Insert long data type into oracle via jdbc

4. importing .wb2 spreadsheets

5. Abstract Data Parameter Type?

6. Is TRO (Tom Rettig's Office still on the market?

7. User Customisable Schema and Oracle Abstract Data Types

8. UNIXWARE 2.01 and 4GL website

9. SQL Loader and Abstract Data Types and Nested Tables

10. abstract data types

11. Abstract Data Types

12. abstract data types/objects

13. Problem with Abstract Data Type