Hi, > Can these tow settings work together? I mean with > AUTO_SERVER=TRUE;MVCC=TRUE?
Yes. I don't see a reason why not. > I am also wondering the default setting for MULTI_THREAD Disable - see http://www.h2database.com/html/grammar.html#set_multi_threaded - "By default, this setting is disabled" > If you have a list of default settings when creating a database that > would be very helpful. (Maybe I havent look much on the guides/ > tutorials). The defaults should be documented. Please tell me where it's not. > I am also wondering about database properties if they are overwritten/ > overridden when I create a new connection to it. Do you mean whether the setting is persistent or not? This is usually documented as well. > I create > the database using jdbc:h2:test;AUTO_COMMIT=TRUE;MVCC=TRUE and then I > create a new connection to it using > jdbc:h2:test;AUTO_COMMIT=FALSE;MVCC=FALSE. Usually settings are overwritten when you change them. However MVCC is a special case. This should be documented at http://www.h2database.com/html/advanced.html#mvcc - but it's not yet. I will add the following: "It is not possible to enable or disable this setting while the database is already open. The setting must be specified in the first connection (the one that opens the database)." > What happens if I dont > specify AUTO_COMMIT and MVCC on a new connection? Autocommit is enabled by default (as defined by the JDBC spec). MVCC is disabled by default (I will document that). > Does it inherit the properties from the last connection? Autocommit not (it's per session - see the JDBC spec). Otherwise yes. > Of course, in the case of the username and password that can not be > change using that right? It is set at the creation of the database. Yes - to change see http://www.h2database.com/html/grammar.html#alter_user_set_password Regards, Thomas -- 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.
