论坛首页 Java版 Hibernate

用了p6spy进行sql监控日志后,hibernate 不能插入oracle的blob字段

浏览 417 次
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
作者 正文
时间:2008-02-16 关键字: p6spy
用了p6spy进行sql监控日志后,hibernate 不能插入oracle的blob字段,
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
  <property name="location">
   <!--<value>/WEB-INF/classes/proxool.properties</value>-->
   <value>classpath:proxool.properties</value>
  </property>
</bean>
 <!--  <bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">
  <property name="driver">
   <value>${proxool.driver}</value>
  </property>
  <property name="driverUrl">
   <value>${proxool.url}</value>
  </property>
  <property name="user">
   <value>${proxool.username}</value>
  </property>
  <property name="password">
   <value>${proxool.password}</value>
  </property>
  <property name="alias">
   <value>${proxool.alias}</value>
  </property>
  <property name="houseKeepingSleepTime">
   <value>${proxool.houseKeepingSleepTime}</value>
  </property>
  <property name="prototypeCount">
   <value>${proxool.prototypeCount}</value>
  </property>
  <property name="maximumConnectionCount">
   <value>${proxool.maximumConnectionCount}</value>
  </property>
  <property name="minimumConnectionCount">
   <value>${proxool.minimumConnectionCount}</value>
  </property>
  <property name="trace">
   <value>${proxool.trace}</value>
  </property>
  <property name="verbose">
   <value>${proxool.verbose}</value>
  </property>
  <property name="houseKeepingTestSql">
   <value>${proxool.houseKeepingTestSql}</value>
  </property>  
 </bean> -->
 <bean id="dataSourceTarget" class="org.springframework.jdbc.datasource.DriverManagerDataSource">   
    <property  name="driverClassName">   
    <value>${proxool.driver}</value>   
    </property>   
    <property  name="url">   
    <value>${proxool.url}</value>   
    </property>   
    <property  name="username">   
    <value>${proxool.username}</value>   
    </property>   
    <property  name="password">   
    <value>${proxool.password}</value>   
    </property>   
</bean>   
<bean id="dataSource" class="com.p6spy.engine.spy.P6DataSource" >   
       <constructor-arg>   
           <ref local="dataSourceTarget"/>   
       </constructor-arg>   
</bean>  
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor" lazy-init="true"/>
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
  <property name="nativeJdbcExtractor">
  <ref local="nativeJdbcExtractor"/>
</property> 
</bean>  
   <bean id="sessionFactory"
    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
        <property name="dataSource">
          <ref local="dataSource" />
        </property>
        <property name="lobHandler" ref="lobHandler"/>
        
        <property name="hibernateProperties">   
            <props>  
                <prop key="hibernate.dialect">   
                      org.hibernate.dialect.Oracle10gDialect 
                    <!--org.hibernate.dialect.MySQLInnoDBDialect-->
                </prop>   
                <prop key="hibernate.show_sql">true</prop> 
                <prop key="hibernate.jdbc.batch_size">20</prop>  
            </props>   
        </property>         
        <property name="mappingLocations">
          <list>
              <value>classpath*:com/jhlt/model/*.hbm.xml</value> 
          </list>
        </property>   
    </bean>
 
   
论坛首页 Java版 Hibernate

跳转论坛:
JavaEye推荐