Resolution:
Starting in BW 5.3.0, when a user uses tibco jdbc driver to execute a simple SQL statement against DB2, s/he encounters the following error:

BW-JDBC-100014 "JDBC error reported: (SQLState = HY000) - java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver]Unsupported method: Statement.setQueryTimeout"

caused by: java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver]Unsupported method: Statement.setQueryTimeout

The Connection Test is successful but not when  you exectue a query at run-time.

So far, we found the following drivers have this issue -
  JdbcOdbc driver
  ODBC Microsoft Access Driver
  DataDirect driver for DB2

To solve/work-around this SQL Exception, one can simply use "bw.jdbc.timeout.useCancel=true" engine property.