Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tffVA-0048uU-87 for pgsql-jdbc@arkaria.postgresql.org; Wed, 05 Feb 2025 13:31:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tffV8-00Egwp-1C for pgsql-jdbc@arkaria.postgresql.org; Wed, 05 Feb 2025 13:31:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tffV7-00Egwg-Hk for pgsql-jdbc@lists.postgresql.org; Wed, 05 Feb 2025 13:31:33 +0000 Received: from pgintl.fastcrypt.com ([149.56.129.164]) by makus.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tffV5-003JrH-0g for pgsql-jdbc@postgresql.org; Wed, 05 Feb 2025 13:31:32 +0000 Received: from mail-ed1-f44.google.com (mail-ed1-f44.google.com [209.85.208.44]) by pgintl.fastcrypt.com (Postfix) with ESMTPSA id 6C37720043 for ; Wed, 5 Feb 2025 08:31:30 -0500 (EST) Received: by mail-ed1-f44.google.com with SMTP id 4fb4d7f45d1cf-5d90a5581fcso12455216a12.1 for ; Wed, 05 Feb 2025 05:31:30 -0800 (PST) X-Gm-Message-State: AOJu0Yz/R896+SCCKr8IfL46ocaCDSILGLMYx0ciaACexr0tCQMLEQA/ TjOEw9HP5184kqY713ooj6BdmH5Mp6aDnIhOCPYRSlH+V38hEHX4yExlHA6j/e2aGP0sq8cHjSY AG9zQK2iqXystRGUBvW/7QRjIdGQ= X-Google-Smtp-Source: AGHT+IFo/osJYSYiOge8zDHVz88lpp+/0OUAx9g9PXEyuRxFJbUhOcbAj9X6sVsOGb7o4UP9h7Gljaar5SoMizMQ34Q= X-Received: by 2002:a05:6402:348d:b0:5dc:c531:e5c0 with SMTP id 4fb4d7f45d1cf-5dcdb776474mr3197240a12.27.1738762289232; Wed, 05 Feb 2025 05:31:29 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Dave Cramer Date: Wed, 5 Feb 2025 08:31:11 -0500 X-Gmail-Original-Message-ID: X-Gm-Features: AWEUYZl2eTdjYjLe-C0Q3vopXovnWZe3i7HsSiWxml5pjdYxE9W8rWIY70wvEIY Message-ID: Subject: Re: Regarding setClob and getclobval methods in PostgreSQL To: Rajyalakshmi Sareddy Cc: "pgsql-jdbc@postgresql.org" Content-Type: multipart/related; boundary="0000000000009a590c062d6524bf" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009a590c062d6524bf Content-Type: multipart/alternative; boundary="0000000000009a590a062d6524be" --0000000000009a590a062d6524be Content-Type: text/plain; charset="UTF-8" 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/org/postgresql/jdbc/PgPreparedStatement.java#L1328 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 < rajyalakshmi.x.sareddy@gsk.com> 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: rajyalakshmi.x.sareddy@gsk.com > > 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.* > --0000000000009a590a062d6524be Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hello,<= /div>

You are correct that it is not implemented.=C2=A0<= /div>


However I'm not sure there is a= ny reason=C2=A0that it hasn't been implemented yet.=C2=A0
Feel free to provide a PR to implement it.

=
Dave Crame= r
www.postgres.rocks


On Mon, 3 Feb 2025 at 09:44, Rajyalakshmi Sareddy <rajyalakshmi.x.sareddy@gsk.com> wr= ote:

Hi Team,

=C2=A0

We are currently migrating the code from oracle to p= ostgresql 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 no= t yet implemented.

=C2=A0

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

=C2=A0

Thanks and Regards

Rajyalakshmi Sareddy<= /u>

Integration Developer=C2=A0

Middleware & Integration

GSK Tech

Hyderabad, India

=

=C2=A0

E: rajyala= kshmi.x.sareddy@gsk.com

M: +91 8309974485=

=C2=A0

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

