Hello, I just tested the current upgrade procedure. I logged every open file in H2. Before the rename operation there is no file open. So I can only guess its a client problem.
Are you capable of checking out h2, compiling your own version and run tests? Maybe then you'll get a clue where the problem is. Regards Christian On Feb 17, 10:15 pm, SuperSpinner <[email protected]> wrote: > I tried this with a standalone program just using the driver and there > is still a problem on windows; i.e. the files are considered locked > and cannot be renamed. > > On Feb 15, 4:45 pm, SuperSpinner <[email protected]> wrote: > > > > > > > > > Alas, no joy. For some reason those files are locked against > > modification. As you can see, I'm running in Jetty and we use our > > slightly modded version of dbcp connection pool. > > > at > > com.guidewire.commons.jetty.GWServerJettyServerMain.main(GWServerJettyServerMain.java: > > 93) > > Caused by: org.h2.jdbc.JdbcSQLException: Error while renaming file "C: > > \tmp\guidewire\diamond\px.data.db" to "C:\tmp\guidewire\diamond > > \px.data.db.backup" [90024-151] > > at org.h2.message.DbException.getJdbcSQLException(DbException.java: > > 327) > > at org.h2.message.DbException.get(DbException.java:167) > > at org.h2.store.fs.FileSystemDisk.rename(FileSystemDisk.java:105) > > at org.h2.util.IOUtils.rename(IOUtils.java:740) > > at org.h2.upgrade.DbUpgrade.upgrade(DbUpgrade.java:137) > > at org.h2.upgrade.DbUpgrade.connectOrUpgrade(DbUpgrade.java:74) > > at org.h2.Driver.connect(Driver.java:64) > > at java.sql.DriverManager.getConnection(DriverManager.java:582) > > at java.sql.DriverManager.getConnection(DriverManager.java:154) > > at > > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java: > > 78) > > at > > com.guidewire.pl.system.database.connection.DBCPNonSyncPoolableConnectionFactory.makeObject(DBCPNonSyncPoolableConnectionFactory.java: > > 57) > > at > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java: > > 1148) > > at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java: > > 180) > > > > On Feb 15, 11:36 am, Christian Peter > > > > <[email protected]> wrote: > > > > Hi, > > > > > apparently I broke it. Sorry for that. > > > > > In version 1.3.148 Thomas did refactor it, so I guess you might have > > > > another result with a newer version. > > > > > Please try it and tell me if it works for you. I will then make a 1. 2 > > > > version with the fix for you (though I'm very busy at the moment, so > > > > it could take some time). > > > > > Regards -- 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.
