Hi, I've DB created in memory by H2 1.3.176 and dumped to a file. Then I'm trying to use this DB in read only mode but it fails because it looks like H2 tries to add column to INFORMATION_SCHEMA.LOB_MAP. table.
ALTER TABLE INFORMATION_SCHEMA.LOB_MAP ADD IF NOT EXISTS POS BIGINT BEFORE HASH [90097-176] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:512) ~[HikariCP-2.5.1.jar:?] at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:105) ~[HikariCP-2.5.1.jar:?] at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71) ~[HikariCP-2.5.1.jar:?] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_121] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_121] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_121] It seems that org.h2.store.LobStorageBackend#init expect to have such column and tries to add this during first connection. When I access the same DB (generated with 176) using older H2 version (155) then it seems to work fine. What can be the reason why this column was not created during DB generation ? The generation procedure looks more or less like this: create connection to in memory DB, created schema (using eclipselink), put a data, shutdown db (SHUTDOWN DEFRAG;). Then db file is copied to different location. It is 176 bug ? Or maybe I'm doing something wrong. As workaround I can open DB in rw mode although I'm only reading it or I can access it using older H2 version, which as I understand is not recommended. Regards Michal -- 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.
