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/-/kv-wwGifzpgJ.
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.
