Following the steps in the documentation to create a PDI data service
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
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.