On 9/22/07, fdehghani <[EMAIL PROTECTED]> wrote: > > but when running its service, after sometime when run my project,tomcat say > that can not connect to database(SystemException) > then i should restart its service to work correctly. > i'm not sure thet its tomcat's problem or MySql
If a TC restart "fixes" it, the problem is almost certainly your app :-) Sounds like you're not closing connections somewhere. If you're using connection pooling, set the pool size to 1 and you'll find the problem pretty quickly... HTH, -- Hassan Schroeder ------------------------ [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]