How do I get my web application to connect to mysql again?
Posted on 2007-10-07
I am having this weird issue with my jsp application when trying to connect to mysql. It started to occur when I migrated from netbeans 5.5 to the netbeans 6 beta... in 5.5 I was using tomcat is the integrated j2ee server, however, in 6 they now use sun java application server 9.1, somewhere between the two my application stopped being to read the mysql database even though the connector jar is included in the package as a library. Here is what I get when I attempt to login to my application:
HTTP Status 500 -
type Exception report
descriptionThe server encountered an internal error () that prevented it from fulfilling this request.
javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.4/pdev"
javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.4/pdev"
note The full stack traces of the exception and its root causes are available in the Sun Java System Application Server 9.1 logs.
Sun Java System Application Server 9.1
Again the mysql connector is already included in the package.. so that fact that it cannot find a driver is beyond me.
A working fix to this problem is worth 500 points.