Thread: JDBC CONNECTION ERROR in eclipse

I can't get my post to be excepted.

I am a Java beginner.

I am trying to connect to our oracle database through Eclipse. I have the following package.

We are at Oracle 11g Java 1.7 I have the ojdbc7.jar driver downloaded and placed in the classpath.

Yet I keep getting the error below:

No sure if this is an Eclipse problem, my code, or both.

 //connection code
package testConnect;
import java.sql.*;
import oracle.jdbc.OracleDriver;
 
public class JdbcThinTnsNamesTest {
    public JdbcThinTnsNamesTest() {
        System.setProperty("oracle.net.tns_admin",
                "$TNS_ADMIN");
    }
 
    public static Connection getConnection() throws SQLException {
        String username = "user";
        String password = "password";
        String thinConn = "jdbc:oracle:thin:@//NCPP";
        DriverManager.registerDriver(new OracleDriver());
        Connection conn = DriverManager.getConnection(thinConn, username,
                password);
        conn.setAutoCommit(false);
        return conn;
    }
    //
    public void run() throws SQLException {
        Connection conn = getConnection();
        System.out.println("Auto Commit = " + conn.getAutoCommit());
        conn.close();
    }
 
    public static void main(String[] args) {
        JdbcThinTnsNamesTest test = new JdbcThinTnsNamesTest();
        try {
            test.run();
            System.out.println("all done..");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
 
}
 
package oracle.jdbc;
 
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverPropertyInfo;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.util.Properties;
import java.util.logging.Logger;
 
public class OracleDriver implements Driver {
 
	@Override
	public Connection connect(String url, Properties info) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
 
	@Override
	public boolean acceptsURL(String url) throws SQLException {
		// TODO Auto-generated method stub
		return false;
	}
 
	@Override
	public DriverPropertyInfo[] getPropertyInfo(String url, Properties info)
			throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
 
	@Override
	public int getMajorVersion() {
		// TODO Auto-generated method stub
		return 0;
	}
 
	@Override
	public int getMinorVersion() {
		// TODO Auto-generated method stub
		return 0;
	}
 
	@Override
	public boolean jdbcCompliant() {
		// TODO Auto-generated method stub
		return false;
	}
 
	@Override
	public Logger getParentLogger() throws SQLFeatureNotSupportedException {
		// TODO Auto-generated method stub
		return null;
	}
 
}

java.sql.SQLException: No suitable driver found for jdbcracle:thin:@//NCPP
at java.sql.DriverManager.getConnection(DriverManager .java:596)
at java.sql.DriverManager.getConnection(DriverManager .java:215)
at testConnect.JdbcThinTnsNamesTest.getConnection(Jdb cThinTnsNamesTest.java:17)
at testConnect.JdbcThinTnsNamesTest.run(JdbcThinTnsNa mesTest.java:24)
at testConnect.JdbcThinTnsNamesTest.main(JdbcThinTnsN amesTest.java:32)

Thanks Ada,

Followed your suggestion. Ran program again and get the following errror.

Error: Could not find or load main class oracle.sql.CharacterSetFactory