Jruby Activerecord is giving me stale connections

I have a Jruby app that spins up several background Java threads that share an ActiveRecord (2.3.开发者_开发百科5) connection. If they sleep for some time and then try to do something database related, the first queries never execute. I believe this is because the connections are stale, but the code itself doesn't throw any errors.

I've tried doing a ActiveRecord::Base.connection.verify! but it still craps out. I'm using ActiveRecord jdbcmysql 0.9.7 but am now trying the newest 1.0.2 to see if that helps.

We had the exact problem, the solution is to call the line of code below at the end of the thread.

ActiveRecord::Base.clear_active_connections!