From: Rajyalakshmi Sareddy <rajyalakshmi.x.sareddy@gsk.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>,
        "pgsql-novice@postgresql.org"
	<pgsql-novice@postgresql.org>
Subject: RE: Regarding setClob and getclobval methods in PostgreSQL
Thread-Topic: Regarding setClob and getclobval methods in PostgreSQL
Thread-Index: Adtz06iF4gJqZeIYQkmxgPB3+5kcBAAZi4UAAHgcW/A=
Date: Mon, 3 Feb 2025 09:11:15 +0000
Message-ID: 
 <AM6P137MB0130E6C698B0A36DBC861D2BD6F52@AM6P137MB0130.EURP137.PROD.OUTLOOK.COM>
References: 
 <AM6P137MB01308BAB4D2504725635DBBBD6E82@AM6P137MB0130.EURP137.PROD.OUTLOOK.COM>
 <f260c14e9e70e43cc956e99dc11ca6ce16d73c57.camel@cybertec.at>
In-Reply-To: <f260c14e9e70e43cc956e99dc11ca6ce16d73c57.camel@cybertec.at>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
 MSIP_Label_bea66b2b-af80-48b6-873b-d341d3035cfa_ActionId=f679e88a-e37f-4092-af10-507ed0689add;MSIP_Label_bea66b2b-af80-48b6-873b-d341d3035cfa_ContentBits=0;MSIP_Label_bea66b2b-af80-48b6-873b-d341d3035cfa_Enabled=true;MSIP_Label_bea66b2b-af80-48b6-873b-d341d3035cfa_Method=Standard;MSIP_Label_bea66b2b-af80-48b6-873b-d341d3035cfa_Name=Proprietary;MSIP_Label_bea66b2b-af80-48b6-873b-d341d3035cfa_SetDate=2025-02-03T09:01:58Z;MSIP_Label_bea66b2b-af80-48b6-873b-d341d3035cfa_SiteId=63982aff-fb6c-4c22-973b-70e4acfb63e6;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: AM6P137MB0130:EE_|DBBP137MB0208:EE_
