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
|