[Rife-users] Strange MySQL-Problem w/ RIFE/Crud

2006-05-29 Thread Stefan Thomas
Hi guys, just to give you a short update on what happened since my last Mail to this list: The decision was made to use PHP for the frontend and RIFE/Crud for the administration interface. Both are almost ready now, but there's a bug in the admin interface we can't get rid of. The error

Re: [Rife-users] Strange MySQL-Problem w/ RIFE/Crud

2006-05-29 Thread Geert Bevin
Simple question, which version of MySQL and Connector/J are you using? Upgrading them to the latest versions might help. On 29 May 2006, at 12:09, Stefan Thomas wrote: Hi guys, just to give you a short update on what happened since my last Mail to this list: The decision was made to use

Re: [Rife-users] Strange MySQL-Problem w/ RIFE/Crud

2006-05-29 Thread Stefan Thomas
Hi Geert, Geert Bevin wrote: sadly this isn't the first time the issue was brought up and afaik it's a problem with MySQL themselves and their view on connection pooling. More info: http://article.gmane.org/gmane.comp.java.rife.user/1434 We don't use MySQL in production and rely pretty much

Re: [Rife-users] Strange MySQL-Problem w/ RIFE/Crud

2006-05-29 Thread Geert Bevin
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,

Re: [Rife-users] Strange MySQL-Problem w/ RIFE/Crud

2006-05-29 Thread Geert Bevin
I think that the main problem is (and that's the impression that I'm getting from their replies to these bug reports) that they don't think there's a problem. Basically, they are closing every opened connection automatically after 8 hours of inactivity. They then claim that it's up to the

Re: [Rife-users] Strange MySQL-Problem w/ RIFE/Crud

2006-05-29 Thread Stefan Thomas
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

Re: [Rife-users] Strange MySQL-Problem w/ RIFE/Crud

2006-05-29 Thread Stefan Thomas
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