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

Configuration

Windows 10

Pentaho 8.0.0.0-28

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

C:\Pentaho\server\pentaho-server\tomcat\webapps\pentaho\WEB-INF\lib

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.

Attachments

Outcomes