No suitable driver found for jdbc:oracle:thin:@localhost:1521:CON

[Arun Giridharan]

My FirstCode in jdbc

                Class class1 = ClassLoader.getSystemClassLoader().loadClass("oracle.jdbc.driver.OracleDriver");
		System.out.println(class1.getName());
		Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:CON", "learn", "learn");
		Statement statement = connection.createStatement();
		ResultSet resultSet = statement.executeQuery("SelEct * From eMPLOYEE");
		System.out.println(resultSet);
		/*System.out.println(resultSet.getCursorName());*/
		System.out.println("E_ID\tNAME\tGPA\tJOIN_DATE");
		while (resultSet.next()) {
			System.out.print(resultSet.getInt(1));;
			System.out.print("\t"+resultSet.getString(2));
			System.out.print("\t"+resultSet.getInt(3));
			System.out.print("\t"+resultSet.getDate(4));
			System.out.println();
		}

error :
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:CON
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.cls.demo.JdbcDemo.main(JdbcDemo.java:35)

1)what is this thin driver ?

jdbc:oracle:thin:@localhost:1521:CON

what does this say ?

[Jan Cumps]

The Thin driver is a jdbc library that allows you to connect to an Oracle database without needing Oracle client software.

You can download it from Oracle.

[Arun Giridharan]

Why i am keep getting this Exception ?? What's Wrong

Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc: oracle:thin:@localhost:1521:CON
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.cls.demo.JdbcDemo.main(JdbcDemo.java:35)

[Jan Cumps]

You get this error because you did not make the oracle jdbc thin driver library available when running your program.

Download the Oracle jdbc library.
add it to the classpath when running your program.

This line of code seems odd : Class class1 = ClassLoader.getSystemClassLoader().loadClass("oracle.jdbc.driver.OracleDriver");
Where did you learn to load a driver class that way?

[Arun Giridharan]

Jan Cumps wrote:You get this error because you did not make the oracle jdbc thin driver library available when running your program.

Download the Oracle jdbc library.
add it to the classpath when running your program.

I have Added.

Jan Cumps wrote:This line of code seems odd : Class class1 = ClassLoader.getSystemClassLoader().loadClass("oracle.jdbc.driver.OracleDriver");
Where did you learn to load a driver class that way?

No,why so?

[Jan Cumps]

I was expecting to see : Class.forName ("your driver class");
(and with JDBC 4 drivers you can completely skip loading the driver)

[Arun Giridharan]

It Worked fine!now!