hibernate使用tomcat5.5.9连接池

1．  配置连接池：

 

a) 在C:/jakarta-tomcat- 5.5.9 /conf/Catalina/localhost下创建myweb.xml文件，文件名同web应用程序的名字

 

 

b) 填入上下文配置内容：

 

<Context path="/myweb" docBase="myweb"

debug="5" reloadable="true" crossContext="true">

 

<Resource name="jdbc/TestDB"

       auth="Container"

       type="javax.sql.DataSource"

       maxActive="100"

       maxIdle="30"

       maxWait="10000"

       username="root"

       password=""

       driverClassName="com.mysql.jdbc.Driver"

       url="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8&amp;autoReconnect=true"

/>

 

</Context>

 

 

c) 修改web.xml（可以省略）

 

填入

       <description>MySQL Test App</description>

       <resource-ref>

              <description>DB Connection</description>

              <res-ref-name>jdbc/TestDB</res-ref-name>

              <res-type>javax.sql.DataSource</res-type>

              <res-auth>Container</res-auth>

       </resource-ref>

 

 

d)写index.jsp测试

 

 

 

 

aaaaaaaaaaaaaaaaaa

<%@ page import="java.sql.*"%>

<%@ page import="javax.sql.*"%>

<%@ page import="javax.naming.*"%>

 

<%

       Context initContext = new InitialContext();

       Context envContext = (Context)initContext.lookup("java:/comp/env");

       DataSource ds = (DataSource)envContext.lookup("jdbc/TestDB");

       Connection conn = ds.getConnection();

       out.println(conn);

%>

 

2）在使用hibernate的时候，通过jndi使用web服务器的连接池

 

a)先配置好C:/jakarta-tomcat- 5.5.9 /conf/Catalina/localhost下的上下文文件

 

b)然后在hibernate.cfg.xml中配置如下：

 

<session-factory>

 

    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

    <property name="connection.datasource">java:/comp/env/jdbc/TestDB</property>

    <property name="show_sql">true</property>

 

</session-factory>

 

c)测试

              Session session = HibernateSessionFactory.currentSession();

              Transaction tx = session.beginTransaction();

              Query query = session.createQuery("from Teacher t");

              Iterator it = query.list().iterator();

              while(it.hasNext()){

                     Teacher t = (Teacher)it.next();                   

                     System.out.println(t.getTeaname());

              }

              tx.commit();

              HibernateSessionFactory.closeSession();