Discussions
Categories
- 385.5K All Categories
- 4.9K Data
- 2.5K Big Data Appliance
- 2.4K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Class not Found Prob with JDBC

Hi,
I am getting this problem. But this time, i have set the CLASSPATH variable correctly.
>java FirstExample
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at FirstExample.main(FirstExample.java:31)
Goodbye!
>echo %CLASSPATH%
\download\mysql-connector-java-5.0.8-bin.jar;.
Code is little bit changed:
import java.sql.*;
import javax.swing.*;
import java.util.ArrayList;
public class FirstExample {
// JDBC driver name and database URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/ebooksshop";
// Database credentials
static final String USER = "root";
static final String PASS = "";
static ArrayList<String> items = new ArrayList<String> ( );
String sql="";
ResultSet rs= null;
static int recordCnter=0;
static String id="";
static String title="";
static String author= "";
static String price="";
static String quantity ="";
static String pages = "";
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try{
//STEP 2: Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//STEP 3: Open a connection
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,USER,PASS);
//STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT * FROM books";
ResultSet rs = stmt.executeQuery(sql);
//STEP 5: Extract data from result set
while(rs.next()){
//Retrieve by column name
id = rs.getString("id");
title = " " + rs.getString("title");
author = " " + rs.getString("author");
price = " " + rs.getString("price");
quantity = " " + rs.getString("qty");
pages = " " + rs.getString("pages");
String record = id + price + quantity + pages;
items.add(record);
//Display values
//System.out.print("name: " + name);
//System.out.print(", owner: " + owner);
}
String strData="";
String[] fieldValue;
while (recordCnter < items.size( )){
strData=items.get(recordCnter);
fieldValue=strData.split("\\s+");
JOptionPane.showMessageDialog(null,fieldValue);
recordCnter++;
}
//STEP 6: Clean-up environment
rs.close();
stmt.close();
conn.close();
}catch(SQLException se){
//Handle errors for JDBC
se.printStackTrace();
}catch(Exception e){
//Handle errors for Class.forName
e.printStackTrace();
}finally{
//finally block used to close resources
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){
}// nothing we can do
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}//end finally try
}//end try
System.out.println("Goodbye!");
}//end main
}//end FirstExample
Somebody please guide me.
Zulfi.
Best Answer
-
Hi,
This problem has been solved now. I was actually using wrong value for CLASSPATh. The correct values is:
\download_nz\mysql-connector-java-5.0.8-bin.jar;.
Zulfi.
Answers
-
Hi,
This problem has been solved now. I was actually using wrong value for CLASSPATh. The correct values is:
\download_nz\mysql-connector-java-5.0.8-bin.jar;.
Zulfi.