JSP/MySql and JDBC/MySql

[ak1dnar]

I have downloaded and copied the this Connector/j to lib directory of my java installation dir.

and this Jsp page is working with that.

<%@ page language="java" import="java.sql.*" %>
 
<%
    String driver = "org.gjt.mm.mysql.Driver";
    Class.forName(driver).newInstance();
 
 
    Connection con=null;
    ResultSet rst=null;
    Statement stmt=null;
 
 
    try
    {
        String url="jdbc:mysql://localhost/books?user=root&password=dba";
        con=DriverManager.getConnection(url);
        stmt=con.createStatement();
        out.println("Connected");
    }
    catch(Exception e)
    {
        out.println(e.getMessage());
    }
%>

But I couldn't get connect with this java file.

import java.sql.*;
 
public class LoadDriver
{
    public static void main(String[] args)
    {
        try
        {
        Connection con=null;
        Class.forName("org.gjt.mm.mysql.Driver").newInstance();
        String url="jdbc:mysql://localhost/books?user=root&password=dba";
        con=DriverManager.getConnection(url);
        System.out.println("Connected...");
        }
        catch (Exception ex)
        {
           System.out.println(ex.getMessage());
        }
}
}

The exception is the name of the driver. how to solve this problem.

[menmysql]

hey i got connected with your code only why ur not
can you send what error ur getting.iam waiting for ur reply

I have downloaded and copied the this Connector/j to lib directory of my java installation dir.

and this Jsp page is working with that.

<%@ page language="java" import="java.sql.*" %>
 
<%
    String driver = "org.gjt.mm.mysql.Driver";
    Class.forName(driver).newInstance();
 
 
    Connection con=null;
    ResultSet rst=null;
    Statement stmt=null;
 
 
    try
    {
        String url="jdbc:mysql://localhost/books?user=root&password=dba";
        con=DriverManager.getConnection(url);
        stmt=con.createStatement();
        out.println("Connected");
    }
    catch(Exception e)
    {
        out.println(e.getMessage());
    }
%>

But I couldn't get connect with this java file.

import java.sql.*;
 
public class LoadDriver
{
    public static void main(String[] args)
    {
        try
        {
        Connection con=null;
        Class.forName("org.gjt.mm.mysql.Driver").newInstance();
        String url="jdbc:mysql://localhost/books?user=root&password=dba";
        con=DriverManager.getConnection(url);
        System.out.println("Connected...");
        }
        catch (Exception ex)
        {
           System.out.println(ex.getMessage());
        }
}
}

The exception is the name of the driver. how to solve this problem.

[menmysql]

sorry i did not mentioned in my previous post i.e., i got only in jsp and not in java file. i am also intrested in this topic. if you got any replys plz keep here i will try to refer


thanku

[ak1dnar]

This is the installation Mannual for Connector/j, Only thing i did for now I just copied that jar file and put it to the lib directory in JAVA installation dir. and it works for my JSP apps. but the problem with Java. as the exception its returning this class names.

i used both com.mysql.jdbc.Driver and org.gjt.mm.mysql.Driver

Installing the Driver and Configuring the CLASSPATH
Once you have extracted the distribution archive, you can install the driver by placing mysql-connector-java-[version]-bin.jar in your classpath, either by adding the full path to it to your CLASSPATH environment variable, or by directly specifying it with the command line switch -cp when starting your JVM.

If you are going to use the driver with the JDBC DriverManager, you would use com.mysql.jdbc.Driver as the class that implements java.sql.Driver.

[zubair Alam]

Hello Sir,
i have recieve u r solution but i write same code but herewith classNotFound exception is arising