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
>>
>>
>> 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.
