mySQL stops responding in the morning

2003-03-17 Thread amit . mehta
I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has died and mySQL does not respond anymore. What nee

Views

2003-02-14 Thread amit . mehta
I wanted to use the Views feature that is available in Oracle which is the counterpart of Queries available in MS Access. mySQL does not support views at the moment. Is there a way I can achieve my goals ? The purpose of having a view/query is that I want to access data from that view/query throug