[
https://issues.apache.org/jira/browse/TRAFODION-1473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278323#comment-15278323
]
Sandhya Sundaresan commented on TRAFODION-1473:
-----------------------------------------------
Support is needed in JDBC for passing buffer addresses from client to the
server and vice versa :
From: Anoop Sharma [mailto:anoop.sha...@esgyn.com]
Sent: Friday, April 29, 2016 12:23 PM
To: Sandhya Sundaresan <sandhya.sundare...@esgyn.com>; Rao Kakarlamudi
<rao.kakarlam...@esgyn.com>; Arvind Narain <arvind.nar...@esgyn.com>
Subject: RE: Meeting to discuss bufferToLob and LobtoBuffer interface and
ODBC/JDBC
Had a chat with Arvind and Rao.
Same syntax will be used at both client and server level.
Arvind will add code to pass bufaddr to sql through the extract
syntax, and then move data from mxosrvr to their client on return.
He will try out and we will see if there are issues or something
else need to be enhanced or fixed.
For insert, the opposite will be done.
Rao/Arvind, anything else to add?
anoop
At mxosrvr level when they make the cli call to read/write lob
buffer using the current syntax, they will pass in 64bit address value.
That addr will point to the buffer location in mxosrvr.
The interface at the CLI laer and below will remain as is.
> Adding external buffer and file input and extract support for LOB datatypes
> -----------------------------------------------------------------------------
>
> Key: TRAFODION-1473
> URL: https://issues.apache.org/jira/browse/TRAFODION-1473
> Project: Apache Trafodion
> Issue Type: Task
> Components: client-jdbc-t4, connectivity-mxosrvr, sql-cmp, sql-exe
> Environment: Trafodion
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Labels: features
> Fix For: 1.2-incubating
>
> Attachments: Trafodion LOB interface.docx
>
>
> LOB datatype is disabled in Trafodion until the following support is fully
> in.
> Here are the list of tasks and items to support :
> 1. Support input of linux files (on platform) into LOB columns.
> 2. Support extract of LOB data into linux files on platform.
> 3. Support input of hdfs files into LOB columns.
> 4. Support extract of LOB data into hdfs files.
> 5. Support chunking to input a very large external file into LOB columns.
> 6. Use CQD concept to limit LOB max size and limit chunk size for extract
> /input.
> TBD
> 7. Support for input/extract of external files off platform into LOB columns.
> 8. Support in connectivity and driver for real LOB data type.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
