Class loading error in Jdbc

Question

I just created a Class Jdbc when i tried to run an error is shown.

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

Here's the code

import java.sql.*;
public class Jdbc {
    public static void main(String [] args)
    {
        try{
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/ims","","");
        Statement st=con.createStatement();
        DatabaseMetaData meta=con.getMetaData();
        ResultSet r=meta.getTables(null,null,"%",null);
        String tableNames="";
        while(r.next()){
        tableNames=r.getString(3);
        System.out.println(tableNames);
        }
        }catch (Exception e){}}}

no need to call `.newInstance` while loading the class. And set the classpath properly to mysql Driver. — Vishal K, Mar 25 '13 at 07:07
Did you compile the code with javac before trying to run it? This is a generic error unrelated to jdbc. — Joni, Mar 25 '13 at 07:08
See this http://stackoverflow.com/questions/11380681/jdbc-java-lang-noclassdeffounderror-could-not-initialize-class-com-mysql-jdb — tostao, Mar 25 '13 at 07:09

score 0 · Answer 1 · answered Mar 25 '13 at 07:08

0

Its most likely that your program is not able to find the class
Place the mysql jdbc driver mysql-connector-java-5.x.x.jar in classpath and then check.

answered Mar 25 '13 at 07:08

Alankar Srivastava

844
5
18

score 0 · Answer 2 · edited May 23 '17 at 12:21

0

The 2 quick fixes would be either

1) Pass the classspath to the execution java -classpath mysql.jar

See

JAVA classpath pass file as command line argument

2) Put the mysql jar in your JRE's extdirectory. Details.

You probably want to put your class in a package since you're using the default package. Also an IDE such as Eclipse could help you for convienience. You don't tell us your execution environment or build path and your result may depend on if you're running the program from the command line, from a runnable jar or from an IDE.

I use the Eclipse Juno IDE so I don't need to worry about setting my classpath. For Ubuntu and MS-Windows, Eclipse IDE is a development environment you might want to use.

edited May 23 '17 at 12:21

Community

1
1

answered Mar 25 '13 at 07:10

Niklas Rosencrantz

25,640
75
229
424

i just use text editor only for jdbc demo – Mar 25 '13 at 07:15
@Gaurav Ok, to run your program, first make sure you actually have the jar from mysql or you can get it from the link listed here. – Niklas Rosencrantz Mar 25 '13 at 07:15

score 0 · Accepted Answer · answered Mar 25 '13 at 07:12

0

The issue is not with mysql jar but your own class "Jdbc" is not on classpath, add it to classpath.

If you are running from console add .; to classpath.

answered Mar 25 '13 at 07:12

Abdullah Shaikh

2,567
6
30
43

score 0 · Answer 4 · answered Mar 25 '13 at 07:13

0

!. Make sure that the jar is in your class path
2. If not then download it from here

answered Mar 25 '13 at 07:13

Foredoomed

2,219
2
21
39

i got the solution i just add class file path in my class path nor problem with connector thanks every one – Mar 25 '13 at 07:19

Class loading error in Jdbc

4 Answers4