Welcome to Teiid community. We appreciate your consideration in using Teiid.
The issue is not with JDBC connection, but the salesforce-34 translator itself and its dependencies. Even though we packaged "34" version with 34 version of Salesforce partner libraries, we compiled the code using 22 version, and thus missed a interface method change between these two versions. If you can open JIRA here Teiid - JBoss Issue Tracker about this issue, we will see we try to fix for the next milestone build.
It's a very subtle change as the code compiles against 22 and 34 - however the method changes from SObject to ISObject in 34 (SObject is the only concrete ISObject) thus the issue. So we'll need some kind of override logic in the 34 resource adapter to account for this.
Very thank's for the prompt replies.
I opened a jira as requested: https://issues.jboss.org/browse/TEIID-4439
However I am a bit confused that it seem to work fine with SQuirrel. SQuirrel use the same JDBC Driver. In my case the only difference is the Java runtime, version, 1.7 (SQuirrel) vs. version 1.8 (my application).
I suspect when you are going over SquirreL it may be hitting 22 version of the SF. Java runtime shouldn't affect either.