First, several ways to load JDBC drivers
1. Register in DriverManager
Example: Register Oracle JDBC Driver in DriverManager
/ / Register Oracle JDBC Drive
Drivermanager.RegisterDriver (New Oracle.jdbc.OracleDriver ());
2. Direct loading
Second, a common problem
When connecting the Oracle 9i database in WebLogic 6.x, you may have a similar error:
Java.sql.sqlexception: ORA-00600: Internal error code, parameter: [TTCGCSHND-1], [0], [], [], [], [], [], []
Sample code:
/ / Register Oracle JDBC Drive
Drivermanager.RegisterDriver (New Oracle.jdbc.OracleDriver ());
// Note the format of the connection URL: JDBC: Oracle: Thin: @ip: port: SID
String Url = "JDBC: Oracle: Thin: @ 192.168.0.1: 1521: MYDB";
String username = "scott";
String password = "tiger";
Connection conn =
Drivermanager.getConnection (URL, Username, Password);
// Create a Statement
Statement Stmt = conn.createstatement ();
/ / Query employee name from the EMP table
ResultSet RS = Stmt.executeQuery ("SELECT Ename from EMP");
// Remove the first column in the result set, ie ENAME
While (rs.next ()) {
System.out.println (Rs.getstring (1));
}
Cause Analysis: The Oracle8i drive built in WebLogic's core package WebLogic.jar ($ WebLogic / LIB) is due to the use of Oracle8i drives to access Oracle9i.
Workaround: Include Classes12.zip or classes12.jar under $ oracle / ORA90 / JDBC / LIB in $ ORACLE / ORA90 / JDBC / LIB Add to Your WebLogic Current Domain ScriptWebLogic.cmd. Pay special attention, this .jar must be in WebLogic.jar!
