>Hi,
>
>I am trying to connect mysql database in jsp file. Mysql itself
>works well. but when I use jsp file, I got ClassNotFoundException
>caused by could not load JDBC/mysql Driver. I have installed
>mm.mysql.Driver.
Where did you install it?
> If connect by java code only, it works well. I do not know why the
>same kind of code does not work for jsp file, does my tomcat has any
>problem?
>
>I am in Linux, tomcat is working with Apache.
>
>This is the jsp code I am using:
>
>...
>
><%@page language="java"
> import="java.sql.*"%>
><%
> Connection con = null;
> try{
>
> System.out.println("start");
> Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> System.out.println("JDBC driver loaded");
>
> con = DriverManager.getConnection(
> "jdbc:mysql://localhost/zhaoding ?user=zhaoding&password=zhaoding");
> System.out.println("Database connection established");
>
> } catch(ClassNotFoundException cnfe){
> System.out.println("ClassNotFoundException: Could not locate driver");
> } catch(SQLException cnfe){
> System.out.println("SQLException:"+cnfe);
> } catch(Exception e){
> System.out.println("An unknow error occurred while connecting
>to the database");
> } finally {
> try{
> if(con!=null)
> con.close();
> }catch(SQLException sqle){
> System.out.println("Unable to close database connection.");
>
> }
> }
>%>
>...
>
>Thanks a lot for your time.
>
>Ying
>
>
>
>
>
>---------------------------------
>Do You Yahoo!?
>Yahoo! - Official partner of 2002 FIFA World Cup
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
