返回结果值过多问题

[默清寒]

错误信息

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
at cn.hit.dxs100.com.dao.HitCommonDao.query(HitCommonDao.java:32)
at cn.hit.hcms.base.dao.HjtCmsTzInfoDaoImpl.query(HjtCmsTzInfoDaoImpl.java:36)
at cn.hit.heip.heip01.heip01020100.bo.Heip01020100BoImpl.init(Heip01020100BoImpl.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy8.init(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke
... 144 more

    <select id="queryFileList" parameterClass="Heip01020100Vo" resultClass="HitListDataVo">
        select  B1.strAttachmentId,
                B1.strAttachmentType,
                B1.strAttachmentText,
                B1.strAttachmentUrl,
                B1.strCreateId,
                B1.datCreateTime,
                B1.strModifyId,
                B1.datModifyTime,
                B1.strDelFlg
        from hat_sys_attachmentdocument_relation A1
        left join hat_sys_attachment_info B1 on A1.strAttachmentId = B1.strAttachmentId
        where 1=1 
        <isNotNull property="strTzId">
            and A1.strDocumentId = #strTzId:char#
        </isNotNull>
    </select>

[默清寒]

求高手帮忙看看啊，在线等，速度结贴的=。=

[iymmgd]

帮顶。。。

[hao1hao2hao3]

[Quote=引用 1 楼 hit_tanxin 的回复:]
求高手帮忙看看啊，在线等，速度结贴的=。=
[/Quote]

executeQueryForObject
方法应该是处理一条记录的吧？增加查询语句的过滤条件以保证只返回一条记录。

[--小F--]

ASP.NET的?

[dawugui]

建议你提供详细的资料：
例如表的结构，表之间的关系，测试数据，相关算法及需要的结果。
这样有助于我们理解你的意思，更主要的是能尽快让你获得答案或解决问题的方法。

[ijwsoft]

第一次看见这种sql的写法。孤陋寡闻了偶。