我写的一个文档:1、conf/server.xml的<GlobalNamingResources>中增加:
<Resource
name="jdbc/myoracle"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
maxIdle="2"
maxWait="5000"
validationQuery="select sysdate from dual"
username="test"
password="test123"
url="jdbc:oracle:thin:@192.168.1.11:1521:ora92ser"
maxActive="4"/>
2、conf/context.xml的<Context>中增加
<ResourceLink name="jdbc/myoracle" global="jdbc/myoracle" type="javax.sql.DataSource"/>
3、web.xml中增加
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4、把ojdbc14.zip改名为ojdbc14.jar,拷贝到common/lib
5、使用代码:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
<Resource
name="jdbc/myoracle"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
maxIdle="2"
maxWait="5000"
validationQuery="select sysdate from dual"
username="test"
password="test123"
url="jdbc:oracle:thin:@192.168.1.11:1521:ora92ser"
maxActive="4"/>
2、conf/context.xml的<Context>中增加
<ResourceLink name="jdbc/myoracle" global="jdbc/myoracle" type="javax.sql.DataSource"/>
3、web.xml中增加
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4、把ojdbc14.zip改名为ojdbc14.jar,拷贝到common/lib
5、使用代码:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
我的tomcat是5.0的,没有你说的:conf/context.xml这个文件 ..这个是什么意思:Context)initContext.lookup("java:/comp/env");?现在报错:org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '
' for connect URL 'null'.没有读到数据源信息?
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
ory (Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)
(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou