Geert Bevin wrote:
With the Java version of the frontend we planned to switch to
PostgreSQL anyways, but for now, we use a homemade database
abstraction layer for the frontend. Written by me a long, long time
ago, when I didn't see the light. ;)
So, I'll make a Cronjob that tells Tomcat to reload the webapp, until
I finish writing a PostgreSQL module for my dba-layer. This will do
until we have the purely Java/RIFE-based software ready. Not the
sexiest solution, I know, but I don't want to wait for a fix of the
MySQL Connector/J.
What I would do is to write a RIFE scheduler task that goes over all
the connections in your mysql datasource and issue a "SELECT 0"
statement for each one. This task could then be run every hour of so.
For details of how use the scheduler you'll probably have to look
through some of our real-world app examples (Bamboo, ...) or ask
someone here on the list to explain it to you.
Alright, nice solution, I'll try that. :)
_______________________________________________
Rife-users mailing list
Rife-users@uwyn.com
http://lists.uwyn.com/mailman/listinfo/rife-users
