You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:08 UTC
[jira] [Created] (TRAFODION-480) LP Bug: 1349644 - Status array
returned by batch operations contains wrong return value for T2
Alice Chen created TRAFODION-480:
------------------------------------
Summary: LP Bug: 1349644 - Status array returned by batch operations contains wrong return value for T2
Key: TRAFODION-480
URL: https://issues.apache.org/jira/browse/TRAFODION-480
Project: Apache Trafodion
Issue Type: Bug
Components: client-jdbc-t2, client-jdbc-t4
Reporter: Aruna Sadashiva
Assignee: RuoYu Zuo
Fix For: 2.0-incubating
The status array returned from T2 contains a different value compared to T4. T4 returns -2 and T2 returns 1.
The oracle JDBC documentation states:
0 or greater — the command was processed successfully and the value is an update count indicating the number of rows in the database that were affected by the command’s execution Chapter 14 Batch Updates 121
Statement.SUCCESS_NO_INFO — the command was processed successfully, but the number of rows affected is unknown
Statement.SUCCESS_NO_INFO is defined as being -2, so your result says everything worked fine, but you won't get information on the number of updated columns.
For a prepared statement batch, it is not possible to know the number of rows affected in the database by each individual statement in the batch. Therefore, all array elements have a value of -2. According to the JDBC 2.0 specification, a value of -2 indicates that the operation was successful but the number of rows affected is unknown.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)