You can translate the question and the replies:

Select from DB2 instance tables error.

Hello, I'm able to connect and import tables and views from DB2 but when I'm trying to select something from imported DB2 tables - I faced with an issue like: TESTTABLE [BASE] [ERROR] TESTTABLE [JDBC WRAPPER] [ERROR] TESTTABLE#0 [JDBC ROUTE] [CONNECTION_ERROR] Unexpected error creating a connection: Could not create a validated object, cause: ValidateObject failed Received exception with message 'Could not create a validated object, cause: ValidateObject failed'. Could you please help to clarify the issue above? P.S. Driver Class:
05-06-2017 07:00:09 -0400

1 Answer

Hi,   The error:   ‘Could not create a validated object', cause: ValidateObject failed’   occurs when the ‘Ping query’ given in the Connection Pool Configuration for the datasource is not valid.   I would ensure that the Ping query used for testing the datasource connection is  a valid query like below for DB2 and then, I would try executing the base view again:   **‘select 1 from SYSIBM.SYSDUMMY1’ **   You can also refer to the below community questions for more information that might be useful.   * [Error querying Oracle DB.]( * [Could not create a validated object](   Hope this helps!!
Denodo Team
06-06-2017 09:00:52 -0400
You must sign in to add an answer. If you do not have an account, you can register here