The DB is created. Tables, sequences and indexes are created all with 'IF NOT EXISTS' phrase.
The code for DB opening shares some procedures with the code that creates a DB, esp. the part that creates the aforementioned tables, sequences and indexes. If the DB is opened in read-only mode then: 1) All CREATE TABLE IF NOT EXISTS ... succeed as the tables are already there. 2) All CREATE SEQUENCE IF NOT EXISTS ... succeed as the sequences are already there. 3) CREATE INDEX IF NOT EXISTS ... fails despite the index is also already present. So it looks like the H2 code that is responsible for index creation is too keen on checking the RW access. -- 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.
