Question

javaf怎么连接oracle 数据库连接有两个IP

Answer 1

晕,这描述的JAVAF是么子东东,难道是打错了,我可不可以理解成,用JAVA做的一个系统,需要连接一个、两个甚至是多个不同地址的数据库服务器，
我们项目就用了两个不同地址的服务器
配两个数据源
<bean id="sqlserverSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.SSdriverClassName}" />
<property name="url" value="${jdbc.SSurl}" />
<property name="username" value="${jdbc.SSusername}" />
<property name="password" value="${jdbc.SSpassword}" />
</bean>

<bean id="ssJdbcTemplate"
class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="sqlserverSource" />
</bean>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"
value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive" value="100" />
<property name="maxWait" value="1000" />
<property name="poolPreparedStatements" value="true" />
<property name="defaultAutoCommit" value="true" />
</bean>
<bean id="jdbcTemplate"
class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
调用的时候用不同的jdbcTemplate就可以了，SQL的是ssJdbcTemplate，oracle的是jdbcTemplate
乘下的和操作一个库没啥分别

Answer 2

多加一个address就可以了，代码如下：
instance =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1_1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1_2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle_server)
)
)

Answer 3

jdbc:oracle:thin:@(description=(address_list=
(address=(protocol=tcp)(port=1610)(host=webHost))
(address=(protocol=tcp)(port=1521)(host=oraHost)))
(connect_data=(INSTANCE_NAME=orcl))
(source_route=yes))";