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]<javascript:_e({}, 'cvml',
> '[email protected]');>
> .
> To unsubscribe from this group, send email to
> [email protected] <javascript:_e({}, 'cvml',
> 'h2-database%[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 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.
