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:30 UTC

[jira] [Created] (TRAFODION-599) LP Bug: 1365822 - select (insert) with prepared stmt fails with rowset

Alice Chen created TRAFODION-599:
------------------------------------

             Summary: LP Bug: 1365822 - select (insert) with prepared stmt fails with rowset
                 Key: TRAFODION-599
                 URL: https://issues.apache.org/jira/browse/TRAFODION-599
             Project: Apache Trafodion
          Issue Type: Bug
          Components: connectivity-dcs
            Reporter: Aruna Sadashiva
            Assignee: Rao Kakarlamudi
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


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)