hi everyone.
i am an amateur programmer in java.
can anyone please tell me how do i go about connecting my java application to oracle 9i database?
please be specific about what is the URL that i should use and how should i install the oracle JDBC driver.where should i install it.
if it is already available with either JDK 1.5(which i am using) or oracle 9i. where can i locate it and how should i install it. please let me know all the details. thank you.

Here are the drivers of Oracle for java.
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Install the jar into the "\jre\lib\ext\" directory of wherever your jsdk is installed at.

This code would print out the database names on the server:

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
			String url = "jdbc:mysql://192.168.2.184/";
			String user = "guest";
			String password = "guestPass";
			connection = DriverManager.getConnection(url, user, password);
			DatabaseMetaData dbmd = connection.getMetaData();
			ResultSet result = dbmd.getCatalogs();
			databases.removeAllElements();
			while(result.next())
			{
				System.out.println(result.getString(1));
			}

Here are the drivers of Oracle for java.
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Install the jar into the "\jre\lib\ext\" directory of wherever your jsdk is installed at.

This code would print out the database names on the server:

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
			String url = "jdbc:mysql://192.168.2.184/";
			String user = "guest";
			String password = "guestPass";
			connection = DriverManager.getConnection(url, user, password);
			DatabaseMetaData dbmd = connection.getMetaData();
			ResultSet result = dbmd.getCatalogs();
			databases.removeAllElements();
			while(result.next())
			{
				System.out.println(result.getString(1));
			}

thank you very much sir.i did what u have told me to.
even then i am getting an error saying
"the network adapter could not establish a connection"

"no default driver specified"

"wrong data source name"

what could be the problem?

and put in the correct jdbc URI.
The example used a mySQL database as an example, and of course a different database name and machine.

See the documentation (which you should have, it's available from Oracle and I think comes with the driver) for the details.

This article has been dead for over six months. Start a new discussion instead.