Unable to connect to MySQL on another (unix) host from Eclipse on my windows host
I have Eclipse 3.4 on my Windows host. I have also installed Tomcat 6 and mysql-connector-java-5.1.7.jar on this host. I am trying to connect to MySQL (3.23.52) on a HP-UX box. I have access to the database as root on the unix host and as a user from this remote windows host.
I created the appropriate context.xml and also created a jsp file to query the database.
When I try to run, I am always ending up with an error as below.
javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"
I can provide other details regarding my setup if any of you care to reply me with some advise based on your prior experience. I spent quite bit of time but unable to resolve it. Any advise will be very much appreciated. If you prfer you can also email me directly at firstname.lastname@example.org