Search code examples
javasqldb2websphereopenjpa

Preceeding almost every call, we get a pretty useless call that comes in as a separate transaction SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1

We have a JAVA application that connects to DB2 throught openJPA to fetch data. Preceeding almost every SQL call, we get a pretty useless call that comes in as a separate transaction: "SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1"

DBA says he doesn't have any idea why this above useless SQL statement gets called before almost every call.

Any idea why this query gets called? Is there anything I can do to skip this?

It's been a while I am stuck with this issue with DBA complaining about dramatically increment in the number of transaction hitting DB2.

Any help would be appreciated. Thanks

Solution

  • If you have datasource configured in WAS, make sure that on Data sources > YOUR_DATASOURCE > WebSphere Application Server data source properties page you have UNCHECKED both Validate connections.. options.