x-ms-office365-filtering-correlation-id: a4dba94d-84f7-40a9-ba51-08dd4432b64b
x-ms-reactions: disallow
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|38070700018;
x-microsoft-antispam-message-info: 
 =?utf-8?B?OTlnSmxnL3dYWnRKVUsxRW9Rb0dDZWxnOStudjhXRXJpZ3Rpai93bDZqbDU1?=
 =?utf-8?B?R1VDbHlMNFNMdG91a3MxZEZEcmtwMldOa1pzcHB0TXZrbFZ0U3FtK0M3SEFD?=
 =?utf-8?B?d2NDZnRiSmlzSWZFQkU3MDA3RUlvV3dycXZVNjNKa01OMmh6ZmxMazhXOHQ3?=
 =?utf-8?B?clhtcFdmcHJrVDY4QlByTEhqZHZqeWNNVmN1Z2kzN2piaVBnOXRuWnBMbUpx?=
 =?utf-8?B?UElIbW84WmE2aDhQc0tRTnkvcnJUUVpiOERJenAwUW9EWU1EVHZEeXdGRjJB?=
 =?utf-8?B?KzJZbmVBVnozYmRrb01rQ3JWQmNXOG9MNlpKU0xzUzVyNFg3UmoxVzFhTmJp?=
 =?utf-8?B?NFJrSlE2MTZuNlUrZ1gzT2FjNDZDUzJpeDhKK0dYRjJtQUUrampCZC9QWi8y?=
 =?utf-8?B?N2tXeUR5bUVKNVFsZDlaWm16QUR2V2w3NFhoNmEzazBuVVQ0MVIyN2FGR3BZ?=
 =?utf-8?B?R25DSlVKYzNvM25KZnJwRUJvT0l1b1Fkbmx1eStlUWVaTm4xc3JueTY4cUh6?=
 =?utf-8?B?cmQ0U0ZOVERkOE1lSzZmM2RQR2FHNGRqaHJaeWltWkl3cFpNTEpFcjlHRFVk?=
 =?utf-8?B?VFE0bFRsMzg0ODNKSko2eGlUcTQwN2p0aTFlSVJtSjM5ankvWnVCVkFRL2dh?=
 =?utf-8?B?VTJ2VzdnN1FKM1drQ1B5dSt6UHN0OVh0TlBjTEpkakFzR3hBclN6eURNZm90?=
 =?utf-8?B?SGFtd2RMZXVBWXVUbTdTKzNNc1AwVVlhNCtITGY4Qi9mR3NpTElXcHlYNGRO?=
 =?utf-8?B?K1FURE5BNlBNVE5MWXZ0cTFkWDRMdnhDamhwZmV2U2pndDNxMlZ1ekdvQkJv?=
 =?utf-8?B?Umpsa0JGc2tiWG8xbllLN3YwSnFKczZtdWtLT29vVGZSYUJaYTk1U3lNRHlG?=
 =?utf-8?B?bUFRUkpYSWZiUHlUenN2dTY2VTNGYkRZZ0FRQXMwalpuODVsMUZGNVU3NFBI?=
 =?utf-8?B?MFB4aWQ5cUNZUFFlR0NMY1IrUy95ZDU1V1hxRDdzMDEwWnRkcENGbk1FWG9s?=
 =?utf-8?B?eWEwdWNzVStHUVVOZnBMMVZoMTN5NEthWWk5ekFYcUNEQmlhcytrZmdQeGxj?=
 =?utf-8?B?Y3FLaC8wL1dUekFSdUI4RGp6VjVwVStXTHp5aHAyNTc0WWxBOVIySXhlYTkx?=
 =?utf-8?B?NWNNYXVYQWVkcXp0MUJFemt4SjZmS2FJQS9KTHgwMnZ3Q1ZiaFRKaEVMUVB3?=
 =?utf-8?B?K01lOGVDMFZrWlYzWERycHZBRHY3WTNvMU9nei82R1FjdlJTQWRSUjJpYzhv?=
 =?utf-8?B?SEtvckFCV1JNSjg1T21xWTI2cnlXTkJYQTI3ZkhFelUyS2UyOGxIQUJhQmp0?=
 =?utf-8?B?RllZRFlJQkthcURvSkJVbngyN3hRZkFVSEhGYW9samREeWExbFVQWDF4Y090?=
 =?utf-8?B?SjRzR3ZEZXh6MUdTWHRESVBCNVBVOU9YNHYrQnNGa3F3R3VXWm9YZkFrOGJT?=
 =?utf-8?B?WWJWc2JNRGYzS1NVVHZBaXlkR3YvKzB5QkFIK2FjMEZwcHdKL1JEcTVYTUU5?=
 =?utf-8?B?VnhpMXErK2tLaGRGVjRsVk9qV3M3RzlMTE5MSytHR2ZIcG85OFFVdXZTTGJo?=
 =?utf-8?B?NXhHNDRKdlNyWU1BbXVoUW55dUc1T0huTE82Q0Y0WTJ0U0hwOEZlMC9ERGJz?=
 =?utf-8?B?QkhEOVZTTzVsRFdrNFAybHlFN0hCeUw0VlVlRlY5Q0dhMWdDTUtseGM2azJE?=
 =?utf-8?B?RjhiODZSRnRxT3lENk5ST2tsQ2R1SzVHemZ6UXNNb2F5VFlkU296UmZ0emxz?=
 =?utf-8?B?VnIxdkJld0NqekROZjYyc2xRMVRwcTVibVo2a0dRWUI2VmNBYW14VTQ5SURz?=
 =?utf-8?B?UHJEajRBL0VPeWFocEtSVTlEU1RKOWVqTWlic1dkZHQ0Tk8yaDJMcXY3aGdI?=
 =?utf-8?B?OVE2NVArYXQxQ0ZYU2gxOGVvRlk0dFRPbVk1anJXVzRPUFFMdEJSdGtMaEN6?=
 =?utf-8?Q?cHhWhINYdE0oiO1Z8KDi3TWk/iIUujNV?=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM6P137MB0130.EURP137.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(38070700018);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?utf-8?B?WXV1RVdJRWFhalk4SUF3UFM0RE90WnVpc0tGZ2ZnOTRuaFoxQ0RrcGJrVGVR?=
 =?utf-8?B?VDVUOUpudXVTWTI5cGFyMWNCSHFzTUgwY0svTWtMTmlyeXBHejk2R1F1ZEcw?=
 =?utf-8?B?YzhCcnhMRjVzWWEwa2QwOFlFVzVrZ1NRRkt2WVp4MGhPV0Z3RDloVGhzUFBD?=
 =?utf-8?B?UXVEN1RXMjkya1Y5MHdNR1pQaGN4aE8yS2VKVGpVdDFaU280c0JTT2FlMGZ3?=
 =?utf-8?B?RFh2WW1xbktrNWQ2YWJGQ3o5QlJCbHJoTm91V1hPZUxIK2tBSGQ2bktqc2NR?=
 =?utf-8?B?SlhWUWNkY0M0RmpBbzNRckJEbXc4clF0RUtLMTFDU1VDOGZVNENGNDVsUnRD?=
 =?utf-8?B?SnlkRjFJQmRiYzBvZy9IMFRGTkl2Z1ZXb3FHelV3cFl1V2VvTEkwdDhXZGpK?=
 =?utf-8?B?SXJyelJES3M4VkRDZSs4eGlReE1xcVhpNGU0VDlqN3NNNzVuSCtPbEl5eXpz?=
 =?utf-8?B?RVY3RHBTRzk0TUd5NXZVRS9BT1VVWHZlZ0NncHNhYjBuaGdFRUNKL0FEZWFU?=
 =?utf-8?B?Y05xK2hFTGZXR1BJSVI3RnhzanBMWUhrdStWTlBLQzRPbHhvTWlLS3FTQTVq?=
 =?utf-8?B?L0xmWDVEOWVVbVN3YitXZ2NIcGhxOGFGVndkYUVGMHdTQWs5TEcyaDY1aDhj?=
 =?utf-8?B?MlZoTnIwMTJua0I1ak5SYURvMzI0ZmJjTldNeFJXZnpuNHFvM094V3UrQzBz?=
 =?utf-8?B?ZHFqUmo2bHJHWHc2Ylpzb3BXQjhnaXUzaHFlWGE3T2dPWTkwRE1RNkM4RUR1?=
 =?utf-8?B?bUxsclVHTHR2Y0VSNkdYMEtPTXRQRzIweWNERERYTTdwcHVvektjbys4RXF1?=
 =?utf-8?B?dVc3aFV2Z0ZONFBsQnFzWHlyY0pFSlc1Tm5kdGFSYjVySTFmL1FZRkoxZ1dM?=
 =?utf-8?B?aHZxeG1kNnloTW9FN1dOOUJkZ05PUTdIZytnMVlRZXJRVVdUZllORDFBaStm?=
 =?utf-8?B?TnEzNzVEWW02a0lFWXlFc1ovYlkwOUw3N0xzdGlsSkJCZlNaSUUzMXNUQlJZ?=
 =?utf-8?B?WUw5bzd3NnhhenZmQ2FaVlFvNit6MTN2bVh6RVN1ZlNXL1ZYU1Vubnk5NFox?=
 =?utf-8?B?Q0FoTVVaNmprTzh4WTEzT0dNZHBlOVVHc2xZdUhyT0JMZCtLSlo2NkNQN3pB?=
 =?utf-8?B?NDROWjY5SkNYMGhCc0lFMTB5UmxjM1NuRXVpTm5iSHVGL2dyVXcvbXhnVjBM?=
 =?utf-8?B?NnZJbWc5dkVrTHV1OUNlN0x4TTFScUhGTDcvTHJXeU16VUM1L3RieTJXRFc0?=
 =?utf-8?B?b0FMQW5zQ1llZXBaZytpWmhTZVo4WUVpWWFPcURRQXU1ZkpCUDNnQy9kQWFv?=
 =?utf-8?B?dGJFeSt6cEVMMjlZMWt3VnNRM0ZLZm5Vak9aSjFOdStiYnZkQ3BITUVuK210?=
 =?utf-8?B?NzdnWVIvVG1HODhIVnZjOUpWV3ZsWUY3UzhZbXBveFBLa2tRTy82c2xwN2Ev?=
 =?utf-8?B?a0ltWW93Rkh6bzh5Y2FrREx2VkNFei9UdmdVOUFBeVdFcFZVOFJsd0xvb0dN?=
 =?utf-8?B?ZVVlS1h0MFpseCsrUVNIVnV0WEx1SnhlbHZ4RFM2TlEzelFvR2xLU3kxazIy?=
 =?utf-8?B?c1YwdWg1cVgxRllXdjJzTU9uak1NVkYwdnREYWdzdlkxV0w1STZrMnNHMzRt?=
 =?utf-8?B?RmcyWEZYZnlsWElQdEpudnZIdHdPVkltNG10OFJ2UU5nR1FrOEFXNjJSZHBt?=
 =?utf-8?B?TVhFcWhwbElUN21XTXBReG1IKzhNVWJuNy82TVN4K2tQNXhQcm0zdWNKUHNh?=
 =?utf-8?B?NzRGU2wyeGgwT1lLWk5wTzZqZERkYm44cW1BKzN1UHVORFRyY1Iya1ZZcUVj?=
 =?utf-8?B?MVRrWEt2NlFnTDVKTGZrTWRleVVkTUU3clEyNGVGZHhaQ2ZWNkhUeWhISjRw?=
 =?utf-8?B?Y0JSVndvQ2lkbXFXd3hCTStIMFp5QmIrVndlYjgxZ2V3NEZJQ1VKZGt4WCtF?=
 =?utf-8?B?MWROek5FdmpucGxaT2krSHVEQ3R4WWt0RVdBSm8zeVBsVlNxWE5VQWUxYU1p?=
 =?utf-8?B?Q3MydVBOS0U2SkZEeW02ZmVJRDdUNFdzRG1hYlQ5aE1OSW1kYWtXd1pYd3A4?=
 =?utf-8?B?L1VtMDFDU0JMSFF3clp3Ujkrc1ZoUlhLbXdxN3llK1JYSll1dktBN0t3cHIv?=
 =?utf-8?B?cGdJK2lRSnh1V2hWRkJ4T211eE1nVTljcWZQVXArUmtIdEZsMkRRZmZzTFZ4?=
 =?utf-8?B?NEE9PQ==?=
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 
	WvP0lxS+w2oLdp57HUgRgvammqqa1DqT3L1rQSTq956gk4tsPSsm5I553dCWbWWL31wgpIg4zeXHhFqzNQS03G+u73MJsYQgFGPGfgWTMMiCYPhGGvMKHyLcTQu6DeXsSRO0dLJ+I/b7MU5th3lhb8mnztiXCM/NBjSq8n813Vm78jna58RDtQPfGlrF3GPDgqsfUKyrtFrT9ddJeo+L+s1obDD3NhK8uXlqVYskSbB5CXGkMQzGbz+UYvpxc0xKisybtZKSO4dlk6ba8pXK2q2c8d0ruouLELSy1U2hOfZR5dc0PVtcia4mBYQsJi6m8j3BVHnJh53Tj4Vo2UNTlWFykfk3XVhwknMIREz14O7Xp+lhlMcvpsZFBRDqf/37zchBMyRcYjyD94jb05O3fFcvEALFw9OEYnBebjW0naiUiXDOiqGShHUcFTyU+qhL/zdOIO6B0XZ+9iKWfkJTEJRhU6srxearD+YJjyMc1X0ake4/+x+z5MsQ8+6eE2hhsAMYvn50L7XI0GfVT/ikxYkZh1eD3sEY82oBXJF1ZUmJVStlk8hf9/38bix0H2YxlVYY4gMey2QXmiclpUc1qU8NX9oLG0eF+Pdrg8RhXAg=
