On 24/03/2023 16:33, Russell Bateman wrote:
Late yesterday afternoon, I hit upon the idea of inserting a '?' where
the CLOB would be, then using PreparedStatement to satisfy it. *This
worked and I'm able to insert even 20Mb-long rows*:
And you know what, you should always do this anyway to
On 24/03/2023 16:33, Russell Bateman wrote:
Late yesterday afternoon, I hit upon the idea of inserting a '?' where
the CLOB would be, then using PreparedStatement to satisfy it. *This
worked and I'm able to insert even 20Mb-long rows*:
Yes, the limit is purely a limit on the length of string
Late yesterday afternoon, I hit upon the idea of inserting a '?' where
the CLOB would be, then using PreparedStatement to satisfy it. *This
worked and I'm able to insert even 20Mb-long rows*:
final String INSERT_CLOB = "INSERT INTO ... ? ...)"; Clob clob =
connection.createClob();
On 24/03/2023 07:38, Stanimir Stamenkov via derby-user wrote:
Thu, 23 Mar 2023 14:54:50 -0600, /Russell Bateman/:
In fact, experimentation seems to suggest that the breaking point is a
length of 32K+.
This seems to match the VARCHAR and LONG VARCHAR specifications:
*
I can confirm this: my application happily inserts CLOB data well over the 32K
using JPA
On Mar 24 2023, at 5:38 am, Stanimir Stamenkov via derby-user
wrote:
> Thu, 23 Mar 2023 14:54:50 -0600, /Russell Bateman/:
>
> > In fact, experimentation seems to suggest that the breaking point is a
> >
Thu, 23 Mar 2023 14:54:50 -0600, /Russell Bateman/:
In fact, experimentation seems to suggest that the breaking point is a
length of 32K+.
This seems to match the VARCHAR and LONG VARCHAR specifications:
* https://db.apache.org/derby/docs/10.16/ref/rrefsqlj41207.html
*
In fact, experimentation seems to suggest that the breaking point is a
length of 32K+. Whether or not the length of the rest of the INSERT INTO
statement counts I do not know for certain, but the delta between
MsgContent and the rest is negligeable, so I don't care.
On 3/23/23 13:02, Russell