mybatis数据源(JNDI)

1.在Tomcat的context.xml文件中配置数据源参数

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <Context>
 3     <!-- Default set of monitored resources -->
 4     <WatchedResource>WEB-INF/web.xml</WatchedResource>
 5     <!-- Uncomment this to disable session persistence across Tomcat restarts -->
 6     <!--
 7             <Manager pathname="" />
 8             -->
 9     <!-- Uncomment this to enable Comet connection tacking (provides events
10                  on session expiration as well as webapp lifecycle) -->
11     <!--
12             <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />
13             -->
14     <Loader loaderClass="org.springframework.instrument.classloading.tomcat.TomcatInstrumentableClassLoader"/>
15      <!--<Loader loaderClass="com.springsource.insight.collection.tcserver.ltw.TomcatWeavingInsightClassLoader"/>
16     <Listener className="com.springsource.insight.collection.tcserver.lifecycle.ApplicationLifecycleCollectionListener"/>-->
17  
18  <Resource 
19          auth="Container" 
20          defaultAutoCommit="true" 
21          driverClassName="com.ibm.db2.jcc.DB2Driver" 
22          initialSize="0" 
23          logAbandoned="false" 
24          maxActive="5" 
25          maxIdle="2" 
26          maxWait="6000" 
27          minIdle="0" 
28          name="jdbc/testDs" 
29          password="db2admin" 
30          removeAbandoned="true" 
31          removeAbandonedTimeout="300000" 
32          type="javax.sql.DataSource" 
33          url="jdbc:db2://127.0.0.1:50000/test" 
34          username="db2admin" 
35          validationQuery="SELECT 1 FROM USER_INFO"/>
36 </Context>

 

2.mybatis配置文件中配置数据源

 1     <environments default="development">
 2         <environment id="development">
 3             <transactionManager type="JDBC" />
 4             <dataSource type="JNDI">
 5                 <!--  <property name="initial_context" value="java:comp/env" />-->
 6                  <property name="data_source" value="java:comp/env/jdbc/testDs" />
 7             </dataSource>
 8             <!-- 
 9             <dataSource type="POOLED">
10                 <property name="driver" value="${driverClassName}" />
11                 <property name="url" value="${url}" />
12                 <property name="username" value="${username}" />
13                 <property name="password" value="${password}" />
14             </dataSource>
15              -->
16         </environment>
17     </environments>

 

3.为了避免部署到websphere中lookup报错，在web.xml中加入resource引用

1     <resource-ref>
2       <description></description>
3       <res-ref-name>jdbc/testDs</res-ref-name>
4       <res-type>javax.sql.DataSource</res-type>
5       <res-auth>Container</res-auth>
6     </resource-ref>
posted @ 2014-07-23 10:56  havery  阅读(651)  评论(0)    收藏  举报