I am new to Java and developing a Swing application, so this project is all depending on JDBC, its very big project for me, i am trying to create a single Connection Class and use it in my entire project.
i have written a code to get connecton
package sab;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionManager {
private static String url = "jdbc:h2:~/test";
private static String driverName = "org.h2.Driver";
private static String username = "sa";
private static String password = "";
private static Connection connection;
private static String urlstring;
public static Connection getConnection() {
try {
Class.forName(driverName);
try {
connection = DriverManager.getConnection(url, username, password);
} catch (SQLException ex) {
// log an exception. fro example:
System.out.println("Failed to create the database connection.");
}
} catch (ClassNotFoundException ex) {
// log an exception. for example:
System.out.println("Driver not found.");
}
return connection;
}
public static void main(String[] args) {
getConnection();
}
}
but when ever i am trying to test connection it show
Failed to create the database connection.
Driver not found.
i dont Know what am doing wrong someone please help
