struts2+hibernate+spring+tomcat6.0连接池的配置

首先：在tomcat目录下配置好数据库的链接池

添加conf/server.xml文件中配置

<GlobalNamingResources>

<Resource name="jdbc/Oracleguannan"
     type="javax.sql.DataSource"
     password="password"
     driverClassName="oracle.jdbc.driver.OracleDriver"
     maxIdle="2"
     maxWait="5000"
     username="username"
     url="jdbc:oracle:thin:@192.168.0.201:1521:known"
     maxActive="20" />

添加conf/context.xml

 

<ResourceLink name="jdbc/Oracleguannan" global="jdbc/Oracleguannan" />

 

然后在Spring配置文件applicationContext.xml中 配置数据源

 

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
  <property name="jndiName">
   <value>java:comp/env/jdbc/Oracleguannan</value>
  </property>
 </bean>
 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref bean="dataSource" />
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.Oracle9Dialect
    </prop>
    <!--
    <prop key="hibernate.show_sql">true</prop>
    <prop key="hibernate.format_sql">true</prop>
     -->
   </props>
  </property>
  <property name="mappingResources">
   <list>
    <value>这里是加载的HIBERNATE OR 文件</value>
   </list>
  </property>
 </bean>

 

配置就是如此的简单，希望给你们有帮助