offline datasource - dummy records?

If your connection is stale, or even worse when your connection to a datasource is offline/not available. But you do have views working on top of these datasources. Is it possible for Denodo to give you a "select X from dual()" dummy record back instead of giving a "incomplete results" or "HTTP-error 404" or "JDBC route unexpected error"? so even if a datasource is unavailable, you could still complete your query without getting errors?
user
26-06-2019 03:48:15 -0400

1 Answer

Hi, This looks a like a good case for using the in-built 'Test Connections' option in the connection pool of your data source. I would encourage you to follow the steps mentioned in https://community.denodo.com/kb/view/document/Closed%20connections%20from%20database%20cause%20error?category=Common+Errors and configure your data source accordingly. Hope this helps!
Denodo Team
26-06-2019 07:48:39 -0400
You must sign in to add an answer. If you do not have an account, you can register here