public inbox for [email protected]  

help / color / mirror / Atom feed

Regarding setClob and getclobval methods in PostgreSQL
2+ messages / 2 participants
[nested] [flat]

* Regarding setClob and getclobval methods in PostgreSQL
@ 2025-02-03 09:22  Rajyalakshmi Sareddy <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Rajyalakshmi Sareddy @ 2025-02-03 09:22 UTC (permalink / raw)
  To: pgsql-jdbc

Hi Team,

We are currently migrating the code from oracle to postgresql and using jdbc jar is postgresql-42.7.4.jar. But for code migration, we are getting errors like org.postgresql.jdbc.PgPreparedStatement.setClob(int, Reader) is not yet implemented.

Could you please confirm on setClob and getclobval methods are implemented in postgresql-42.7.4 jar.  If not implemented, could you please suggest with alternate methods.

Thanks and Regards
Rajyalakshmi Sareddy
Integration Developer
Middleware & Integration
GSK Tech
Hyderabad, India
[cid:[email protected]]

E: [email protected]<mailto:[email protected]>
M: +91 8309974485


GSK monitors email communications sent to and from GSK in order to protect GSK, our employees, customers, suppliers and business partners, from cyber threats and loss of GSK Information. GSK monitoring is conducted with appropriate confidentiality controls and in accordance with local laws and after appropriate consultation.


Attachments:

  [image/png] image001.png (4.3K, 3-image001.png)
  download | view image

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Regarding setClob and getclobval methods in PostgreSQL
@ 2025-02-05 13:31  Dave Cramer <[email protected]>
  parent: Rajyalakshmi Sareddy <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Dave Cramer @ 2025-02-05 13:31 UTC (permalink / raw)
  To: Rajyalakshmi Sareddy <[email protected]>; +Cc: pgsql-jdbc

Hello,

You are correct that it is not implemented.

What is implemented is setClob(int, Clob)
https://github.com/pgjdbc/pgjdbc/blob/15596302e6ab9ccdefe25c9bd91284d5f232ee27/pgjdbc/src/main/java/...

However I'm not sure there is any reason that it hasn't been implemented
yet.

Feel free to provide a PR to implement it.

Dave Cramer
www.postgres.rocks


On Mon, 3 Feb 2025 at 09:44, Rajyalakshmi Sareddy <
[email protected]> wrote:

> Hi Team,
>
>
>
> We are currently migrating the code from oracle to postgresql and using
> jdbc jar is *postgresql-42.7.4.jar.* But for code migration, we are
> getting errors like org.postgresql.jdbc.PgPreparedStatement.*setClob(int,
> Reader) is not yet implemented*.
>
>
>
> Could you please confirm on setClob and getclobval methods are implemented
> in postgresql-42.7.4 jar.  If not implemented, could you please suggest
> with alternate methods.
>
>
>
> Thanks and Regards
>
> Rajyalakshmi Sareddy
>
> Integration Developer
>
> Middleware & Integration
>
> GSK Tech
>
> Hyderabad, India
>
>
>
> E: [email protected]
>
> M: +91 8309974485
>
>
>
> *GSK monitors email communications sent to and from GSK in order to
> protect GSK, our employees, customers, suppliers and business partners,
> from cyber threats and loss of GSK Information. GSK monitoring is conducted
> with appropriate confidentiality controls and in accordance with local laws
> and after appropriate consultation.*
>


Attachments:

  [image/png] image001.png (4.3K, 3-image001.png)
  download | view image

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2025-02-05 13:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-03 09:22 Regarding setClob and getclobval methods in PostgreSQL Rajyalakshmi Sareddy <[email protected]>
2025-02-05 13:31 ` Dave Cramer <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox