Home » SQL & PL/SQL » SQL & PL/SQL » JDBC question
JDBC question [message #750] Fri, 01 March 2002 10:27 Go to next message
Chen Wen
Messages: 26
Registered: February 2002
Junior Member
How to connect to Oracle server by JDBC?
I tried by following codes, but failed.
1.
Driver driver =
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
DriverManager.registerDirver(driver);
Connection con =
DriverManager.getConnection("jdbc:oracle:oracle:@134.68.140.4:1521:orc
l","user","password");

2.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =
DriverManager.getConnection("jdbc:oracle:oracle:@134.68.140.4:1521:orc
l","user","password");
Re: JDBC question [message #754 is a reply to message #750] Fri, 01 March 2002 11:24 Go to previous messageGo to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi,

Try the following code, this works..

try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

conn = DriverManager.getConnection(url,dbUser,dbPass);
System.out.println(" Passed driver manager ");
stmt = conn.createStatement();
}
catch(SQLException e) {
throw new DbException(" Error in contructor : "+e.getMessage());
}
Re: JDBC question [message #783 is a reply to message #750] Mon, 04 March 2002 07:15 Go to previous message
Chen
Messages: 5
Registered: March 2002
Junior Member
Thanks a lot.
Previous Topic: Sql Queries
Next Topic: One JDBC question
Goto Forum:
  


Current Time: Tue Apr 23 15:01:16 CDT 2024