author:向宇胜 time:2012-03-16 15:00:40
该例子运行环境:tomcat6.0,oracle数据库
1、把数据库驱动jar包放在tomcat/lib下
2、打开tomcat6/conf/context.xml 在 context节点下添加如下代码:
<Resource name="jdbc/tijian" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.1.173:1521:orcl"
username="tijian" password="tijian" maxActive="20" maxIdle="10"
maxWait="1000"/>
3、打开项目的web.xml 添加如下配置:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/tijian</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4、直接在JAVA中使用:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/tijian");
Connection conn = ds.getConnection();
5、在Spring中使用:
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/tijian</value>
</property>
</bean>
该例子运行环境:tomcat6.0,oracle数据库
1、把数据库驱动jar包放在tomcat/lib下
2、打开tomcat6/conf/context.xml 在 context节点下添加如下代码:
<Resource name="jdbc/tijian" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.1.173:1521:orcl"
username="tijian" password="tijian" maxActive="20" maxIdle="10"
maxWait="1000"/>
3、打开项目的web.xml 添加如下配置:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/tijian</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4、直接在JAVA中使用:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/tijian");
Connection conn = ds.getConnection();
5、在Spring中使用:
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/tijian</value>
</property>
</bean>