Using the Intersystems Iris JDBC Driver for Caché Database to Set Connection Timeout
Hello,
I have a question regarding the Intersystems Caché Database and its jdbc driver. I need to set the connection timeout for the database, but I couldn't find any documentation stating that the jdbc driver for Caché supports setting the connection timeout. However, I noticed that the jdbc driver for the Intersystems Iris Database appears to support this feature.
My question is, can I use the Iris jdbc driver to set the connection timeout for the Caché Database?
The jdbc driver I use: cache-jdbc-2.0.0.jar
Thank you for your help.
Best regards,
Kalle
Comments
I could not find any returned document that states whether the InterSystems IRIS JDBC driver can be used to connect to a Caché database, or whether doing so would support setting a connection timeout for Caché specifically.
What the returned documents do show is:
- The IRIS JDBC driver is documented for connecting to InterSystems IRIS, using the
jdbc:IRIS://...URL format and classes such ascom.intersystems.jdbc.IRISDataSource. [1][2] - The Caché JDBC driver is shown separately, with a Caché URL format such as
jdbc:Cache://127.0.0.1:56772/Samples, and a Caché driver classcom.intersys.jdbc.CacheDriver. [3] - For IRIS connection pooling,
IRISConnectionPoolDataSourcehas asetConnectionWaitTimeout()method, but that timeout is described as the wait time for a pooled connection to become available, not as general proof that the IRIS driver can be used against Caché. [2]
[!NOTE]
The IRISDataSource class provides an extended set of connection property accessors (such as setUser() and setPassword() in this example). See "Class IRISDataSource" in the Quick Reference for a complete list of accessors, and see "Connection Parameter Options" later in this reference for mo [2]
Because the retrieved material does not explicitly answer your compatibility question, I can’t confirm that you can use the IRIS JDBC driver to set connection timeout for a Caché database. [4][2][3]
Sources: