-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Alex,
On 8/27/18 20:47, Alex O'Ree wrote: > On Mon, Aug 27, 2018, 7:19 PM Christopher Schultz < > ch...@christopherschultz.net> wrote: On 8/24/18 16:08, Alex O'Ree > wrote: >>>> I have a use case where i need to downcast a pooled database >>>> connection down to the native class that is in use for the >>>> driver. Unfortunately I don't see any APIs that I can use to >>>> do this. Is there any backdoors or mechanisms I can use? >>>> >>>> Background, I'm using postgres with tomcat 8.5 and need to >>>> access some postgres specific apis, (the large binary object >>>> api). I've tried with both the tomcat based pool and the dbp2 >>>> connection pooling too. >> >> What's wrong with the existing JDBC APIs for working with BLOBs? >> It's been a really long time since anyone has really had to >> down-cast JDBC interface types to their implementation types to >> get around deficiencies in the APIs. > > I'm storing large files. Postgres has a limit for blobs and uses a > different api for larger stuff. Cut off is 1gb Interesting. I wonder why Postgres decided not to support that through the standard JDBC API. Have you tried setting the "compatible" flag on the connection just to see if it works for you? - -chris -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAluFTFAACgkQHPApP6U8 pFj9Bw//dowFYiOISbNuF4v9wKkP+QqH9duSGtEPcQ/Og17YagGi4Soci1kI9xde JTIi4ie95Xd5Sa0W5ns/geqFD2qQA5GmVbb6GfwRHn+MRslChnATHB842+mmLHE7 9tOfXfuMmlHj1//rAL8f23y6wcFq2NfTZNLxL+VwI3hCbv/hxJtA8jIToBn7kqBm cF7aA/StfpVwTFKY+r81G8rvxuD+CXuoASsDRHJl6h3bjqnu+iDvtqL1UBBnoUo4 K/GUbKvbYoex2zPgIyqnZM0DuVUtITuYpzZLfT8Yy1rVvXj7YcPZBsP+nC6B0pcQ X+N4770oUMZ9gxlrnKq3kyryuEwsX5Pg8dHcKUPp1iD6df5qajsQx03hKI9OgIaq Wamovoj3xvHR9UFvxaGO/7iykMK5gYc3HsoWM7TCxk0Plfm3kLJWMv7SQQmLZVLB dg5iMy43Ne2J9tYJUe9O0tp6w7CJYtj77+ngbhuUmZlct+nGS/GRkGAak/GkAgRZ tkmpy6UqP6ExPPATYesmy8yinLh09HJjXmkXksksdrM1M2H9vH9NxpFDf4Yu3kne 2HXIAun1q7UVKiZ831u0dyPHHcpzEfKyB5U18vFctrxHardBAabLaB0BMQeSvs/1 UtUafOomMvRqxisKZExBRUoO2Q92XIpJIYiUkbA9S35/ZPozckE= =IbSz -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org