--0000000000009a590a062d6524be-- --0000000000009a590c062d6524bf Content-Type: image/png; name="image001.png" Content-Disposition: inline; filename="image001.png" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: ii_194d64b1a1c4cff311 iVBORw0KGgoAAAANSUhEUgAAAIcAAAApCAYAAAAf8TqUAAAAAXNSR0IArs4c6QAAAARnQU1BAACx jwv8YQUAAAAJcEhZcwAACxIAAAsSAdLdfvwAABD3SURBVHhezVxbb1zVGd3nzIwdO0ltApVStRJB yrv9D+L3PpC2UmnVgp1CL1S0SbljCI4pgRDR4FTQSkUodkop6kvLL8D5B1jqW1QBEm2l0qIYQeK5 nd21vr2/c/Y5c8Zzs2GWsmbfL2d/6+zbjBNZa003NO+7Y95WKyfNZ9GCMbGxUWxMFBkLv4HfhUFJ iyQtS/dhg7D4GURbEhW64l8/+Pu/ryNm/3CBz2CW0NYxaZsoPnrVu5oufQxI0OUjE2Fc5l83P7U9 nyVZm2BfSAe4Ok7KyoN19nlPUP/jHbMwwDoemS5ifFv4kHbF6+Kti79RKo7mA0cWYPhzGIUTpo3M lUpa0LTxEBWOjq+oDX8Fflch0kFk9xHGJkyHXCpNCTM6aUyiaosqE4TRfpysTr36D7S3T7gQ0ViL LgC4rvXvZo/roP5imIjMqvmZ7fksyaXaOQzASloW7BDHz+v0jYz61dtnUeEm2pvzhsc/XzVcWEKi NB4W2Ya7oO9AisYjR9bskcq79rbKCdDY25B5FpxB578CHkbRwzAqeSAx0eGWiQ6C02TTRAfAqTrc HWE8UQdv4UlbjnHLVA58bioTNxGPPAhHEeL3Cy9AGAmEwXdA34Nh3H5IqNsLfOQmMvOd8YwYbsCv 3APU14/M4vk30a85g4mA76PrLz7EZS7vF9htfCxM3/PRezlxNFZuX7czldP2IBRUQ+5J1HQogrHb MCKEUIE7gQYwEzAs6VWwAkZIIycgjhguhCCGhwA4a0gaekaXeSkSiiKuIr1a9z3YY5zHUmL9jKEP P4yrxGOWhumSeCxx+0FaFh9B+SgMj4jGGxQGZowEwpA6YVdxfRtsX/qQ+rfAY9Pf++d7CKWrp6mf v33J1qJFicGUbzDzm6qfbibAg6hhGqziCSASuiIW78aTEMAE5O4FIKQAIBQRgggGeUj6RSReQPTv B6w56V2HQV2Cz6+ukgjzhuRA9wPOFpwd6MoskrnpDDICGr+bnTUNuxk1kjmpj2yBbbzYHO6UCLPf ThgLU9//1w2EBCKO+tpXZ810Zc0cwJNPk4iegotZwkxREHC5WaM7TXIWAWswLDmJJ6FoMIvEBxoI 4wk50wgpEhCzgxMMRYI8EInbh6D+/RKHMfNiMCJ0u5EIXVKNTVfDmqYk1K/5+4WUwQfLFdsYEo1X IQyLpcRgxoCaZZ+hombY+wQufgtcmPpBJgxCxGEr0ZKtmhk7iYIxcssmEaQ4sIRIT92pQijVM42C SeceQvNAjTWKBZQlB2Gp080YbnlhPEXmZo99ATWHZvecrLdITesXPm/UxHi0MBZtVEJXiPGiOwSa v52BMKzbY2BWMG2MMasSPwghcumS5QtpaGsLbS5M/fDfOWEQzrQT0VK6hPCkQaPTFUGA3GNwpvBL BmcFMTSXBBpXDMww8yPN55P8MlM4AdCvZdM9iue+At3KuUQxjm43cnBJdpMuUUxnmrIPiCgayCzl Mb5SFz5Cd0C0Lh2ah8Hfg7DmKC4cRXP1S5ii8IRAtsCFA6f+0yEMQo6yO68fRW73j+ueqEoqdnFy mHDha1Ixnil7GDZs5cgqjbMANz4+jWHXSZJapEsVujQHu1556dbe3HOci47hc97zDAQ/g1eA0+YN ET9RdEOUpdGvVIR+Iguvm0d633PYZ3hVYFZcCPDlbYwx8m3FK61iK13RevngPN6yTQztDFyUZwVI 4NFUVgPSh51/C/6FyR//t1QYRHTz6te+DoN/RPXLVEaXhhQReMO2ce61dmHi4U9kFzuWWJFLLg74 CR1ojw1zzi55/9igQxyE9NsbE4hX+xNH6+K0CANFRRhuj4FTJmyX3p3I3RTadfGyx6j9YrurMIjY xNGUFJblAy4oLziJ5cXKMmPXxloYz0ZrmITehe+EhDkhkdxojaEwchDjhcQ/GFX2dX2gfWFqPkoS HFeTGdlftLBc8aXmfkKWDsT5vYekt5MtxPcUBhGLyqhUr1aKxF1zuxF2neyvo18Kno3O4PO0+Ivd tFhKxh2cmXWMw/4Xn6UEyfMT3GPwVDKTmgxwgnCUFYBhEYp9B2kLtdOf9jUu2ChQqiRCvAZXkRD0 KscRZyMe2fJX1RygPgb2SwdFIcKg35MfEq/h7kieq/GYvolZZkY2xFofxRDULaKQ+GSj+vBnJ6u/ +qzvFwbLCj5FALpWoV4RCZNdeGzFYeSSa6Z0MIvhcUXYT30OMWz3B7DPViAMHlchDBWCikIyOCdN s2aj+ujNgZfXOOsDlxAPVsjZRAUyvuCJpDvSZxtLcDkA1ICeii59F2GwrOVLwTIwlVsyHGUp4f4C CRRMYjcqT9waat8Vc32SytgZ30FZu/w6xQYkz3giLw72O48T2JPsLqAvCdF5uaj60AczFEUSwJ6N T6KM22PQNvgnYggp9nI2w0Z0o7JcH3pDHt188+hxVHhdhSANUgzc8UqcNLJa++V2z6+hy5Cs1o6h TnTQ1+3VXjoAxbgsuBm9gMEs4hk5vrkTSnfwW0bmy05bOkWy/mGWTJbJym2alZK+9QG7HHFZ/Gu3 PkBAaQqEQSNfcSEPzu4eevxVYJOwEZ1rDy0MIrp59ehxiOG6E4YKgn4kqkjaMPHpT4cVB+8f3nVv BOoU1/lzkHAhMguuQhyd7Z/FEVZPKoOii0H6QudySwGyL2s4Og90QoJA3H1HSX9UHPaZEmEQYZm8 ODai1dGEQaDKzAL+9Aq6aUlEMioCMWRtlVmm0FYhWAqL2YD5erEMvdJ3A4amQJ4YVkwb/Tk72DLm RX8K/dgu9sk+HR0DlzB+V7JxDBjaR19q7DH2QhhELPf7qDSbMeBnm54iEnZkFEhxfKTVFOobvvq/ gXxrdwfrD1lEMT0kURRDmJ6PvxPupnl6YIHwup3X/qugex5X//tg54wRgraR2V3cjejXyZ4Ig4hN q23iestEjRYeUJYQuI46e4hwhoU1H3DG0Asap3r1k/IhwYHxPKZw3nNoFd1YxG7pamglv0gr5g/T i2k8WnMfshzNSqhPQCA3OIuALEeRZHD1drYFyjeuDu+g7J4Jg4hFDLxybSUQSVNEItevfiZJZ5Qh Ea+2PoBzTQId1XSpd5Dmzluu9Rsu0AWsr0hC/aGxQ4T5iyTK4sm2LDPsV/+gmJajMyBeJrPSsfCy 3i4QgSTmbvMElqA9hIjDCQAtcLagMCgQEQnimA7xjITEnsHDYbpEO/KQdEuellEl0T1xXt6Y/NvW C7u1008/aBDN54zjmM00i+Zx+Ya4N5blS0Oepl4B72QUAYHcBZ7ywQ54UWR9SbAEPSY/pt4TyJ5D hMDfFzTRinxxw9bQLYqGjQZHpmGAdRAbR8vfc36YLivcXcu1vadkDBigECzHeWzsrLkL3ADzm7tu JLrFh1AD0PBKzauGKfpJ/ilELyzL284vDVNRpHjBfgCu4/lPhUPDJTpdTrQtbZs/pn5kbwQSNS9O Hcfx8roYjQ2wdTZC46khrV2tLNeHOsoWIRc54c/3CCtvfjY4QRq7A6xikAZrf1k2hWR/b68iHPQQ neF8nxX5fNfMy3gpuuEpmTEojHK8mN1zmCdFRFdS+2g76ldxEM7dMK+MtgeJ2s9Vj8O9zoCt8vt5 1Ix/ch/B33e4hlbjc609EUcZcFzjJVL2dbtHNjJDiOOLwGO+39rnoO/ev20uyQazHE9F3I+VvhSC C4E4CO4pIggkbI9UYRQZQSCXhxdIdp0DMURN7jW4vGDe5BIDuJMGW/oC8AU1s2fgsVUNExoo8/Pk Uo6nZGbrFIbWoeEQL+HIa/2dCNtQhmXCslxiHhp+iYmjWxAEuQNRkLIHASkW3XNoY/uFQht8XfKv jOEbNn5gn9VARPgchWfqgDXcg3WWUXQrS4EYlC3e74RiIbkvcv5F85PhBNJ5Eayd5cyhHPKX0H1D 2/QUTeY51HcX+w70LYUag3Gh2x3dl5uw3jJctLwZdgLRvGxLN8vaF/93MAgvmvsHF0icq5CVKVmp cveHHBkFIRQHZyN6Ebv2cQTHRan9VsNoXBdo9lyWMCKXUIKXvUASCIRtElqeDNt3/VnEmWcggcQW QhCiAYtKxC2SYtlX8DbRLSZYzCAQEu1aswXyZ4DjDTVC6Cp7ILd8DlBO8BsvEN2D6ItMwm4ps7hF cx8Ecl9/t7eYOdA9suld/lmBdy1cEv4zycPxYEfCPtF+Ml6HAOa8GHRgPsSwrcYX7Dw4nr8DPS0D 7E4CGKLUoKGr/jL4dH3u9NnVkPT3g8teIE0/g+hszxea9dDVugleznGZvre3QLDvtKb9EP8ayUN3 IWGFPOESEc7tYbpC4zhIZekE0zoxi/g5uPqV9w0U26y+lAz2S/fH+c1ljwsn7U+xX4OE82m8q8mf RjrLXjOvlt9z2Mf8V/UBchdbxKXCUXY33I/TD43Ob4hZXsk6aRMNE07M8ucJ5k/dXz4njgdjGmMu LavXHVJhhDA8qFDS4cr/1wJIOqBhFQAfKZ8Hdfhv3nwRD18AoqtebHe/LOqBcKDTL/hClMWFKKaH 4d3SiN3zXoY4SpdF+2heHOkf/fkhkbpeGUAcxKmCQHQGCuukP+un/PG0+XO5QMSEWDrWZfnwtA2Q ywz7hk6ny4umI437Aknn8kPCLy6XJbotkPnZG3RG80gZMu0xkHV2OLC8Z+DNGDRbmq7EhzDwSzeV ROgnimFCKhDyJwXl8HkoCvcXhZ40qO4TBsUVLDFJsAchtE4VitZNtuW/Ztg095QvMe79bhuIw2zL 5hOFUupGlBUGlcrAYV1jfqINMaUN6kN6ah4JMuyZQDjtlPFI+wqpO2RHRECAbSciXkQFz1VGzZNu 2ov+MMz8Ga+Z13b5+SDyyDIS9o1h1JO6w+AqBNI2x1DHVmo3rVvbC/38g2v+xOC7nQIRcVTfaN9I mvG5djM2rQZYr5gmuVMx9ZtV00J8u4V4ptPPPI2K5GsgD9O8kU0ryNdkniby+Poa9arPG5sEM0mS 0JWyI/01HWclMXhK14aQ7ZHst6fMhFIG7Wv6bmQ575fxYR0Y2FQI3i+C8zMmBLPrKUtmC904hqQx 1T8s3pLfufCYy2UjFEKnn9QZ5Dt5gehuwUxeba7B4Bs0uBiOg4zB4AM3KBARBIl0DirSKQgd3Prn NUkXgYHO8L4ebyj6G40qBIX6dLDdwA99xUvUIbpGvZaS4ZRoTw2bzlShmOgvI9Yg9avg+WxajuMk L4gnXxhJx2BDKKfiP+AN3g36VofCCMm0UfC27CO4j9tKRUCWicRxDtw0384EkoqDOPT2zhKMfZkz RiYSP6h+cNrYb3AW0MFxeRxlFmEeDGaznolJ3jQ/0MznjOPqRdzlw6/tjHTJJfsduuKXqAwIt9DW DoSys1NzvFUzTcxoIbWfSn0Oum6/5OpmW/pykG4/hnjkYVsYv1OV15OeYueynDNYmTsq/uJnEPe/ 9rh6lURnnFtivuUEIqeVIj6++/CCNXKbdqcrF5mJagsbOrfzkhLwO9elE9zwMaI64WTvakY+l9yR D+kbRze2R/pamfjfjw7xtxzZsdA17FDmL4mr8T+aUSDOP51AuhvEZW7Ofw2ZzkxebfW1RNoHcFpB n/WnLL6avHtFR25EcDaIYHQaX+svQ5bGY+5SqTgUH33zNorkJHLMu8FzQxHH1teDMLpPozOsxq/V 2uLXfJqH8HkxU0Tr33jrkz35zuTjxcMUWCYy1zkH+GM932p8GAziNF/WU+fPBKBxCMPjw5tw1w+8 2Rxo9kvujZei2PJ+RurMzeGuObw6u/wWZFC45YIvfMfGM20vhDU3/g+8QhFJSj1QPwAAAABJRU5E rkJggg== --0000000000009a590c062d6524bf--