Using Cache driver as Datasource

[datsabk]

Hello,

Is it possible to configure this cache driver as a JNDI datasource? If yes, how do I do that with IBM Liberty server?

[emmanuel-keller]

jdbc-cache driver is basically a JDBC Driver.

If I refer to this documentation:
https://www.ibm.com/support/knowledgecenter/en/SSAW57_liberty/com.ibm.websphere.wlp.nd.multiplatform.doc/ae/twlp_dep_configuring_ds.html

While copying the jdbc-cache-driver.jar file in C:/DB2/java, it would be possible to do something like that:

<library id="JdbcCacheLib">
    <fileset dir="C:/DB2/java" includes="jdbc-cache-driver.jar"/>
</library>

Then you may use the following template as a datasource definition:

<dataSource id="DefaultDataSource" jndiName="jdbc/jdbcCache">
  <jdbcDriver libraryRef="JdbcCacheLib"/>
  <properties.cache URL="jdbc:cache:mem:my-mem-cache" url="jdbc:oracle:oci:@//localhost:1521/SAMPLEDB"/>                     
</dataSource>

Next, the point is to be able to pass the following properties:

• cache.driver.url = {the JDBC connection URL to your database}
• cache.driver.class={the class name of the JDBC Driver of your database}

Disclaimer: This is a not tested configuration. It is just here as an example.

Let us know if you can make it work.