File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Reading UDT values using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Reading UDT values using JDBC" Watch "Reading UDT values using JDBC" New topic

Reading UDT values using JDBC

Anirban dutta
Ranch Hand

Joined: Aug 08, 2002
Posts: 89
Hi all,
I am accessing a Database column of ORACLE which contains a user-defined type(object) of Oracle. The type contains a NUMBER and a VARCHAR2 field. I have used the "getObject" method of the ResultSet to get the column in a STRUCT object. From this I am able to get the value of the NUMBER field, but I couldn't get the value of the VARCHAR2 field properly. Can anybody pls tell me how to do it. I am using Oracle8i driver version 1.1.
The code:

Thanks and Regards
I agree. Here's the link:
subject: Reading UDT values using JDBC
It's not a secret anymore!