请问一个hirbernate问题

Question

请问在hirbernate中,怎样得到数据源的连接来调用存储过程?
我现在的程序是这样的:
//得到hirbernate连接
public Connection getConnection()
{
Connection conn = HibernateSessionFactory.getSession().connection();
return conn;
}
//调用存储过程:
Connection con = conn.getConnection(); //22
CallableStatement call = null;
Transaction ta = null;
try{
String sql = "{call rj_pkg.user_validate(?,?,?,?,?,?,?,?,?,?) }"; 
ta = HibernateSessionFactory.getSession().beginTransaction();
call = con.prepareCall(sql);
call.setString(1, orgid);
call.setString(2, userid);
call.setString(3, pwd);
                        ...我想能像这样调:
public class BaseDaoImpl extends HibernateDaoSupport implements IBaseDao{
       public void save(Object o)
{
super.getHibernateTemplate().save(o);
}
就是在我的方法中不要出现得到边接像22行这样的代码:
请问怎样做?
我现在的程序这样做是可以运行的,但我想改良,请各位高手帮忙!

Answer 1

HibernateTemplate里有回调方法，在回调里取得connection
super.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
//此处操作session,获取connection;
}
});

Answer 2

super.getHibernateTemplate().execute(new HibernateCallback() { 
public Object doInHibernate(Session session) throws HibernateException { 
//此处操作session,获取connection; 
} 
});

Answer 3

谢谢你,我现在的这个Connection 就是通过HibernateSessionFactory.getSession().connection();得到的,这样得到的是hirbernate连接,不是连接池的连接,我在spring中配了数据源,我想怎么在hirbernate中得到数据源,或者你的这段代码super.getHibernateTemplate().execute(new HibernateCallback() { 
public Object doInHibernate(Session session) throws HibernateException { 
//此处操作session,获取connection; 
} 
});
里面可以直接操作存储过程,可不可以再说一下,成功马上给分

Answer 4

贴下你的spring 数据源配置文件
要改那里。 在spring里定义数据源 指定映射文件 设置hiber控制属性 完成组装集成
抛弃hiber.cfg

Answer 5

super.getHibernateTemplate().execute(new HibernateCallback() {  
public Object doInHibernate(Session session) throws HibernateException {  
 Connection con=session.connection();}  
CallableStatement call = null; 
Transaction ta = null; 
try{ 
String sql = "{call rj_pkg.user_validate(?,?,?,?,?,?,?,?,?,?) }";  
ta = HibernateSessionFactory.getSession().beginTransaction(); 
call = con.prepareCall(sql); 
call.setString(1, orgid); 
call.setString(2, userid); 
call.setString(3, pwd); }); 

Answer 6

思路是利用spring 通过指定一个目录来加载改目录下的所有映射文件。
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"
value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean> <bean id="lobHandler"
class="org.springframework.jdbc.support.lob.DefaultLobHandler"
lazy-init="true" /> <bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="lobHandler" ref="lobHandler" />
<property name="mappingDirectoryLocations">
<list>
<value>classpath:/com/baobaotao/domain/hbm</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.generate_statistics">true</prop>
</props>
</property>
<property name="eventListeners">
<map>
<entry key="merge">
<bean
class="org.springframework.orm.hibernate3.support.IdTransferringMergeEventListener" />
</entry>
</map>
</property>
</bean>这样mappingDirectoryLocations之后 改目录下的hibernate.cfg.xml被 数据源统一管理了

Answer 7

谢谢大家,这是我的spring配置文件
<?xml version="1.0" encoding="UTF-8"?>
<beans default-autowire="byName"
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">
<!-- 使用dbcp连接池 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>      
        <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:Ora9"/> 
        <property name="username" value="rj"/>           
        <property name="password" value="rj0520"/> 
    </bean>    
    <bean id="exampleHibernateProperties"
       class="org.springframework.beans.factory.config.PropertiesFactoryBean">
       <property name="properties">
           <props>
              <prop key="hibernate.hbm2ddl.auto">update</prop>
              <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
              <prop key="hibernate.query.substitutions">true 'T', false 'F'</prop>
              <prop key="hibernate.show_sql">true</prop>
              <prop key="hibernate.dbcp.maxActive">10</prop>
              <prop key="hibernate.dbcp.whenExhaustedAction">2</prop>
              <prop key="hibernate.dbcp.maxWait">20000</prop>
              <prop key="hibernate.dbcp.maxIdle">10</prop>
              <prop key="hibernate.dbcp.ps.maxActive">10</prop>
              <prop key="hibernate.dbcp.ps.whenExhaustedAction">2</prop>
              <prop key="hibernate.dbcp.ps.maxWait">20000</prop>
              <prop key="hibernate.dbcp.ps.maxIdle">10</prop>
              <prop key="hibernate.dbcp.validationQuery">select 1 </prop>
              <prop key="hibernate.dbcp.testOnBorrow">true</prop>
              <prop key="hibernate.dbcp.testOnReturn">true</prop>
           </props>
       </property>
    </bean> 
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<!-- 引用dbcp连接池 -->
<property name="dataSource">
            <ref local="dataSource"/>
        </property>        
        <property name="hibernateProperties">
             <ref bean="exampleHibernateProperties" />
        </property>
         <!-- 引用hibernate.cfg.xml里面的resource mapping的配置-->  
<property name="configLocation"
value="classpath:hibernate.cfg.xml">
</property>
</bean>
<!-- transaction -->
<bean id="txManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="get*" propagation="SUPPORTS"
read-only="true" />
<tx:method name="find*" propagation="SUPPORTS"
read-only="true" />
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="bizMethods"
expression="execution(* com.rj.service.*.*(..))" />
<aop:advisor advice-ref="txAdvice" pointcut-ref="bizMethods" />
</aop:config>
    
<!-- transactionEnd -->

<bean id="unitDAO" class="com.rj.dao.XaUnitDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="logLogonDAO" class="com.rj.dao.XaLogLogonDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="orgDAO" class="com.rj.dao.XaOrgDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="deptDAO" class="com.rj.dao.XaDeptDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="userDAO" class="com.rj.dao.XaUserDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="appDAO" class="com.rj.dao.XaAppDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="groupRightDAO" class="com.rj.dao.XaGroupRightDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="groupDAO" class="com.rj.dao.XaGroupDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<!-- 配置dao -->
<bean id="daoimp" class="com.rj.util.BaseDaoImpl"></bean>
<bean id="bo" class="com.rj.service.UserBO">
</bean>
<bean name="/login" class="com.rj.struts.action.UserAction">
</bean>
</beans>请问我的配置对吗?