我使用的是Tomcat 6.0.14 + Proxool 0.9.1
Jndi在tomcat下做配置
先把需要的包复制进 %tomcat_path%\lib
需要的包为:
proxool-0.9.1.jar
proxool-cglib.jar2个Proxool包,没什么好说的
ojdbc14.jarOracle-JDBC驱动包
commons-logging-1.0.4.jarlogging包,不放进去可能会报错
上面的包放进%tomcat_path%\lib之后,就不需要在项目中引入了,否则会报错
包放入之后,就可以配置Jndi了...
打开%tomcat_path%\conf\context.xml
在里面有一个Context 的Tag
<Context>
........
</Context>
在里面插入以下代码
<
Resource
auth
="Container"
delegateProperties ="foo=bar"
factory ="org.logicalcobwebs.proxool.ProxoolDataSource"
name ="/jdbc/mydatasource"
user ="user"
password ="password"
proxool.alias ="proxool_testdb"
proxool.driver-class ="oracle.jdbc.driver.OracleDriver"
proxool.driver-url ="jdbc:oracle:thin:@127.0.0.1:1521:pub"
proxool.maximum-connection-count ="5"
proxool.maximum-active-time ="10000"
proxool.house-keeping-sleep-time ="180000"
proxool.house-keeping-test-sql ="SelectSysdateFromdual"
proxool.prototype-count ="2"
type ="javax.sql.DataSource" />
delegateProperties ="foo=bar"
factory ="org.logicalcobwebs.proxool.ProxoolDataSource"
name ="/jdbc/mydatasource"
user ="user"
password ="password"
proxool.alias ="proxool_testdb"
proxool.driver-class ="oracle.jdbc.driver.OracleDriver"
proxool.driver-url ="jdbc:oracle:thin:@127.0.0.1:1521:pub"
proxool.maximum-connection-count ="5"
proxool.maximum-active-time ="10000"
proxool.house-keeping-sleep-time ="180000"
proxool.house-keeping-test-sql ="SelectSysdateFromdual"
proxool.prototype-count ="2"
type ="javax.sql.DataSource" />
这样,Jndi就配置完成了......
然后在程序里面可以这么得到DataSource和Connection:
try
{
Contextctx = new InitialContext();
DataSourcedataSource = (DataSource)ctx.lookup( " java:comp/env/jdbc/mydatasource " );
Connectionconn = dataSource.getConnection();
} catch (Exceptione) {
e.printStackTrace();
}
Contextctx = new InitialContext();
DataSourcedataSource = (DataSource)ctx.lookup( " java:comp/env/jdbc/mydatasource " );
Connectionconn = dataSource.getConnection();
} catch (Exceptione) {
e.printStackTrace();
}
这样就完成了...