Jdbc Connection using MySql DataBase

DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Jdbc Connection using MySql DataBase

  1. #1
    Join Date
    Feb 2008

    Jdbc Connection using MySql DataBase

    I had written the program JDBCConnection. i.e.,
     import java.sql.*;
       public class Connect
           public static void main (String[] args)
               Connection conn = null;
    	       String userName = "Root";
                   String password = "admin";
                   String url = "jdbc:mysql://localhost:3306/test";
                   Class.forName ("com.mysql.jdbc.Driver").newInstance ();
                   conn = DriverManager.getConnection (url,userName ,password );
                   System.out.println ("Database connection established");
               catch (Exception e)
                   System.err.println ("Cannot connect to database server");
    Here admin is mysql password.

    I had copied the mysql-connector-java-5.0.8-bin.jar file in the location of C:\Program Files\Java\jdk1.5.0\jre\lib folder and set the class path as same path.

    When i had compile the program it has compile successfully. But when i was runeed it has displayed an error message.

    Exception in thread "main" java.lang.NoClassDefFoundError: Connect

    Please tell me what is the mistake any one knows.
    Last edited by Hack; 02-26-2008 at 07:51 AM. Reason: Added Code Tags

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    Split from this resolved thread into its own thread.

  3. #3
    Join Date
    May 2007

    check class path for executable


    your compiler "javac" could see the classpath to the jar file.
    make sure your executable "java" can also see it.
    "javac" & "java" are two different programs, and they each require parameters.

    this is necessary especially in editors & IDEs that attempt to execute and compile. the parameter is required separately because the executable is different.

    hope this helps

Similar Threads

  1. Create Database Connection in the C#.net
    By ani.since1982 in forum .NET
    Replies: 2
    Last Post: 02-08-2008, 01:21 PM
  2. connecting mysql from eclipse
    By elix in forum Java
    Replies: 3
    Last Post: 10-02-2006, 12:15 AM
  3. Replies: 0
    Last Post: 12-11-2001, 01:01 PM
  4. Ado Connection
    By Sok Y. Kim in forum VB Classic
    Replies: 4
    Last Post: 10-30-2000, 12:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center