Hello everyone , Now I have encountered a problem, when I try to connect the H2 DB, it thows the SQLNestedException: Cannot create PoolableConnectionFactory (File corrupted while reading record: "4587 of 4552". Possible solution: use the recovery tool [90030-161]). what is the matter with the db ,and how can I solve the problem . Thanks! the following is parts of the exption detail: Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (File corrupted while reading record: "4587 of 4552". Possible solution: use the recovery tool [90030-161]) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48) at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:110) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:86) Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "4587 of 4552". Possible solution: use the recovery tool [90030-161] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.store.PageStore.readPage(PageStore.java:1257) at org.h2.store.PageStore.getPage(PageStore.java:712) at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:225) at org.h2.index.PageDataNode.getLastKey(PageDataNode.java:208) at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:82) at org.h2.table.RegularTable.<init>(RegularTable.java:83) at org.h2.store.PageStore.addMeta(PageStore.java:1601) at org.h2.store.PageStore.readMetaData(PageStore.java:1532) at org.h2.store.PageStore.recover(PageStore.java:1336) at org.h2.store.PageStore.openExisting(PageStore.java:354) at org.h2.store.PageStore.open(PageStore.java:278) at org.h2.engine.Database.getPageStore(Database.java:2090) at org.h2.engine.Database.open(Database.java:551) at org.h2.engine.Database.openDatabase(Database.java:219) at org.h2.engine.Database.<init>(Database.java:214) at org.h2.engine.Engine.openSession(Engine.java:56) at org.h2.engine.Engine.openSession(Engine.java:159) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) at org.h2.engine.Engine.createSession(Engine.java:121) at org.h2.engine.Engine.createSession(Engine.java:28) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:285) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) at org.h2.Driver.connect(Driver.java:72) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) ... 22 more
-- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
