一、java通过JDBC连接Oracle
1.1工具类
package com.juhe.plugin.oracle.utils;
import com.juhe.plugin.oracle.bo.DatabaseBO;
import org.springframework.stereotype.Component;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* @author kiki
* @date 2023/4/1
* @description
*/
@Component
public class JdbcUtils {
public Connection getConnection(DatabaseBO databaseBO){
String name = "kiki";
String password = "*****";
String host = "20.0.0.124";
int port = 1521;
String sid = "helowin";
String url = "jdbc:oracle:thin:@" + host + ":" + port + ":" + sid;
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url,name,password);
System.out.println("连接成功");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (SQLException e){
e.printStackTrace();
}finally {
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return conn;
}
public static void main(String[] args) throws Exception{
JdbcUtils jdbcUtils = new JdbcUtils();
Connection connection = jdbcUtils.getConnection(new DatabaseBO());
System.out.println(connection.getMetaData());
}
}
1.2异常问题
1.2.1报错Got minus one from a read call错误解决办法
(1)排查所使用数据库版本Oracle自11g以后,向下兼容性明显下降,具体原因官方有说。。。
(2)如果以上版本都能对应的上,再看网上所谓的那些更改oracle配置文件 连接数什么的。