JDBC connection with oracle 10g

[ishani sharma]

hello.
my code:

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.Properties;

public class OracleConnect {

	public static void main(String s[]) throws Exception {
		Driver d = (Driver) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		
		Properties p = new Properties();
		p.put("user", "scott");
		p.put("password", "tiger");
		Connection con = d.connect("jdbc:oracle:thin:@oracle:8080:STUDENTINFO",p);

		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery("select * from StudentInfo");
		
		ResultSetMetaData rsmd = rs.getMetaData();
		System.out.println("Table Name : " + s[0]);
		int colcount = rsmd.getColumnCount();
		for (int i = 1; i <= colcount; i++) {
			System.out.print(rsmd.getColumnName(i) + "\t");
			System.out.println(rsmd.getColumnTypeName(i));
		}
		con.close();
	}
}

it throws error:
Exception in thread "main" java.lang.NullPointerException
at edu.trialpackage.databaseConnection.OracleConnect.main(OracleConnect.java:19)



can you please tell me where i am wrong..

[Vijitha Kumara]

I'm not sure about your approach to connect to DB (I really haven't tried it myself). But I suggest you to use DriverManager (for standalone applications) to get the connection to the DB, which is the preferred method. Check the JDBC tutorial

[Rob Spoor]

Line 19 is "Statement st = con.createStatement();" which can only mean that "con" is null. That means that d.connect("jdbc:oracle:thin:@oracle:8080:STUDENTINFO",p) returns null, which in turn means the URL is wrong.

I second Vijitha's advice to use DriverManager:

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();   
           
Properties p = new Properties();   
p.put("user", "scott");   
p.put("password", "tiger");   
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@oracle:8080:STUDENTINFO",p);

If there's a problem this will throw an SQLException instead of returning null.

[Avi Abrami]

For your information, class oracle.jdbc.driver.OracleDriver has been deprecated for many years now.
Its replacement is oracle.jdbc.OracleDriver.

Good Luck,
Avi.