Oracle 9i installation on windows xp machine

[sabarmathi]

Hi i have installed oracle 9i client on my windows xp machine.should I need to install the corresponding server on my machine to start working? If yes, the server is freely availbale to download? I want to learn java/j2ee. For that i need oracle. can any one please help me?

[tyro]

hi, you did not need to install the Oracle Client. If all you want to do is practice oracle queries on your pc, you need to download oracle database server and install it. Oracle database is available to download at the link below:

http://www.oracle.com/technology/sof...01winsoft.html

However it's a heavy download so u better have a fast internet connection. It's very easy to install on a xp machine so you shouldn't have a issue.

[sabarmathi]

Hi thank u so much for the quick response. After installing this database server will i be able to access(insert/delete/update) the tables from the java page? Thanks in advance.

[sameer]

yes it is very easy to connect to oracle with java , you have to use some code like, (not tested)

import java.sql.*;
 
class demo
{
public static void main (String args [])
throws SQLException
	{
 
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 
	Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@db_server:1521:orcl","scott", "tiger");
 
	Statement stmt = conn.createStatement ();
 
	ResultSet rset = stmt.executeQuery ("select * from employee_table");
 
	while (rset.next ())
	System.out.println (rset.getString (1));
	}
}

Hope it helps

[sabarmathi]

Thank you Sameer....

[sabarmathi]

Hi Tyro & Sameer,

I downloded the complete package (Download the Complete Files) from the url you specified and i installed it on my machine. Now I'm able to see 'SQL plus' from start-> programs-> Oracle oraHome92->application development->SQL Plus. When I try to open the SQL plus its asking for username,password and host string..

What should i enter for the host string?

Please advice..Thanks in advance..

[tyro]

if your database is installed on your laptop you don't need a connection string, just enter scott for user and tiger for password.