Running SQuirreL Client version 4.4.0 on Windows 10 for Informix. When connecting to an alias no tables schemas are loading. When I do a "refresh item" I get the following error when refreshing the alias table to get schema. I have attached my alias properties schemas settings.
2022-08-09 12:27:01:255 [pool-1-thread-1] ERROR net.sourceforge.squirrel_sql.client.gui.session.SchemaPanel - Failed to set schema
java.lang.AbstractMethodError: Receiver class com.informix.jdbc.IfxSqliConnect does not define or inherit an implementation of the resolved method abstract setSchema(Ljava/lang/String;)V of interface java.sql.Connection.
at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.setSchema(SQLConnection.java:356)
at net.sourceforge.squirrel_sql.client.gui.session.SchemaPanel.onSchemaSelected(SchemaPanel.java:178)
at net.sourceforge.squirrel_sql.client.gui.session.SchemaPanel.lambda$onChooseSchema$3(SchemaPanel.java:148)
at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967)
at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2308)
at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:369)
at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1020)
at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1064)
at java.desktop/java.awt.Component.processMouseEvent(Component.java:6632)
at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3342)
at java.desktop/java.awt.Component.processEvent(Component.java:6397)
at java.desktop/java.awt.Container.processEvent(Container.java:2263)
at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5008)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4840)
at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4918)
at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547)
at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4488)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307)
at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2772)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4840)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(Native Method)
Judging from your error message it looks like you are using a rather outdated JDBC driver.
A newer one which at least shouldn't run into the error you posted can be found by following the instructions on this IBM page:
https://www.ibm.com/docs/en/informix-servers/12.10?topic=started-obtain-jdbc-driver
ok thank you for your reply. I am currently running 4.10. Unfortunately, this is a the company standard version as we are migrating off informix in the near future. Is there an older SQuirreL version that would work with this version?
You may try 3.8.0, see https://sourceforge.net/projects/squirrel-sql/files/1-stable/3.8.0/
In case this SQuirreL 3.8.0 doesn't work with a recent Java version try Java 8, see
https://adoptium.net/de/temurin/releases?version=8