tomcat中配置JNDI方法

1、项目中spring的数据源配置:

    <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName" value="java:comp/env/jdbc/test" />
    </bean>

2、项目中web.xml中的配置

    <resource-ref>
        <res-ref-name>jdbc/test</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
        <res-sharing-scope>Shareable</res-sharing-scope>
    </resource-ref>

3、tomcat中tomcat\conf\server.xml中的配置


  <GlobalNamingResources>
    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users
    -->
    <Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>
    <Resource name="jdbc/test" auth="Container" type="javax.sql.DataSource"
                               url="jdbc:oracle:thin:@192.168.2.123:1521:orcl"
                           driverClassName="oracle.jdbc.driver.OracleDriver"
                           password="test123"
                           username="testname"
                           initialSize="5"
                           maxActive="10"
                           maxIdle="5"
                           minIdle="2"
                           maxWait="10000"
                           removeAbandoned="true"
                           logAbandoned="true"
                           removeAbandonedTimeout="60"
                           timeBetweenEvictionRunsMillis="900000"
                           minEvictableIdleTimeMillis="1800000"
                           numTestsPerEvictionRun="100"
                           validationQuery="select count(0) from dual"
                           poolPreparedStatements="true"
                           maxOpenPreparedStatements="100"/>
     
  </GlobalNamingResources>
 
4、context.xml中的配置
<ResourceLink global="jdbc/test" name="jdbc/test" type="javax.sql.DataSource"/>

配置完成

 

 

posted on 2017-05-05 16:43  锟斤拷锟斤拷  阅读(452)  评论(0编辑  收藏  举报

导航