• 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中tomcatconfserver.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"/>
    
    

    配置完成

     
  • 相关阅读:
    MySQL 存储过程 (2)
    MySQL 存储过程
    MySQL 数据库常用命令
    oracle 控制文件多路复用
    oracle定时清理日志操作
    git 常用的分支技巧
    golang tcp keepalive实践
    TCP keepalive的详解(解惑)
    勾践为什么卧薪尝胆
    golang context学习记录1
  • 原文地址:https://www.cnblogs.com/shaohz2014/p/6813769.html
Copyright © 2020-2023  润新知