I have a query that returns a very large result set, which gets overflowed
to disk in a size that is too large. The environment has ample memory to
handle this result set, however I haven't been able to find which
configuration parameter controls the maximum in-memory size for a result
set.
I
Thanks! That's exactly what I needed.
On Wednesday, February 2, 2022 at 1:26:10 PM UTC-6 Noel Grandin wrote:
> You'd have to modify how the java VM chooses where to put temporary files.
> There are various ways to do that depending on how you want to control it,
> but at minimum it would have
I am using an embedded H2 DB (v2.1.210) in a Windows Server 2016
environment.
I have the database configured to use a jdbc URL with a relative path from
a location on the D: drive (jdbc:h2:../data).
I have a query with a large result set that seemed to be hanging. Upon
further investigation, i
for holding LOBs that are
in an active result set. Certainly having a default cache size that is
less than the default fetch size seems less than ideal.
On Mar 19, 8:56 pm, Ron Aaronson ro...@optonline.net wrote:
I am retrieving one text column (CLOB) from a table in a remote H2
database (actually
to be the wrong structure for holding LOBs that are in
an active result set. Certainly having a default cache size that is less
than the default fetch size seems less than ideal.
On Monday, March 19, 2012 8:56:00 PM UTC-4, Ron Aaronson wrote:
I am retrieving one text column (CLOB) from a table in a remote
I am retrieving one text column (CLOB) from a table in a remote H2
database (actually on a local drive, but using Server, i.e. tcp/ip, to
access it) and after retrieving the first 100 rows the program hangs
on retrieving the next row of the result set. If, on the other hand, I
access the same
Hi
Thank you, I have change the source code, you mean I have to post ths
changes?
If I post it and then i can use my project to make money?
By the way, H2 is a very good project, thank you.
On 2月24日, 上午4时04分, Thomas Mueller thomas.tom.muel...@gmail.com
wrote:
Hi,
I just modify some code of
Hi
Anybody can help me?
On 2月22日, 下午9时06分, Ron nnronk...@gmail.com wrote:
Sorry,I do not speak English. I have a question.
If I develop a project using H2. This project is DB Server too, and I
call it another name, but I tell to the user it is really H2,
I just modify some code of H2 and add
Sorry,I do not speak English. I have a question.
If I develop a project using H2. This project is DB Server too, and I
call it another name, but I tell to the user it is really H2,
I just modify some code of H2 and add some other function.
If I use this project to commercial area, did I violate