problem with connection to db2 for i

[peter1504]

Hi,
we try to connect fom Rocky Linux 9 to db2 for i (AS400) with different jdbc drivers (for example jt400-10.6.jar) with different settings.

But we always hit an exeption in those jdbc drivers, that always point to
IMPORT FOREIGN SCHEMA TEST FROM server jdbc_db2 into DB2_01 OPTIONS (recreate 'true');
Exception in thread "Thread-6" java.sql.SQLException: [SQL7049] Die Grenze eines internen Objekts wurde überschritten.
at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:962)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1084)
at com.ibm.as400.access.AS400JDBCPreparedStatementImpl.execute(AS400JDBCPreparedStatementImpl.java:1434)
at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getColumns(AS400JDBCDatabaseMetaData.java:1106)
at JDBCUtils.getColumnNames(JDBCUtils.java:335)

Further investigation implies that possibly opened resources are not freed by jdbc_fdw.

Any help is appreciated.

Regards

Peter

[nxhai98]

Hi @peter1504,

Thank for your reporting.

db2 for i is not a target of jdbc_fdw for now. It will have some unexpected behaviors when connect to db2 for i.

However, there is an issue related to IMPORT FOREIGN SCHEMA make this feature work correctly with GridDB only.
We will fix it and release for you soon.

Thank you and best regards.