suhailafroz

 Profile Answers by suhailafroz Questions by suhailafroz

• Sep 2nd, 2006

 

we have four different ways in connecting to oracle or any database

create a dsn first then use the following statements

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:dsnname","username","password");

Statement stmt = con.createStatement();

phani

• Oct 9th, 2006

 

first find what kind of driver ur using...

if ur using oracle10g (ie type 4 driver)the code is

class.forName("Oracle.jdbc.driver.OracleDriver");

connection con=DriverManager.getConncetion("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");

Statement stmt=con.createstatement();