oracle jdbc url配置文件,jdbc连接oracle的url配置

服务器是单机的配置：

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

服务器是集群的配置：

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

2.jdbc.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =主机ip或主机名)(PORT = 端口号))(ADDRESS = (PROTOCOL = TCP)(HOST =主机ip或主机名)(PORT = 端口号))(FAILOVER=ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = 服务名)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))

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

通过服务器配置数据源：

通过JNDI来连接

Context ctx=new InitialContext();

ctx.lookup(SysConstant.JDBC_JNDI);

--集群

监听名称

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =主机ip或主机名)

(PORT = 端口号))(ADDRESS = (PROTOCOL = TCP)(HOST =主机ip或主机名)

(PORT = 端口号))(FAILOVER=ON)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = 服务名)

(FAILOVER_MODE =(TYPE = SELECT)

(METHOD = BASIC)

(RETRIES = 180)

(DELAY = 5)

)

)