Error retrieving table list, An illegal character has been found in the statement.

[tpwu]

Hi Tom,

I updated to the latest dev version 112.8 build and encountered below error while retrieving catalog from informix. Any help is appreciated.

Thanks

2012-06-18 12:53 ERROR Error retrieving table list An illegal character has been found in the statement. [SQL State=IX000, DB Errorcode=-202]
java.sql.SQLException: An illegal character has been found in the statement.
    at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:400)
    at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3293)
    at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3602)
    at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2410)
    at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2326)
    at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1492)
    at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1465)
    at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:206)
    at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228)
    at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:243)
    at com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaData.java:3003)
    at workbench.db.DbMetadata.getObjects(DbMetadata.java:1376)
    at workbench.db.DbMetadata.getObjects(DbMetadata.java:1308)
    at workbench.gui.dbobjects.TableListPanel.retrieve(TableListPanel.java:926)
    at workbench.gui.dbobjects.TableListPanel.setCatalogAndSchema(TableListPanel.java:832)
    at workbench.gui.dbobjects.DbExplorerPanel$5.run(DbExplorerPanel.java:852)
Caused by: java.sql.SQLException
    at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:400)
    at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3607)
    ... 13 more

[Thomas Kellerer]

Hi,

I assume your schema contains an underscor?

In that case, please add the following line to your workbench.settings

workbench.db.informix_dynamic_server.metadata.retrieval.wildcards=false

This will turn off wildcard escaping when dealing with schema names that contain underscores. Apparently the Informix JDBC driver does not handle that correctly.

Regards
Thomas

> --
> You are receiving this email because you are a member of the Google Group "sql-workbench".
> To post messages to the group, send an email to sql-wo...@googlegroups.com
> To unsubscribe from this group, send an email to sql-workbenc...@googlegroups.com
> More options are available at http://groups.google.com/group/sql-workbench?hl=en

[tpwu]

Yap, it works.

Thanks

[Thomas Kellerer]

Hi Thomas,

this is essentially the same reason as with the Informix driver.

Please see

http://www.sql-workbench.net/devmanual/troubleshooting.html#oracle-problems

for more details.

In a nutshell: please add the property mentioned in the manual or update to a driver version where the bug has been fixed.

Regards
Thomas

Thomas, 26.06.2012 10:43:
> Hi Thomas, same problem with Oracle and Build 112.9. Only seeing Sequences. Other object types are hidden. Changed to stable release 112 and everything works fine.
>
> Additional Information:
> PRODUCT VERSION STATUS
> NLSRTL 11.2.0.1.0 Production
> Oracle Database 11g 11.2.0.1.0 64bit Production
> PL/SQL 11.2.0.1.0 Production
> TNS for 64-bit Windows: 11.2.0.1.0 Production