Skip to Content
0
May 14, 2020 at 02:45 PM

CC Cockpit and DB2 database

193 Views

Hi,

The CC Cockpit can work with DB2 database.

In the configuration file there is also description how to define JDBC connection for DB2. I mean parameter sqlhelper.jdbc.uri. And it works fine.

Most of Fiori apps works fine in such setup, but...

in some apps, or when changing filters on working apps, an error appear(or nothing) and no result of queries.

In the server logs we can find errors during some SQL queries. For example:

Error reason: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LIMIT;;FETCH FIRST <n> ROWS ONLY, DRIVER=4.19.66. Next exception: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;LIMIT||FETCH FIRST <n> ROWS ONLY, DRIVER=4.19.66. Next exception: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;LIMIT||FETCH FIRST <n> ROWS ONLY, DRIVER=4.19.66.#

On DB2 support pages I found that this is due to using LIMIT at the end of SQL query instead of FETCH FIRST n ROWS.

Any idea what else I need to change or setup for DB2?

best regards

Rafal