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