AnsweredAssumed Answered

SCOPE_IDENTITY within JDBC Connection?

Question asked by jjurisch on Feb 24, 2017
Latest reply on Feb 24, 2017 by jjurisch

I am trying to insert data into a JDBC connection, which works as expected... however I'd like to ensure it returns the ID of the autogenerated primary key. 

 

When I run the following query in SQL Server directly, it works as expected - however I have been unable to emulate this behavior within the API gateway. 

 

Has anybody accomplished returning the data resulting from the insert, or is there another way I should be attempting this? 

 

Example Query

INSERT INTO [***].[testDatabase]
([firstName]
,[lastName])
SELECT SCOPE_IDENTITY() AS newID;

 

Assertion Details

 

XML Results: (this also seems strange as I specify to Fail assertion if no results return. 

<?xml version="1.0" encoding="UTF-8"?>
<L7j:jdbcQueryResult xmlns:L7j="http://ns.l7tech.com/2012/08/jdbc-query-result"></L7j:jdbcQueryResult>

Outcomes