[
https://issues.apache.org/jira/browse/TRAFODION-2704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16162395#comment-16162395
]
ASF GitHub Bot commented on TRAFODION-2704:
-------------------------------------------
Github user xwq commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1225#discussion_r138239370
--- 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 --
For now, the lob extract all data in one query, so after this query, we can
call the "zeroLength' query directly.
In the further, I will support the extract the data in multiple times for
large data, and then, we need JDBC change.
> 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)
