Problems in retrieving XMLTYPE data from Oracle 9i using Oracle JDBC driver

From: Ashok Subramanian <ashok820_at_hotmail.com>
Date: 17 Jan 2002 12:23:12 -0800
Message-ID: <461ee23b.0201171223.79526a14@posting.google.com>

Hello All,

I am using the Oracle 9i database on Solaris 8 and I am using the JDBC driver which came with Oracle 9i installation(classes12.zip). When I retrieve a column from the database which is of type SYS.XMLTYPE my java program just hangs and the session becomes inactive. I was able to make the same program work with the Sun JDBC-ODBC bridge from a windows machine. I was also able to write a windows client in VB using the ODBC driver from oracle. The query always runs fine from the SQLPLUS prompt.

My table has the following structure:

XmlStore
(
Id varchar2(10),
xmldata SYS.XMLTYPE
)

The query I am running is:
select x.xmldata.getstringval() from xmlstore x where id = '1'

Can someone please let me know why this happens? Do I need to apply a patch on Solaris 8 for the JDBC driver?

Thanks
Ashok Received on Thu Jan 17 2002 - 14:23:12 CST