[ https://issues.apache.org/jira/browse/TRAFODION-2704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16168221#comment-16168221 ]
ASF GitHub Bot commented on TRAFODION-2704: ------------------------------------------- Github user sandhyasun commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/1225#discussion_r139204340 --- Diff: core/conn/odbc/src/odbc/nsksrvrcore/srvrothers.cpp --- @@ -6489,6 +6506,31 @@ odbc_SQLSrvr_ExtractLob_sme_( exception_->u.SQLError.errorList._buffer = QryLobExtractSrvrStmt->sqlError.errorList._buffer; exception_->u.ParamError.ParamDesc = SQLSVC_EXCEPTION_EXECUTE_FAILED; } + + IDL_long_long zeroValue = 0; + snprintf(LobExtractQuery, sizeof(LobExtractQuery), "EXTRACT LOBTOBUFFER(LOB'%s', LOCATION %Ld, SIZE %Ld)", lobHandle, (Int64)lobDataValue, &zeroValue); + + retcode = QryLobExtractSrvrStmt->ExecDirect(NULL, LobExtractQuery, EXTERNAL_STMT, TYPE_CALL, SQL_ASYNC_ENABLE_OFF, 0); + --- End diff -- Ok if this will be reworked as part of TRAFODION-2740, we can keep this as temp code to close the statement - although prematurely. Just make sure there is a comment in the code saying this will be removed when TRAFODION-2740 is addressed. > JDBC regression test failed by too many statement on the same session > --------------------------------------------------------------------- > > Key: TRAFODION-2704 > URL: https://issues.apache.org/jira/browse/TRAFODION-2704 > Project: Apache Trafodion > Issue Type: Bug > Reporter: Weiqing Xu > Assignee: Weiqing Xu > -- This message was sent by Atlassian JIRA (v6.4.14#64029)