java - How to set "SQL_NO_CACHE" default in a pooled mysql JDBC connection -

our mysql server has "sql_no_cache" off default, , wish off application. can rewrite sql statements sound stupid.

according mysql docs per connection default can configure following command.

set session query_cache_type = off; 

i wish statement issues each new connect created datasource. however, don't find configurable properties in connector/j jdbc driver.

dbcp's connectioninitsqls seem 1 of option, using 1.2.2 reason. , may want remove dependency of dbcp (less more).