1.1 TOMCAT中JDNI部署方法
1、在server.xml中的<GlobalNamingResources></GlobalNamingResources>属性中增加<Resource
name="testgytms"
auth="Container"
type="javax.sql.DataSource"
password="tms"
username="tms"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:TMSTEST"
maxIdle="200"
maxWait="5000"
maxActive="200"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
/>
2、在context.xml的<Context></Context>的属性中增加
<ResourceLink name="testgytms" type="javax.sql.DataSource" global="testgytms"/>
3、在web.xml中增加
<resource-ref>
<description>my DB Connection</description>
<res-ref-name>testgytms</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
1.2 项目中JNDI的配置方法
在项目中将配置文件dataSourceContext.xml,将原来的连接方式
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName">
<value>oracle.jdbc.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@127.0.0.1:1521:TMSTEST</value>
</property>
<property name="username">
<value>tms</value>
</property>
<property name="password">
<value>tms</value>
</property>
<property name="maxActive">
<value>200</value>
</property>
</bean>
改成
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/testgytms</value>
</property>
</bean>
报表服务修改方式
原
<jdbc-ds-configs>
<jdbc-ds-config>
<name>gytms</name>
<db-type>oracle</db-type>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:TMSTEST</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>tms</user-name>
<password>tms</password>
<db-charset>utf-8</db-charset>
<client-charset>utf-8</client-charset>
<extend-properties></extend-properties>
</jdbc-ds-config>
</jdbc-ds-configs>
改成
<config>
<name>JNDIPrefix</name>
<value>java:comp/env/</value>
</config>
<config>
<name>dataSource</name>
<value>testgytms,oracle,GBK;</value>
</config>