[
https://issues.apache.org/jira/browse/IGNITE-23239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Korotkov updated IGNITE-23239:
-------------------------------------
Description:
Currently the stream-related APIs for CLOBs are not supported in JDBC drivers
(both client and thin). Say the following ones:
* Clob.setCharacterStream
* Clob.setAsciiStream
* PreparedStatement.setClob(int parameterIndex, Reader reader)
* PreparedStatement.setCharacterStream
* PreparedStatement.setAsciiStream
*
PreparedStatement.setUnicodeStream
It makes the creation of CLOBs inefficient (memory wise) for large data.
The whole data should be preloaded to RAM before the LOB creation.
After that several copies of the input memory blocks are created just to pass
it to prepared statement etc. It should be optimized to reduce the heap memory
requirements.
> JDBC thin: support and optimize stream APIs for CLOBs
> -----------------------------------------------------
>
> Key: IGNITE-23239
> URL: https://issues.apache.org/jira/browse/IGNITE-23239
> Project: Ignite
> Issue Type: Task
> Reporter: Sergey Korotkov
> Priority: Major
>
> Currently the stream-related APIs for CLOBs are not supported in JDBC drivers
> (both client and thin). Say the following ones:
> * Clob.setCharacterStream
> * Clob.setAsciiStream
> * PreparedStatement.setClob(int parameterIndex, Reader reader)
> * PreparedStatement.setCharacterStream
> * PreparedStatement.setAsciiStream
> *
> PreparedStatement.setUnicodeStream
> It makes the creation of CLOBs inefficient (memory wise) for large data.
> The whole data should be preloaded to RAM before the LOB creation.
> After that several copies of the input memory blocks are created just to pass
> it to prepared statement etc. It should be optimized to reduce the heap
> memory requirements.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
