oracle 12546
Oracle 12546是一个常见的数据库错误码,出现该错误的情况通常是由于数据库连接被拒绝或者连接超时等原因导致的。在实际使用中,遇到该错误码需要进行相关的处理才能正常使用数据库,否则就会导致无法连接数据库的问题。
下面是一个使用Oracle 12546连接数据库的示例:
import java.sql.*;
public class OracleConnection {
public static void main(String[] args) {
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String username = "scott";
String password = "tiger";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM EMP");
while (rs.next()) {
System.out.println(rs.getInt(1) + " " + rs.getString(2)
+ " " + rs.getString(3) + " " + rs.getInt(4));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs != null)
rs.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}