Re: Slow performance updating CLOB data

Nicola Zanaga schrieb am 17.07.2016 um 11:39:
> Hi, using ResultSet.updateCharacterStream to update a CLOB is very slow.
>
> Most of the time is spent in method PgResultSet.isUpdateable  because the table has a primary key but doesn't have a
"oid"column. 
>
> So the code tries to get primary keys from the query, using getMetaData().getPrimaryKeys.
> This is a very slow process.
>
> There is any workaround ?

Are you using setCharacterStream()? Why aren't you using setString()?

Please show us the Java code.