1、
private static String url = "jdbc:oracle:thin:@172.16.xx.x:1521:ZYH";
private static String user = "users";
private static String password = "123456";
2、
// 初始化驱动包
Class.forName("oracle.jdbc.driver.OracleDriver");
我查看了百度这些 语法这些都没有错吧,但是就不成功
注释掉的那段是能连接上的
ZYHIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.xx.x)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = zyhis)
)
)
该配置的都配置 了,就不知道为什么不成功,请各位大佬多多指教
用plsql能直接连上数据库吗?
在oracle里面通过sid连接,一般情况下sid与实例名相同,如果实例名连接不上,
可以通过登录system账号。
select instance_name from V$instance
通过上面这条sql查询sid.
//用的sid
private static String url = "jdbc:oracle:thin:@localhost:1521:neworcl";
//用的service_name,我的这两个一样
private static String url = "jdbc:oracle:thin:@localhost:1521/neworcl";
service_name是下面这种
tns配置,需要的是这个service_name
ceshi =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = neworcl)
)
)
参考这个
https://www.cnblogs.com/lixuwu/p/7127148.html