Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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