Re: [Squirrel-sql-users] java.lang.ClassNotFoundException: oracle.xdb.XMLType

[info <in...@dr...>]

On 09/11/2026 03:51 PM, Gerd Wagner wrote:
>
>
> On 9/8/26 20:14, info via Squirrel-sql-users wrote:
>> Hi, everyone:
>>
>> Doing a select * from an Oracle 18c table with an XMLType column, I 
>> am getting the error in the subject.
>> I am on 4.8.0. Is this error fixed in another version?
>>
>
> For me it works with the following Jars in my JDBC Driver Class Path:
> xmlparserv2-23.26.3.0.0.jar
> xdb-23.26.3.0.0.jar
> ojdbc8-23.26.3.0.0.jar
>
> The download-Links that worked for me are:
>
> https://repo1.maven.org/maven2/com/oracle/database/jdbc/ojdbc8/23.26.3.0.0/ojdbc8-23.26.3.0.0.jar 
>
>
> https://repo1.maven.org/maven2/com/oracle/database/xml/xdb/23.26.3.0.0/xdb-23.26.3.0.0.jar 
>
>
> https://repo1.maven.org/maven2/com/oracle/database/xml/xmlparserv2/23.26.3.0.0/xmlparserv2-23.26.3.0.0.jar 
>
>
> Hope this helps
>
> Gerd
>
It certainly does! No more error, just "Unknown type(2009)".


Regards

Al