JNDI连接数据库

最新推荐文章于 2024-09-27 11:31:35 发布

chenming0733

最新推荐文章于 2024-09-27 11:31:35 发布

阅读量386

点赞数

文章标签： encoding jdbc oracle 数据库 class xml

本文链接：https://blog.csdn.net/chenming0733/article/details/6450277

版权

java学习专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1.在spring-config.xml文件中，加入jndi

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

2.新建一个xml文件，放在../apache-tomcat-6.0.18/conf/Catalina/localhost下面

<?xml version="1.0" encoding="UTF-8"?>
<Context docBase="D:/Workspaces/dlwyoa/WebRoot" reloadable="false">

<Resource name="DLWYOA_DS"
  auth="Container"
  type="javax.sql.DataSource"
  factory="org.apache.commons.dbcp.BasicDataSourceFactory"
  driverClassName="oracle.jdbc.OracleDriver"
  url="jdbc:oracle:thin:@192.168.1.27:1521:dlwynw"
  username="nwpt"
  password="nwpt"
  maxActive="24"
  maxIdle="5"
  maxWait="12000"
  timeBetweenEvictionRunsMillis="60000"
  numTestsPerEvictionRun="24"
  minEvictableIdleTimeMillis="600000"
  removeAbandoned="true"
  removeAbandonedTimeout="180"
  logAbandoned="true"
  validationQuery="select 1 from dual"
  validationQueryTimeout="3"
  testOnBorrow="false"
  testOnReturn="false"
  testWhileIdle="true"/>
</Context>