Using Cache driver as JDBC Connection Pool

[sysmat]

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]

• 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]

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ž