Using Cache driver as JDBC Connection Pool

qwazr / jdbc-cache-driver

A JDBC Cache Driver

7 stars 11 forks source link

Using Cache driver as JDBC Connection Pool #29

Open sysmat opened 5 years ago

sysmat commented 5 years ago

Is it possible to configure in glassfish?

How to add properties to mysql driver and how to add properties for cache driver?

Regards, Tomaž

sysmat commented 5 years ago

I put cache jar to glassfish lib folder

this is my glassfish configuration:


Resource Type:  javax.sql.XADataSource
Datasource Classname:  com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
cache.driver.class: com.mysql.jdbc.Driver
cache.driver.url: jdbc:mysql://localhost:3306/test
user: test
password: test
serverName: localhost
databaseName: test


I don't know how to tell cache to use file or memory cache?
I don't know how to check if cache is actually working?

sysmat commented 5 years ago

in issue #24 (Using Cache driver as Datasource) it is not clear url and URL, are this two different properties?

cache.driver.URL - is controlling cache file or memory cache.driver.url - is connection to database

I don't understand how to connect mysql driver and cache driver

Regards, Tomaž