[jira] Created: (IBATIS-584) Oracle Merge Into statement always returns 0

[Dongyong Kim (JIRA)]

Oracle Merge Into statement always returns 0
--------------------------------------------

                 Key: IBATIS-584
                 URL: https://issues.apache.org/jira/browse/IBATIS-584
             Project: iBatis for Java
          Issue Type: Bug
          Components: DAO
    Affects Versions: 2.3.0
         Environment: window xp, jdk 6, eclipse 3.2
            Reporter: Dongyong Kim


at executeUpdate(StatementScope statementScope, Connection conn, String sql, 
Object[] parameters)  in SqlExcutor

--------------------------------------------------------------------------------


public int executeUpdate(StatementScope statementScope, Connection conn, String 
sql, Object[] parameters) throws SQLException {
    ErrorContext errorContext = statementScope.getErrorContext();
    errorContext.setActivity("executing update");
    errorContext.setObjectId(sql);
    PreparedStatement ps = null;
    setupResultObjectFactory(statementScope);
    int rows = 0;
    try {
      errorContext.setMoreInfo("Check the SQL Statement (preparation failed).");
      ps = prepareStatement(statementScope.getSession(), conn, sql);
      setStatementTimeout(statementScope.getStatement(), ps);
      errorContext.setMoreInfo("Check the parameters (set parameters failed).");
      statementScope.getParameterMap().setParameters(statementScope, ps, 
parameters);
      errorContext.setMoreInfo("Check the statement (update failed).");
      ps.execute();
      rows = ps.getUpdateCount();  
     // can't get count if I use Oracle merge Into statement
     //  int result = ps.executeUpdate();  << this is ok
    } finally {
      closeStatement(statementScope.getSession(), ps);
    }
    return rows;
  }

--------------------------------------------------------------------------------


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.