Hi, thanks for the reply.
I've done this but it doesn't seem to affect anything and i get The object
is already closed [90007-167] when using auto_server and select * on a
table containing many LOBs
Could i suggest this as a bug and be included in the next release?
Thanks again
On Wednesday, 30 May 2012 08:21:37 UTC+1, Thomas Mueller wrote:
>
> Hi,
>
> You can't change the settings of the server from within the client. One
> solution might be to set the system properties in all applications that use
> the database.
>
> Regards,
> Thomas
>
>
>
> On Tuesday, May 29, 2012, h2_mad wrote:
>
>> Hi,
>>
>> Still wondering if you can set the fetch size and server cache size when
>> using auto mixed mode?
>>
>> Thanks
>>
>>
>>
>> On Thursday, 24 May 2012 16:40:30 UTC+1, h2_mad wrote:
>>>
>>> Also when i issue this select stmt i don't see any information relating
>>> to the properties i desire to see:
>>>
>>> select * from INFORMATION_SCHEMA.SETTINGS
>>>
>>>
>>>
>>>
>>> On Thursday, 24 May 2012 16:30:03 UTC+1, h2_mad wrote:
>>>>
>>>> Hi,
>>>>
>>>> I am using auto mixed server mode.
>>>>
>>>> Since i set to use this mode by setting AUTO_SERVER=true on my connect
>>>> string and not programmatically like in full server mode, can i affect
>>>> the server side of the auto mixed mode by settings the properties
>>>> before db startup? By either:
>>>>
>>>> System.setProperty("h2.**serverCachedObjects", "512");
>>>> System.setProperty("h2.**serverResultSetFetchSize", "1024");
>>>>
>>>> or:
>>>>
>>>> -Dh2.serverCachedObjects=512
>>>> -Dh2.serverResultSetFetchSize=**1024
>>>>
>>>> The reason why i'm asking is that i was seeing problems seemingly
>>>> related to this issue:
>>>> http://stackoverflow.com/**questions/9779324/program-**
>>>> hangs-after-retrieving-100-**rows-containg-clob<http://stackoverflow.com/questions/9779324/program-hangs-after-retrieving-100-rows-containg-clob>
>>>>
>>>>
>>>> When i updated to use the latest h2 jar of 167 my similar problems
>>>> went away with auto server.
>>>>
>>>> I'm assuming that auto server mode uses full server code. I believe
>>>> since moving to 167 where this change is in the change log:
>>>> "Server mode: the number of CLOB / BLOB values that were cached on the
>>>> server is now the maximum of: 5 times the SERVER_RESULT_SET_FETCH_SIZE
>>>> (which is 100 by default), and SysProperties.SERVER_CACHED_**OBJECTS."
>>>>
>>>> ... my problem has disappeared by accident as the new change to 167 is
>>>> masking (temporarily) my similar LOB issues..
>>>>
>>>> Can i affect a change to server settings when i'm in auto mixed server
>>>> mode???
>>>>
>>>> Thanks in advance for your replies, cheers
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/h2-database/-/ovyPLYxka2UJ.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to
>> [email protected].
>> For more options, visit this group at
>> http://groups.google.com/group/h2-database?hl=en.
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/vOz4cfQPBoMJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
