I recently began using SQuirrel SQL, but have hit an obstacle and was
wondering if anyone here knows a solution. (I have already searched Google
and the issue tracker and mailing list archives on Sourceforge.)
I'm connecting to an Oragle 10.2.0.1.0 database using the Oracle Thin
driver. One of the tables whose data I need to display has a column of type
XMLType, and in the contents tab, will only display either 'Unknown (2 007)'
or 'null' (if I activate the preference to convert unknown data types to
string for display, in Global Preferences > Data Type Controls).
I have added ojdbc-14.jar, xmlparserv2-10.1.0.2.jar and xdb-10.1.0.2.jar, in
that order, to the Extra Class Path tab of the Oracle Thin Driver, but this
makes no difference.
Any suggestions? Other JDBC clients, such as Aqua Data Studio, display
XMLType columns without any trouble, so this is not a general JDBC issue.
Thanks in advance for any ideas you may have.