X-OriginatorOrg: gsk.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AM6P137MB0130.EURP137.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 a4dba94d-84f7-40a9-ba51-08dd4432b64b
X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Feb 2025 09:11:15.3796
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 63982aff-fb6c-4c22-973b-70e4acfb63e6
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 vDac5OphsXmBbeuL+Xa7AkGSCgYXMl8d/slLlH4TJNBNY7gGG2jxOyf0rDVDs9T22dQz+T2rMO8XcDNwn3BewN3clOXojEg/2zNw8JBUp9U=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DBBP137MB0208
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-Proofpoint-ORIG-GUID: qNDhSyjL87U7vH8kZSNsDmD98_dWfeSW
X-Proofpoint-GUID: qNDhSyjL87U7vH8kZSNsDmD98_dWfeSW
X-Authority-Analysis: v=2.4 cv=B8ND0PtM c=1 sm=1 tr=0 ts=67a08834 cx=c_pps
 a=nBrI8LKFnEUVNABbkVKS9g==:117 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19
 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=IkcTkHD0fZMA:10
 a=T2h4t0Lz3GQA:10 a=Lo-oz4UuykAA:10
 a=tWWV6Wk_gvQA:10 a=l0jVf1vqAAAA:8 a=epTmVMiNAAAA:8 a=WZ1Tn1H9ERxI9YGUITQA:9
 a=QEXdDO2ut3YA:10 a=uJV6kkqUd69fLCNxCZCc:22
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/AM6P137MB0130E6C698B0A36DBC861D2BD6F52%40AM6P137MB0130.EURP137.PROD.OUTLOOK.COM>
Precedence: bulk

