2

What is a recommended production configuration for tomcat grails jdbc access?

commons-dbcp or tomcat jndi polling?

Does anyone have performance or anecdotal advice in regards to this configuration?

We have been fighting configuration and possibly transaction issues using Grails and tomcat jndi, and we are trying to decide if we want to invest more time in debugging those issues, or just use commons-dbcp.

This may be considered a duplicate of tomcat-dbcp vs commons-dbcp, but I am looking for performance data and advice in regards to Grails.

If it matters, we are using MySQL :)

Community
  • 1
  • 1
chrislovecnm
  • 2,549
  • 3
  • 20
  • 36
  • What are the actual transaction errors you are getting in Grails? Are you having real performance problems? Because tomcat-dbcp is based on apache-commons-dbcp, you could see the same problem and you might be better served by switching to something like C3P0 or going with a different application server. [SpringSource tc-Server's DBCP](http://pubs.vmware.com/vfabric52/topic/com.vmware.vfabric.tc-server.2.8/admin/manual-high-concurrency-jdbc.html) "adds additional features to support highly-concurrent environments and multiple core/cpu systems" – Drew Dec 06 '12 at 03:31
  • Drew the hibernate issues where not driver related. Do you have any numbers on tc server dbcp? – chrislovecnm Dec 27 '12 at 01:02

1 Answers1

1

I suggest you watch: Debugging Grails Database Performance

http://skillsmatter.com/podcast/groovy-grails/debugging-grails-database-performance

moskiteau
  • 1,104
  • 11
  • 19