commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roberto Benedetti (JIRA)" <>
Subject [jira] [Commented] (CSV-234) Add support for java.sql.Clob
Date Sat, 08 Dec 2018 15:29:00 GMT


Roberto Benedetti commented on CSV-234:

The maximum size for varchar in some databases is 1 or 2 GB ([h2|],
[postgresql|], [sql server|]),
so we already have such a problem.

limits varchar to 4000 (tipically) or 32767, so we end up using clobs for larger text.

The PR throws an exception if the lenght is greater then Integer.MAX_VALUE, which is the maximum
for H2 varchar.

> Add support for java.sql.Clob
> -----------------------------
>                 Key: CSV-234
>                 URL:
>             Project: Commons CSV
>          Issue Type: Improvement
>          Components: Printer
>    Affects Versions: 1.6
>            Reporter: Roberto Benedetti
>            Priority: Trivial
> When invoking CVSPrinter#printRecords(ResultSet) if the object is a java.sql.Clob the
method toString() may not return its content (eg with Oracle drivers it return the basic Object#toString()).
> When dealing with java.sql.Clob a stream must be read.

This message was sent by Atlassian JIRA

View raw message