配置oracle10g(要下載ojdbc14包--是jdbc for oracle10g)
連接池(c3p0)的包的下載地址:
http://sourceforge.net/projects/c3p0
上下文路徑的xml文件內容如下:
<Context path="/test" reloadable="true" docBase="E:\project\test" workDir="E:\project\test\work" >
<Resource auth="Container" description="DB Connection" driverClass="oracle.jdbc.driver.OracleDriver"
?maxPoolSize="10" minPoolSize="1" acquireIncrement="1" name="jdbc/oracle10g" user="test" password="test"
?factory="org.apache.naming.factory.BeanFactory" type="com.mchange.v2.c3p0.ComboPooledDataSource"
?jdbcUrl="jdbc:oracle:thin:@192.168.1.86:1521:orcl" />
</Context>?
注意:tomcat5.0和tomcat5.5系列的差別:
參數都相同;只是xml的格式不一樣;
5.0是分開寫;5.5是寫在一個里.