连接集群的配置:

来源:互联网 发布:2k帕森斯脸型数据 编辑:程序博客网 时间:2024/05/27 14:12

java 代码在连接oracle时,根据oracle安装是单机还是RAC,此时jdbc的连接串或者连接方式有说不通

 

连接单机的配置:

jdbc.url=jdbc:oracle:thin:@192.168.1.12:1521:orcl

连接集群的配置:

1.jdbc.url=jdbc:oracle:thin:@192.168.1.12:1521/orcl

2.jdbc.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.204.7.87)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.204.7.89)(PORT = 1521))(FAILOVER=ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = tyyj)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))

一定不能有换行空格,否则会报找不到 host

通过服务器配置数据源:

通过JNDI来连接

      Context ctx=new InitialContext();

      ctx.lookup(SysConstant.JDBC_JNDI);

原创粉丝点击