Stefan Thomas wrote:
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. :)
Ok, as I learned how to use the Scheduler, I added a Wiki page in the
Cook Book. Everyone, please take a look and improve as you see fit. Thanks!
http://rifers.org/wiki/display/RIFE/Scheduler
Cheers,
Stefan :)
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
