This is the URL used by the production application for accessing the remote H2 database:
jdbc:h2:ssl://192.168.1.9:35001/var/data/Prod_Database/Server_Util-DB I believe that MVCC is enabled right now as there is an entry in the INFORMATION_SCHEMA.SETTINGS table that indicates this. We don't require MVCC so I could turn this off without any problems; would that be as simple as updating the SETTINGS table to set the flag to FALSE or is it required that I add this to the database URL to disable it correctly? The information held by the settings table is attached if this is useful. NAME | VALUE MVCC | TRUE > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
sql> select * from information_schema.settings order by name; NAME | VALUE ALIAS_COLUMN_NAME | false ANALYZE_AUTO | 2000 ANALYZE_SAMPLE | 10000 COMPRESS | false CREATE_BUILD | 159 DATABASE_TO_UPPER | true DB_CLOSE_ON_EXIT | true DEFAULT_CONNECTION | false DEFAULT_ESCAPE | \ DEFAULT_TABLE_ENGINE | null DEFRAG_ALWAYS | false DROP_RESTRICT | true EARLY_FILTER | false ESTIMATED_FUNCTION_TABLE_ROWS | 1000 EXCLUSIVE | FALSE FUNCTIONS_IN_SCHEMA | true LARGE_TRANSACTIONS | true LOB_TIMEOUT | 300000 LOG | 2 MAX_COMPACT_COUNT | 2147483647 MAX_COMPACT_TIME | 200 MAX_MEMORY_ROWS | 50000 MAX_QUERY_TIMEOUT | 0 MODE | REGULAR MULTI_THREADED | 0 MULTI_THREADED | false MVCC | TRUE MV_STORE | true NESTED_JOINS | true OPTIMIZE_DISTINCT | true OPTIMIZE_EVALUATABLE_SUBQUERIES | true OPTIMIZE_INSERT_FROM_SELECT | true OPTIMIZE_IN_LIST | true OPTIMIZE_IN_SELECT | true OPTIMIZE_IS_NULL | true OPTIMIZE_OR | true OPTIMIZE_TWO_EQUALS | true OPTIMIZE_UPDATE | true PAGE_STORE_INTERNAL_COUNT | false PAGE_STORE_MAX_GROWTH | 131072 PAGE_STORE_TRIM | true QUERY_CACHE_SIZE | 8 QUERY_TIMEOUT | 0 RECOMPILE_ALWAYS | false RECONNECT_CHECK_DELAY | 200 RETENTION_TIME | 0 REUSE_SPACE | true ROWID | true SELECT_FOR_UPDATE_MVCC | true SHARE_LINKED_CONNECTIONS | true info.BUILD_ID | 194 info.CACHE_MAX_SIZE | 116512 info.CACHE_SIZE | 20636 info.FILE_READ | 2395 info.FILE_WRITE | 7 info.FILE_WRITE_TOTAL | 379759267 info.PAGE_COUNT | 32316887 info.PAGE_SIZE | 2048 info.VERSION | 1.4.194 (2017-03-10) info.VERSION_MAJOR | 1 info.VERSION_MINOR | 4 property.file.encoding | UTF-8 property.file.separator | / property.java.runtime.version | 1.7.0_72-b14 property.java.vendor | Oracle Corporation property.java.vm.name | Java HotSpot(TM) 64-Bit Server VM property.line.separator | property.os.arch | amd64 property.os.name | Linux property.os.version | 3.11.0-12-generic property.path.separator | : property.sun.os.patch.level | unknown property.user.country | US property.user.language | en property.user.variant | (75 rows, 16 ms)
