对于润乾报表中正常的连接oracle数据库,我们只需要在应用服务器中配置相应的数据库连接池文件即可。 我们以tomcat服务器为例,在tomcat安装目录的conf\Catalina\localhost下,新建一个与应用同名的xml文件: <?xml version='1.0' encoding='utf-8'?> <Context path="/reportmis" docBase="reportmis" debug="0" privileged="true"> <Resource name="demodatasource" auth="Container" type="javax.sql.DataSource" maxActive="10" maxIdle="30" maxWait="10000" username="scott" password="tiger" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:orcl" useUnicode="true" characterEncoding="GBK" /> </Context> 当我们使用oracle集群数据库时,url的写法发生了变化, url中要配置集群服务器的ip,serverName等。 <?xml version='1.0' encoding='utf-8'?> <Context path="/reportmis" docBase="reportmis" debug="0" privileged="true"> <Resource name="demodatasource" auth="Container" type="javax.sql.DataSource" maxActive="10" maxIdle="30" maxWait="10000" username="scott" password="tiger" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200. 180.193)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.180.194)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = cjww)))" useUnicode="true" characterEncoding="GBK" /> </Context> 参考上面的写法,只要把集群服务器的地址,端口,和服务名书写正确,就可以通过集群的方式来获取到数据库的连接了。 |