Hi there,

We're runing IDM 3.5 JDBC driver to talk to Informix 7.02 database. We
can connect the driver to the database but get an error concerning
retrieval of metadata. We are attempting to use indrect, triggerless
synch on publisher only. The informix JDBC driver is documented as
compatible with this version of Informix. Earlier in the log we see:

status level="warning">Runtime database does not match any database
descriptors. Defaulting to database descriptor '_default_db.xml'

and then....

DirXML Log Event -------------------
Driver: NC_IDM_TREEvaultservicesDriverSetJDBC-Test
Status: Error
Message: <description>Unable to retrieve database
metadata.</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="-201"
jdbc:sql-state="42000" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>A syntax error has occurred.</jdbc:message>
<jdbc:stack-trace>java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2353)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2269)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1428)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1401)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java :204)
at com.informix.jdbc.IfxStatement.executeQueryImpl(If xStatement.java:1212)
at com.informix.jdbc.IfxStatement.executeQuery(IfxSta tement.java:227)
at
com.informix.jdbc.IfxDatabaseMetaData.getPrimaryKe ys(IfxDatabaseMetaData.java:4701)
at
com.novell.nds.dirxml.driver.jdbc.util.config.JDBC MetaData.getPrimaryKeyMetaData(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.config.JDBC MetaData.getParentTableORViewMetaData(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.config.JDBC MetaData.getSchema(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.config.JDBC MetaData.getSchema(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.config.JDBC MetaData.&lt;init>(Unknown
Source)
1702923184 DVRS: [2007/08/02 14:19:15.519]  at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CConnectionFactory.getMetaData(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CConnectionFactory.newConnection(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CConnectionFactory.newSubscriptionConnection(Unkno wn
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCDriverShim.g etSchema(Unknown
Source)
at com.novell.nds.dirxml.engine.Driver.getShimSchema( Driver.java:1400)
at com.novell.nds.dirxml.engine.Driver.startShim(Driv er.java:1258)
at com.novell.nds.dirxml.engine.Driver.initialize(Dri ver.java:254)
at com.novell.nds.dirxml.engine.Driver.&lt;init>(Driv er.java:226)
at com.novell.nds.dirxml.engine.DriverEntry.run(Drive rEntry.java:537)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:373)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)
... 23 more