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: com.ibm.as400.access.AS400JDBCDriver
user
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.](https://community.denodo.com/answers/question/details?questionId=90670000000blYdAAI&title=Error+querying+Oracle+DB) * [Could not create a validated object](https://www.google.com/url?q=https%3A%2F%2Fcommunity.denodo.com%2Fanswers%2Fquestion%2Fdetails%3FquestionId%3D90670000000XdErAAK%26title%3DCould%2Bnot%2Bcreate%2Ba%2Bvalidated%2Bobject%252C%2Bcause%253A%2BValidateObject%2Bfailed)   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