One JDBC question [message #19137] |
Fri, 01 March 2002 10:28 |
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: One JDBC question [message #19145 is a reply to message #19137] |
Sat, 02 March 2002 18:08 |
ranni
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
import java.sql.*;
public class JDBCUtility {
/** will load driver for Oracle data base */
public static void loadOracleJDBCDriver () {
System.out.println ("Loading Register driver...");
try {
DriverManager.registerDriver ( new oracle.jdbc.driver.OracleDriver());
}
catch (SQLException e) {
System.err.println (e.getMessage ());
System.exit (1); // Driver error
}
System.out.println ("Register driver loaded...");
} //end loadOracleJDBCDriver() method
/** will load driver for Oracle data base */
/** will get connection for Oracle data base*/
public static Connection getConnectedOracle () {
System.out.println ("getting connection...");
Connection conn = null;
try {
String jdbc_url = "jdbc:oracle:thin:@localhost:1521:oracle";
conn = DriverManager.getConnection (jdbc_url, "scott", "tiger");
System.out.println ("connection created ...");
}
catch (SQLException e) {
System.err.println (e.getMessage () ) ;
System.exit (2); // Driver failure
}
return conn;
|
|
|
|