[jira] [Updated] (TRAFODION-598) LP Bug: 1365821 - select (insert) with prepared stmt fails with rowset

["Anuradha Hegde (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anuradha Hegde updated TRAFODION-598:
-------------------------------------
    Fix Version/s:     (was: 2.0-incubating)
                   2.1-incubating

> LP Bug: 1365821 - select (insert) with prepared stmt fails with rowset
> ----------------------------------------------------------------------
>
>                 Key: TRAFODION-598
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-598
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: connectivity-dcs
>            Reporter: Aruna Sadashiva
>            Assignee: RuoYu Zuo
>            Priority: Critical
>             Fix For: 2.1-incubating
>
>
> This came out of : https://answers.launchpad.net/trafodion/+question/253796
> "select syskey from (insert into parts values(?,?,?)) x" does not work as expected with a odbc rowset. A rowset with single row works, but with multiple rows in the rowset, no rows get inserted. 
> The workaround is to execute the select after the insert rowset operation. 
> It also fails with jdbc batch, t4 driver throws a "select not supported in batch" exception.



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