[Squirrel-sql-users] Problems with Oracle XMLType

[Hale,Katherine <ha...@oc...>]

First, let me say I'm so glad to see SQuirreL maturing into such a nice
client. I've been using it off an on for about 3 years now, and it's
really quite stable now. I'm running 2.6.5a.

At first I was connecting successfully using only ojdbc14.jar (I believe
the database is Oracle 10). But then when I queried the XML column I
got:

1343450 [Thread-2] ERROR
net.sourceforge.squirrel_sql.plugins.oracle.types.OracleXmlTypeDataTypeC
omponent  - Perhaps the XDK which contains the class oracle.xdb.XMLType
is not in the CLASSPATH?
java.lang.ClassNotFoundException: oracle.xdb.XMLType
	at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
	at
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLCla
ssLoader.java:168)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:164)
	at
net.sourceforge.squirrel_sql.plugins.oracle.types.OracleXmlTypeDataTypeC
omponent.readResultSet(OracleXmlTypeDataTypeComponent.java:176)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.CellComponen
tFactory.readResultWithPluginRegisteredDataType(CellComponentFactory.jav
a:544)
	at
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.doRead(ResultSetRead
er.java:434)
	at
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetRea
der.java:124)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResult
Set(ResultSetDataSet.java:136)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResult
Set(ResultSetDataSet.java:93)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResult
Set(ResultSetDataSet.java:64)
	at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterP
anel$SQLExecutionHandler.sqlResultSetAvailable(SQLResultExecuterPanel.ja
va:1331)
	at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResul
tSet(SQLExecuterTask.java:488)
	at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery
(SQLExecuterTask.java:398)
	at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecu
terTask.java:228)
	at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:
82)
	at java.lang.Thread.run(Thread.java:595)

I have since added oracle_xdb_g.jar to the Extra Class Path tab of the
driver. But now I get another exception. 

Colin Bell, Gerd Wagner, Rob Manning and others
76865 [Thread-5] ERROR
net.sourceforge.squirrel_sql.plugins.oracle.types.OracleXmlTypeDataTypeC
omponent  - Unexpected exception while attempting to read SYS.XMLType
column
java.lang.NoSuchMethodException:
oracle.xdb.XMLType.createXml(oracle.sql.OPAQUE)
	at java.lang.Class.getMethod(Class.java:1581)
	at
net.sourceforge.squirrel_sql.plugins.oracle.types.OracleXmlTypeDataTypeC
omponent.readResultSet(OracleXmlTypeDataTypeComponent.java:177)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.CellComponen
tFactory.readResultWithPluginRegisteredDataType(CellComponentFactory.jav
a:544)
	at
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.doRead(ResultSetRead
er.java:434)
	at
net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetRea
der.java:124)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResult
Set(ResultSetDataSet.java:136)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResult
Set(ResultSetDataSet.java:93)
	at
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResult
Set(ResultSetDataSet.java:64)
	at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterP
anel$SQLExecutionHandler.sqlResultSetAvailable(SQLResultExecuterPanel.ja
va:1331)
	at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResul
tSet(SQLExecuterTask.java:488)
	at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery
(SQLExecuterTask.java:398)
	at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecu
terTask.java:228)
	at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:
82)
	at java.lang.Thread.run(Thread.java:595)

I'm a Java developer, so I can crack open the XDB jar. The method
signature in mine is definitely createXML(OPAQUE) with capital XML, not
Xml. Is this a bug? Or do I have a strange version of the XDB jar? 

I tried to download it from Oracle's website, but it must be busy
because it wasn't responding. Should I open a ticket? Should I reopen
this old one? 
http://sourceforge.net/tracker/index.php?func=detail&aid=890843&group_id
=28383&atid=393417

Thanks!

Kathy