[jira] [Commented] (TRAFODION-1649) Do not know which row has error while there is PrepareStatement.executeBatch() error

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15028196#comment-15028196 ] 

ASF GitHub Bot commented on TRAFODION-1649:
-------------------------------------------

GitHub user kevinxu021 opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/190

    [TRAFODION-1649]batch error should not stop the process

    Got your error rows and messages as follows:
    int[] rs = ps.executeBatch();
    for (int i = 0; i < rs.length; i++) {
    	if (rs[i] < 0 && rs[i] != -2)
    		log.info("Error/warning on row " + i);
    }
    SQLWarning warn = ps.getWarnings();
    while (warn != null) {
    	log.info("Error " + warn.getMessage());
    	warn = warn.getNextWarning();
    }

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/kevinxu021/incubator-trafodion a_jdbcreturn

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/190.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #190
    
----
commit 981bd75a0d3f5f25fd4716aca335f9aa1142ebf2
Author: Kevin Xu <ka...@esgyn.cn>
Date:   2015-11-26T05:15:16Z

    batch error should not stop the process

----


> Do not know which row has error while there is PrepareStatement.executeBatch() error
> ------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1649
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1649
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: client-jdbc-t4
>            Reporter: Kevin Xu
>
> int[] rs = ps.executeStatement();
> there is an exception while some error occurs, then it cant get returned array



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)