JSP database error

[naharol]

when i run this code i got an error .... can any body help me out ?

<%@page import="java.sql.*"%>
<form action="index.jsp?pg=13" method="post">
<table>
<tr><td>class:</td><td><select name="cl">
<option value="">class</option>
<%
String connectionURL="jdbc:mysql://localhost:3306/intranet?";
Connection cn=null;
Statement st=null;
ResultSet rs=null;
cn = DriverManager.getConnection(connectionURL, "root","");
st = cn.createStatement();
rs = st.executeQuery("SELECT * FROM class");
while(rs.next())
{
	out.print("<option value='"+rs.getString("class")+"'>"+rs.getString("class")+"</option>");
}

%>
</select></td></tr>
<tr><td>sub1:</td><td><input type="text" name ="sub1"></td></tr>
<tr><td>sub2:</td><td><input type="text" name ="sub2"></td></tr>
<tr><td>sub3:</td><td><input type="text" name ="sub3"></td></tr>
<tr><td>sub4:</td><td><input type="text" name ="sub4"></td></tr>
<tr><td>sub5:</td><td><input type="text" name ="sub5"></td></tr>
<tr><td>sub6:</td><td><input type="text" name ="sub6"></td></tr>
<tr><td><input type="submit" value="save"/></td></tr></table>
</form>

when running this i got an error message


HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasp er.JasperExcept ion: Exception in JSP: /subjent.jsp:11

8: Connection cn=null;
9: Statement st=null;
10: ResultSet rs=null;
11: cn = DriverManager.g etConnection(co nnectionURL, "root","");
12: st = cn.createStatem ent();
13: rs = st.executeQuery ("SELECT * FROM class");
14: while(rs.next() )


Stacktrace:
org.apache.jasp er.servlet.JspS ervletWrapper.h andleJspExcepti on(JspServletWr apper.java:451)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 355)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:329)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :265)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:729)


root cause

javax.servlet.S ervletException : No suitable driver found for jdbc:mysql://localhost:3306/intranet?
org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:841)
org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:774)
org.apache.jsp. subjent_jsp._js pService(subjen t_jsp.java:77)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:98)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:729)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 331)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:329)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :265)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:729)


root cause

java.sql.SQLExc eption: No suitable driver found for jdbc:mysql://localhost:3306/intranet?
java.sql.Driver Manager.getConn ection(Unknown Source)
java.sql.Driver Manager.getConn ection(Unknown Source)
org.apache.jsp. subjent_jsp._js pService(subjen t_jsp.java:53)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:98)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:729)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 331)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:329)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :265)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:729)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.


--------------------------------------------------------------------------------

Apache Tomcat/5.5.27

[Dormilich]

root cause

javax.servlet.S ervletException : No suitable driver found for jdbc:mysql://localhost:3306/intranet?

well, seems like you didn’t use the correct DB driver

[naharol]

how to correct my DB driver ..... if it is found incorrect.

Thanking you.

[Dormilich]

I have no idea but I’d try

jdbc://localhost:3306/intranet