Connection Failing

[deepak carter]

Hi,

I have wriiten a sample program just fro testing its not showing any result

import java.sql.*;
class Test3
{
	public static void main(String[] args)
	{
		try
		{

			Class.forName ("oracle.jdbc.driver.OracleDriver");
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/orcl", "scott", "tiger");
			Statement st = conn.createStatement();
			  ResultSet res = st.executeQuery("SELECT * FROM  emp");
			  System.out.println("Employee Name: " );
			  while (res.next())
			  {
			  		int employeeName = res.getInt(1);
			  		System.out.println(employeeName );
			  }
			  conn.close();

		}
		catch(Exception e)
		{

		}
	}
}

I was reading some blog and it was written there that we have to download some drivers. from where we have to download drivers and what drivers we have to download and where we have to place those drivers


thanks in advance

[moderator edit: added code tags]

[Jan Cumps]

Hi Deepak,


In the catch block, you can print the exception you are getting. Currently it is empty, so you are running blind.
Can you show us the error message?

I added code tags to your post to make it more readable.

[Tina Smith]

If you don't have drivers, that's probably a problem, and your stack trace will probably be a ClassNotFoundException on line 09.

Since this is an Oracle database you will need to download the ojdbc6.jar or ojdbc14.jar (6 is newer) and put it in your classpath.

[deepak carter]

Hi,

its not showing any error code is compiling fine , but it shuld error the result which its not showing...the console ouptut screen is coming where its just written press any key to continue.

[Jan Cumps]

deepak carter wrote:Hi,

its not showing any error code is compiling fine , but it shuld error the result which its not showing...the console ouptut screen is coming where its just written press any key to continue.

Yes, because you don't print the errors.
See my previous advise:

In the catch block, you can print the exception you are getting. Currently it is empty, so you are running blind.