[
https://issues.apache.org/jira/browse/TRAFODION-480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan updated TRAFODION-480:
------------------------------------------------
Fix Version/s: (was: 2.3)
2.4
> 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
> Priority: Major
> Fix For: 2.4
>
>
> 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
(v8.3.4#803005)
