一 环境:XP+Myeclipse6.6+Tomcat7+JDK1.6 二 具体步骤如下: bean.xml中配置: Java代码 - <>'dataSource' class='org.springframework.jndi.JndiObjectFactoryBean'>
- <>'jndiName' value='java:comp/env/jdbc/oracle'>
-
以下每种方式都是成功的! 第一种方式: 1 %TOMCAT_HOME%\conf\server.xml中配置
Java代码 - <>'jdbc/oracle' auth='Container'
- type='javax.sql.DataSource'
- factory='org.apache.commons.dbcp.BasicDataSourceFactory'
- maxActive='100' maxIdle='30' maxWait='5000' username='ssh'
- password='ssh' driverClassName='oracle.jdbc.driver.OracleDriver'
- url='jdbc:oracle:thin:@127.0.0.1:1521:orcl' />
第二种方式: 全局jndi配置步骤 1 %TOMCAT_HOME%\conf\context.xml中配置
Java代码 - <>'jdbc/oracle' auth='Container'
- type='javax.sql.DataSource'
- factory='org.apache.commons.dbcp.BasicDataSourceFactory'
- maxActive='100' maxIdle='30' maxWait='5000' username='ssh'
- password='ssh' driverClassName='oracle.jdbc.driver.OracleDriver'
- url='jdbc:oracle:thin:@127.0.0.1:1521:orcl' />
推荐第三种方式: 应用的context XML文件(META-INF/context.xml),这个是私有的,只对这个应用可见
Java代码 -
- <>'jdbc/oracle' auth='Container'
- type='javax.sql.DataSource'
- factory='org.apache.commons.dbcp.BasicDataSourceFactory'
- maxActive='100' maxIdle='30' maxWait='5000' username='ssh'
- password='ssh' driverClassName='oracle.jdbc.driver.OracleDriver'
- url='jdbc:oracle:thin:@127.0.0.1:1521:orcl' />
-
说明我没有在web.xml进行相应的配置也没有把数据库驱动jar拷贝到%TOMCAT_HOME%/lib下,可能是Tomcat7的原因, 其它Tomcat没有测试了!
|