hibernate+jndi+dbcp

环境：tomcat6+ hibernate2.1.jar

问题：在使用tomcat6自带的dbcp的jar包(tomcat-dbcp.jar，其中已经包含了commons-collections.jar,

commons-dbcp.jar, commons-pool.jar)来配置dbcp数据库连接池出现了各种莫名其妙的问题

解决：使用hibernate2.1自带的 commons-collections.jar,commons-dbcp.jar, commons-pool.jar来替换tomcat-dbcp.jar就ok了

 

1.jndi与dbcp有什么关系？

jndi是不是也是数据库连接池呢？--不是

不使用dbcp只是用jndi会出现什么情况呢？hibernate中也可以连接数据库

dbcp与c3p0是hibernate推荐使用的

 

在tomcat的context.xml下，添加

--dbcp连接池配置，这种方式配置可以使用JDNI
<Resource name="jdbc/test"
	          auth="Container" 
	          type="javax.sql.DataSource"
		      maxActive="100" maxIdle="30" maxWait="10000" 
		      username="produsr" password="prod_777"
	          driverClassName="oracle.jdbc.driver.OracleDriver" 
	          url="jdbc:oracle:thin:@10.72.240.31:1522:ffv2prod" 
	          factory="org.apache.commons.dbcp.BasicDataSourceFactory" --必须
	          />

 

在hibernate.cfg.xml中配置

 

<!DOCTYPE hibernate-configuration PUBLIC 
	"-//Hibernate/Hibernate Configuration DTD//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
	<session-factory>
		<property name="connection.datasource">java:comp/env/jdbc/test</property>
                
                <mapping resource="com/hsp/config/Cat.hbm.xml" />

	    <!--  注释掉了 start
		<property name="connection.provider_class">net.sf.hibernate.connection.DBCPConnectionProvider</property>
		<property name="connection.url">jdbc:oracle:thin:@10.72.240.31:1522:ffv2prod</property>
		<property name="connection.provider_class">net.sf.hibernate.connection.DBCPConnectionProvider</property>
		<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
		<property name="connection.username">produsr</property>
		<property name="connection.password">prod_777</property>
	
		end-->
	</session-factory>
</hibernate-configuration>

 

 

编写hibernateUtil工具类

package com.hsp.util;

import java.io.File;
import java.net.URL;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class HibernateUtil {
	
	private static Log log = LogFactory.getLog(HibernateUtil.class);
	
	private static SessionFactory sessionFactory = null;
	
	static{
		//create the SessionFactory
		try {
		 /*1.配置读取"hibernate.cfg.xml"配置文件，默认读取时src目录下的
		  *2.hibernate.cfg.xml配置文件可以放置mapping，使用hibernate.properties配置                  *  文件不行。hibernate.cfg.xml不是必须的
		  */
			sessionFactory = new Configuration().configure("/hibernate.cfg.xml").buildSessionFactory();
		} catch (HibernateException e) {
			log.error("Initial SessionFactory creation failed", e);
			throw new ExceptionInInitializerError(e);
		}
	}
	public static final ThreadLocal session = new ThreadLocal();
	
	public static Session currentSession() throws HibernateException{
		Session s = (Session)session.get();
		if(s == null){
			s = sessionFactory.openSession();
			session.set(s);
		}
		
		return s;
	}
	
	public static void closeSession() throws HibernateException{
		Session s = (Session)session.get();
		session.set(null);
		if(s != null){
			s.close();
		}
	}
	

}