You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Clinton Begin (JIRA)" <ib...@incubator.apache.org> on 2005/12/20 16:06:33 UTC
[jira] Closed: (IBATIS-202) DB2 database; stored procedure, upon null result set, returns java.lang.NullPointerException
[ http://issues.apache.org/jira/browse/IBATIS-202?page=all ]
Clinton Begin closed IBATIS-202:
--------------------------------
Resolution: Duplicate
duplicate of ibatis-220
> DB2 database; stored procedure, upon null result set, returns java.lang.NullPointerException
> --------------------------------------------------------------------------------------------
>
> Key: IBATIS-202
> URL: http://issues.apache.org/jira/browse/IBATIS-202
> Project: iBatis for Java
> Type: Improvement
> Components: DAO
> Versions: 2.1.5
> Environment: DB2 database, db2jcc.jar driver, jdk1.4
> Reporter: Carl Gulovsen
> Priority: Minor
>
> Hello: First time post, please excuse any ethic violations.
> I am calling a stored procedure which should return a result set within a DB2 database. The issue I am having is the procedure checks IN parameters, checks to see if your userID can even run the SP, etc. Within my unit tests I trigger these checks and the SP sets the error return code, the SQLSTATE, SQLCODE, and an output message. Because of the errors, the Cursor for the result set is never created. The process throws a NullPointerException when attempting to process the result set.
> SqlExecutor.executeQueryProcedure() is called:
> public void executeQueryProcedure(RequestScope request, Connection conn, String sql, Object[] parameters,
> int skipResults, int maxResults, RowHandlerCallback callback)
> throws SQLException {
> ...
> cs.execute();
> rs = cs.getResultSet();
> /* here the rs is null */
> ...
> handleResults(request, rs, skipResults, maxResults, callback); --> steping into handleResults
> private void handleResults(RequestScope request, ResultSet rs, int skipResults, int maxResults, RowHandlerCallback callback) throws SQLException {
> try {
> request.setResultSet(rs);
> ResultMap resultMap = request.getResultMap();
> if (resultMap != null) {
> // Skip Results
> if (rs.getType() != ResultSet.TYPE_FORWARD_ONLY) {
> ....
> Here the rs throws the null pointer.
> Would it be possible for you to add:
> private void handleResults(RequestScope request, ResultSet rs, int skipResults, int maxResults, RowHandlerCallback callback) throws SQLException {
> try {
> request.setResultSet(rs);
> ResultMap resultMap = request.getResultMap();
> if (rs != null && resultMap != null) {
> // Skip Results
> if (rs.getType() != ResultSet.TYPE_FORWARD_ONLY) {
> .
> Here you would check to see if there is a null result set before process. I believe it to be relatively common that a stored procedure would not return a result set when errors occur.
> Thank you.
> Carl
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira