配置Tomcat5.5.X的Server.xml，在<host>下面加:
<Context path="/JNDIDemo" docBase="D:\workspace\JNDIDemo\WebRoot" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_quality_log." suffix=".txt" timestamp="true"/>
<Resource
name="jdbc/test" <!-- JNDI數據池名稱 -->
type="javax.sql.DataSource" <!-- 數據類 -->
password="karid" <!-- 密碼 -->
driverClassName="oracle.jdbc.driver.OracleDriver" <!-- 驅動 -->
maxIdle="2" <!-- 最少可用lia -->
maxWait="5000" <!-- 最大等待時間 5秒 -->
username="karid" <!-- 用戶名 -->
url="jdbc:oracle:thin:@127.0.0.1:1521:karid"
maxActive="4" <!-- 最大可用連接 --> />
<ResourceParams name="jdbc/test">
<parameter>
<name>removeAbandoned</name>
<!-- Abandoned DB connections are removed and recycled -->
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<!-- Use the removeAbandonedTimeout parameter to set the number of seconds a DB connection has been idle before it is considered abandoned. -->
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<!-- Log a stack trace of the code which abandoned -->
<value>false</value>
</parameter>
<parameter>
<name>factory</name>
<!--DBCP Basic Datasource Factory -->
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
</ResourceParams>
2、配置web.xml
- <description>MySQL Test App</description>
- <resource-ref>
- <description>DB Connection</description>
- <res-ref-name>jdbc/test</res-ref-name>
- <res-type>javax.sql.DataSource</res-type>
- <res-auth>Container</res-auth>
- </resource-ref>
3、JNDI使用
- public class DataSourceFactory
- {
- private static DataSource ds;
- public static DataSource createDataSourde()
- {
- if (ds == null)
- {
- try
- {
- Context initContext = new InitialContext();
- if (initContext == null)
- System.out.println("無配置環境");
- Context envContext = (Context) initContext.lookup("java:/compenv");
- ds = (DataSource) envContext.lookup("jdbc/test");
- }
- catch (NamingException e)
- {
- e.printStackTrace();
- }
- }
- return ds;
- }
- }
posted on 2009-03-24 11:43
lanxin1020 閱讀(148)
評論(0) 編輯 收藏 所屬分類:
DB