Using Squirrel SQL To Query A PDI Data Service

Document created by Bradley McNeely Employee on May 23, 2018Last modified by Bradley McNeely Employee on May 23, 2018
Version 2Show Document
  • View in full screen mode


Windows 10


Squirrel 3.8.1


Following the steps in the documentation to create a PDI data service

Develop and Optimize a Pentaho Data Service - Pentaho Documentation


I next set about trying to query the service with a third party tool like Squirrel SQL.  I had DBeaver working but really wanted to get Squirrel working because I seem to come across it more and used it more frequently back in my database days.  Even though my setup looked correct and it was working through PDI and DBeaver, I was getting this message when I tried to connect through Squirrel

class java.lang.ClassNotFoundException: org.apache.http.pool.ConnPoolControl


I found a JIRA that indicated that there was a file missing from the PDI Data Service bundle called httpcore.  So I copied one from


into the directory with the rest of the data service jars.  Then I started getting this error

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NoSuchMethodError: org.apache.commons.codec.binary.Base64.<init>(I)V


After some more searching I found a similar message for a totally separate product having nothing to do with Pentaho that indicated that the problem was with the commons-codec.jar that ships with Squirrel.  There's one in the Pentaho data services bundle (commons-codec-1.10.jar) and it was listed in the Extra Class Path section so I moved the one that was in

C:\Program Files\squirrel-sql-3.8.1\lib

to a backup directory, restarted Squirrel, and I was off and running querying my PDI data service.  I'm attaching my driver configuration screen shots for additional information.  Hope you find this helpful.