We managed to get a strange behaviour in the api gateway (9.1) with an oracle jdbc connection if we do the following:
I assume that the resultsets are somehow cached (like these properties suggests it: JDBC Cluster Properties - CA API Gateway - 9.1 - CA Technologies Documentation).
I understand that this is useful for the internal mysql db.
But I would like to disable the caching for external dbs. How can I achieve this? Is it a special additional property?
I tried replicating this scenario following the steps mentioned by you against oracle db, then i added this CWP
jdbcQueryManager.cacheStaleTimeout and reduced the value to 1 sec to check the behavior quickly and i see the query test fails, but with default value which is 1800 sec's the query is successful even after the account is locked.
Been through the url pointed out by you and my understanding is that the properties there are for any jdbc connection and not just for internal mysql db.
Thanks for finding the right property.
As you mentioned, this property will probably set the cache timeout for all jdbc connections and I think, that this will reduce the performance of the whole gateway, because it has to reload every second instead of every 30 seconds from the internal mysql db.
That's why, I am looking for a way which can set this caching property only for a specific jdbc connection.
Is this possible?
I never meant to set it up as low as 1 sec, just to test it quickly so that i don't have to wait for long i set it up to 1 sec.
I know that this was only for testing.
My original question was if there's a way to disable the caching for a specific jdbc connection...
i don't think we can do it for a specific jdbc connection
Thank you, added it as idea
disable jdbc caching for a specific connection