I have a database with a single table containing about 90K clobs. I create the database, load the table, shutdown the db and use the java backup to create a zip version of it.
When I go to open a connection to it using jdbc:h2:zip:<path> I get the following error: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: File is read-only"; "zip:D:\SA\IBMPROD\Epackage_out\IBMPROD.AttachSA.dbc!/ IBMPROD.AttachSA.h2.db" [90031-126] org.h2.message.Message.getSQLException(Message.java:110) org.h2.message.Message.convertIOException(Message.java:325) org.h2.store.FileStore.write(FileStore.java:341) org.h2.store.FileStore.writeDirect(FileStore.java:318) org.h2.store.FileStore.init(FileStore.java:187) org.h2.engine.Database.openFile(Database.java:497) org.h2.store.PageStore.openNew(PageStore.java:276) org.h2.store.PageStore.open(PageStore.java:260) org.h2.engine.Database.getPageStore(Database.java:2310) org.h2.engine.Database.open(Database.java:623) org.h2.engine.Database.openDatabase(Database.java:226) org.h2.engine.Database.<init>(Database.java:221) org.h2.engine.Engine.openSession(Engine.java:58) org.h2.engine.Engine.openSession(Engine.java:142) org.h2.engine.Engine.getSession(Engine.java:122) org.h2.engine.SessionFactoryEmbedded.createSession (SessionFactoryEmbedded.java:17) org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java: 245) org.h2.engine.SessionRemote.createSession(SessionRemote.java:223) org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110) org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) org.h2.Driver.connect(Driver.java:58) java.sql.DriverManager.getConnection(DriverManager.java:582) java.sql.DriverManager.getConnection(DriverManager.java:185) com.sps.sa.services.H2Service.startRODB(H2Service.java:90)
-- 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.
