ibatis向oracle数据库查询

zuolin0806 2008-04-30 11:20:08
当ibatis向Sql Server查询数据时,如果没有记录只会显示没有该对象或者为空。而ibatis向oracle查询数据时,如果没有记录会显示以下异常,请问是什么问题呀?

<2008-4-30 上午11时17分43秒 CST> <Error> <HTTP> <BEA-101017> <[weblogic.servlet.internal.WebAppServletContext@c98b07 - appName: '_appsdir_ThirdParty_dir', name: 'ThirdParty', context-path: '/ThirdParty'] Root cause of ServletException.
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17075];
--- The error occurred in cn/com/umessage/provider/domain/provider.xml.
--- The error occurred while applying a parameter map.
--- Check the provider.Provider.getProvider-InlineParameterMap.
--- Check the results (failed to retrieve results).
--- Cause: java.sql.SQLException: 对只转发结果集的无效操作: isLast; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in cn/com/umessage/provider/domain/provider.xml.
--- The error occurred while applying a parameter map.
--- Check the provider.Provider.getProvider-InlineParameterMap.
--- Check the results (failed to retrieve results).
--- Cause: java.sql.SQLException: 对只转发结果集的无效操作: isLast
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:96)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:184)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:222)
at cn.com.umessage.provider.dao.ProviderDao.getProvider(ProviderDao.java:14)
Truncated. see log file for complete stacktrace
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in cn/com/umessage/provider/domain/provider.xml.
--- The error occurred while applying a parameter map.
--- Check the provider.Provider.getProvider-InlineParameterMap.
--- Check the results (failed to retrieve results).
--- Cause: java.sql.SQLException: 对只转发结果集的无效操作: isLast
Caused by: java.sql.SQLException: 对只转发结果集的无效操作: isLast
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:565)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:540)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
Truncated. see log file for complete stacktrace
java.sql.SQLException: 对只转发结果集的无效操作: isLast
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:349)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.isLast(NewProxyResultSet.java:909)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:388)
Truncated. see log file for complete stacktrace
...全文
206 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复

67,515

社区成员

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