code to connect jsp page to oracle 9i

[mallz]

hi,
im new to programming in jsp and i need to connect to oracle db.
i could connect to ms access using the following code

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:cust_pr oj");
st=con.createStatement();
but, i dont know how to connect to oracle.
Please help. also, what seetings to i need to set in control panel for the connection?

[gopiinamadar]

i also have same problem with oracle 9i connection..

if you get solution to this problem plz reply me

thanks

[fizeau]

hi
iam working with oracle 10g and asp.net (c#) and i can connect to my oracle data base throw the below code
try it may it work with you :

OracleConnection oraclConn = new OracleConnection(ConfigurationManager.ConnectionSt rings["ConnectionString"].ToString());
OracleDataAdapter oraclDataAdapt = new OracleDataAdapter("select id ,name , description from adressbooktemp where USERID ="+usrId , oraclConn);
DataSet oraDataSet = new DataSet();
oraclDataAdapt.Fill(oraDataSet);
GridView1.DataSource = oraDataSet;
GridView1.DataBind();

if it works with u just tell me :D