Hi,

Thank you for your response.

Can you please ping me specific mailing list for the JDBC driver so that I =
can get better solutions.

Thanks and Regards
Rajyalakshmi Sareddy
Integration Developer
Middleware & Integration
GSK Tech
Hyderabad, India
E: rajyalakshmi.x.sareddy@gsk.com
M: +91 8309974485


-----Original Message-----
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Saturday, February 1, 2025 5:13 AM
To: Rajyalakshmi Sareddy <rajyalakshmi.x.sareddy@gsk.com>; pgsql-novice@pos=
tgresql.org
Subject: Re: Regarding setClob and getclobval methods in PostgreSQL

On Fri, 2025-01-31 at 11:35 +0000, Rajyalakshmi Sareddy wrote:
> We are currently migrating the code from oracle to postgresql and
> using jdbc jar ispostgresql-42.7.4.jar. But for code migration, we are
> getting errors like
> org.postgresql.jdbc.PgPreparedStatement.setClob(int, Reader) is not yet i=
mplemented.
>
> 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.

I can only confirm that that method is *not* implemented.
You would have to use setClob(int parameterIndex, Clob x) instead.

But really, *do not* use any of the getClob and setClob methods, because th=
ey use Large Objects in PostgreSQL, and you should avoid Large Objects.

Use setBinaryStream(int parameterIndex, InputStream x) instead, so that you=
 can use "bytea" in the database.

By the way, there is a specific mailing list for the JDBC driver, where you=
 may get better answers.

Yours,
Laurenz Albe
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 appro=
priate confidentiality controls and in accordance with local laws and after=
 appropriate consultation.