JNDI

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>