up vote 0 down vote favorite
share [g+] share [fb]

Is it possible to set JBOSS/JDBC's MySQL connector to cache the server's settings so that I won't get a big bunch of "show variables" connection all the time?

I think there is a similar settings under Glassfish called CacheServerConfiguration but I was not able to find more information about that under JBOSS.

Does anyone know if this is possible?

Edit: Got it.

link|improve this question
feedback

1 Answer

up vote 0 down vote accepted

Got it. All I had to do was to append that to the jdbc URL like this.

jdbc:mysql://localhost:3306/database_name?cacheServerConfiguration=true

More information is available here: http://www.yaldex.com/mysql_manual/ch23s04.html

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.