日期:2014-05-17  浏览次数:20724 次

ibatis+spring+struts 有时候抛出这个异常,有时没有,那个页面每次点击都很慢,
SqlMapClient operation; SQL []; 
--- The error occurred in com/ck/mcbnrt/model/OrFdrConfirm.xml. 
--- The error occurred while applying a result map. 
--- Check the OrFdrConfirm.orFdrConfirm. 
--- The error happened while setting a property on the result object. 
--- Cause: java.sql.SQLException: Io 异常: Socket closed; 
nested exception is com.ibatis.common.jdbc.exception.NestedSQLException
--- The error occurred in com/ck/mcbnrt/model/OrFdrConfirm.xml. 
--- The error occurred while applying a result map. 
--- Check the OrFdrConfirm.orFdrConfirm. 
--- The error happened while setting a property on the result object. 
--- Cause: java.sql.SQLException: Io 异常: Socket closed


*********************配置xml*************************
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" 
"http://ibatis.apache.org/dtd/sql-map-2.dtd" >


<sqlMap namespace="OrFdrConfirm">
<resultMap id="orFdrConfirm"
class="com.ck.mcbnrt.model.OrFdrConfirm">
<result column="partner_carrier_cd" property="partnerCarrierCd"
jdbcType="VARCHAR" />
<result column="serv_carrier_cd" property="servCarrierCd"
jdbcType="VARCHAR" />
<result column="file_nm" property="fileNm" jdbcType="VARCHAR" />
<result column="record_count" property="recordCount"
jdbcType="NUMBER"/>
<result column="nr_count" property="nrCount" jdbcType="NUMBER"/>
<result column="diff" property="diff" jdbcType="NUMBER"/>
<result column="gen_tm" property="genTm" jdbcType="DATE"/>
</resultMap>


  <select id="queryOrFdrConfirm" parameterClass="java.util.Map"
  resultMap="orFdrConfirm">
  select * from (select rownum rownum_,row_.* from (select partner_carrier_cd,
  serv_carrier_cd,
  file_nm,
  record_count,
  nr_count,
  nr_count - record_count as diff,
  gen_tm
  from (select partner_carrier_cd,
  serv_carrier_cd,
  file_nm,
  record_count,
  gen_tm,
  (select count(rowid)
  from nrtdba.ic_nr_file t2
  where t2.fdr_file_nm = t.file_nm
  and t2.partner_carrier_cd = t.partner_carrier_cd ) as nr_count
  from (
   
  select t1. partner_carrier_cd,
  t1.serv_carrier_cd,
  t1.file_nm,
  t1.record_count,
  t1.gen_tm
  from nrtdba.og_fdr_file t1
  where t1.gen_tm between TO_DATE('2012-05-10','yyyy-MM-dd') and TO_DATE('2012-05-10','yyyy-MM-dd')
   
  ) t)
 order