Re: ResultSet.getClob() causing problems when used with JPA's @Lob - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: ResultSet.getClob() causing problems when used with JPA's @Lob
Date
Msg-id nnds7r$ao2$1@ger.gmane.org
Whole thread Raw
In response to Re: ResultSet.getClob() causing problems when used with JPA's @Lob  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Responses Re: ResultSet.getClob() causing problems when used with JPA's @Lob
List pgsql-jdbc
Vladimir Sitnikov schrieb am 28.07.2016 um 22:47:
>> It would be nice if someone else could point me in the right direction, because I think
>> that only a change to PreparedStatement would make that complete.
>
> Am I right your problem is "find a way to identify database type at PreparedStatement#setClob time"?
>
> I'm afraid, there's no solution for that.
>
> I'm not quite sure we can easily figure out what is the proper data type for the bind.

That's really a pity, because the (very unusual) handling of "large objects" makes the Clob/Blob handling quite
incompatiable with other JDBC implementations.


> I do not like the idea "having additional round trip to the database just to resolve desired bind types".

Me neither, that would be horrible.

> I do not like the idea of having a switch that binds setClob to text or lob database types either.

Well, in certain environments it would certainly make it easier to switch to Postgres.


Thomas



pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: ResultSet.getClob() causing problems when used with JPA's @Lob
Next
From: Vladimir Sitnikov
Date:
Subject: Re: ResultSet.getClob() causing problems when used with JPA's @Lob