JDBC with oracle

[Ravissant Markenday]

Hi Everyone! could anyone please tell me how i can do database connectivity using the oracle database.
Following is the code i wrote but the table "rosm" just does'nt get updated

 try
 {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection("jdbc:odbc:Mydsn_oracle,ravissant,ravissant");
 
  Statement s=con.createStatement();
 
 
  s.executeUpdate("INSERT INTO rosm  VALUES('"+req.getParameter("lid")+"','"+req.getParameter("pwd")+"')");
 
   }
  catch(Exception e)
   {
   }

thanks a lot in advance,
Ravissant

[Ravissant Markenday]

hi again, well i figured it out by myself,but then again i have some doubts.I found 2 approaches of which i could get only one working.
First, the approach i could'nt get, im including only the code snippents i did'nt understant:

import oracle.jdbc.driver.*;
 
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@training:1521:Oracle","oratest","oratest");

could anyone please descriptively tell me what "jdbcracle:thin:@training:1521:Oracle" is?

Moving on to the second approach:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection 
 
con=DriverManager.getConnection("jdbc:odbc:Mydsn_oracle","ravissant","
 
ravissant");

could anyone please tell me what the DSN exactly does?
Also I'd really appreciate it if someone could tell me the exact difference between the two approaches.

Thanks a lot,
Ravissant

[Herman Schelti]

hi Ravissant,

first question: jdbcracle:thin:@training:1521:Oracle is the URL of your database.
jdbc = connection type
oracle = your database
thin = drivertype
training = machinename
1521 = portnumber
Oracle = databasename

second question: jdbcdbc:Mydsn_oracle
Mydsn_oracle is the name of your ODBC-datasource
(should be somewhere in settings - control panel - administrative tools)

third question: difference between those two:
The first tries to connect to the database using the Oracle driver, the second one uses the JDBC-ODBC bridge as driver (not meant for production-code)

Hope this helps,
Herman