JDBC question [message #750] |
Fri, 01 March 2002 10:27 |
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 |
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());
}
|
|
|
|