how to connect mysql with tomcat?

Question

i have a database in mysql and tomcat as application server i want to monitor the database through tomcat
how can i connect tomcat to mysql
any step by step instructions?

Answer 1

Take a look at this link from the Tomcat website. The sample shows how to create a simple JSP to display records from a MySQL table. As for monitoring the database, you'll have to be a bit more specific about that. Are you wanting to be alerted for new records, changed records, database status, etc... Some situations may be handled better through SMTP or RSS notification rather than a JSP page.