Hi,
We have a bug with the newest SAS JDBC drivers form SAS 9.4 M6 (https://support.sas.com/downloads/package.htm?pid=2285) and CLI.
Connection with SAS/SHARE with encrypted password in SAS001 gets result:
_TEMG001
1.0
Exception in thread "main" java.lang.UnsupportedOperationException: Must be implemented in derived class
at net.sourceforge.squirrel_sql.client.cli.CliSessionAdapter.showMessage(CliSessionAdapter.java:289)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleResultSetWarnings(SQLExecuterTask.java:604)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResultSet(SQLExecuterTask.java:557)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:403)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:209)
at net.sourceforge.squirrel_sql.client.cli.SquirrelCli.exec(SquirrelCli.java:142)
at net.sourceforge.squirrel_sql.client.cli.SquirrelCli.exec(SquirrelCli.java:128)
at net.sourceforge.squirrel_sql.client.cli.SquirrelBatch.main(SquirrelBatch.java:135)
So I have proper result and after that there is always error.
Could some of developers take a look?
Regards,
Mateusz
Your JDBC driver seems to break when SQuirreL calls the driver's ResultSet.getWarnings() method.
Nonetheless SQuirreL's problem was that it didn't show the error that ResultSet.getWarnings() produced but an UnsupportedOperationException.
Now in the latest snapshot the right error is issued.
Unfortunately this may not solve your problem as now a different error will occur. But as mentioned above this error is due to your JDBC driver.
If you are lucky the new error tells what to do about the problem. If not please consult your driver vendor and ask him to fix the error that occurs when ResultSet.getWarnings() is called.