So we have a database hosted on a networked drive. One day I tried to connect to H2 and got this error via the browser tool:
General error: "java.lang.NoClassDefFoundError: org/h2/engine/Constants"; SQL statement: SELECT UPPER(VALUE) FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME='MODE' [50000-171]<http://192.168.30.113:8082/tables.do?jsessionid=dc43494160387c9488a2572beb0e0753#> HY000/50000 org.h2.jdbc.JdbcSQLException: General error: "java.lang.NoClassDefFoundError: org/h2/engine/Constants"; SQL statement: SELECT UPPER(VALUE) FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME='MODE' [50000-169] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:158) at org.h2.message.DbException.convert(DbException.java:277) at org.h2.command.Command.executeQuery(Command.java:195) at org.h2.server.TcpServerThread.process(TcpServerThread.java:308) at org.h2.server.TcpServerThread.run(TcpServerThread.java:149) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NoClassDefFoundError: org/h2/engine/Constants at org.h2.table.MetaTable.generateRows(MetaTable.java:859) at org.h2.index.MetaIndex.find(MetaIndex.java:45) at org.h2.index.BaseIndex.find(BaseIndex.java:102) at org.h2.index.IndexCursor.find(IndexCursor.java:145) at org.h2.table.TableFilter.next(TableFilter.java:322) at org.h2.command.dml.Select.queryFlat(Select.java:513) at org.h2.command.dml.Select.queryWithoutCache(Select.java:618) at org.h2.command.dml.Query.query(Query.java:307) at org.h2.command.dml.Query.query(Query.java:277) at org.h2.command.dml.Query.query(Query.java:36) at org.h2.command.CommandContainer.query(CommandContainer.java:86) at org.h2.command.Command.executeQuery(Command.java:191) ... 3 more at org.h2.engine.SessionRemote.done(SessionRemote.java:568) at org.h2.command.CommandRemote.executeQuery(CommandRemote.java:149) at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76) at org.h2.server.web.DbContents.readContents(DbContents.java:111) at org.h2.server.web.WebApp.tables(WebApp.java:662) at org.h2.server.web.WebApp.process(WebApp.java:219) at org.h2.server.web.WebApp.processRequest(WebApp.java:164) at org.h2.server.web.WebThread.process(WebThread.java:137) at org.h2.server.web.WebThread.run(WebThread.java:93) at java.lang.Thread.run(Unknown Source) I'm pretty new to using H2, and havent been able to find this sort of error anywhere online, so any help as to what the issue might be would be great. We can't access any of the tables in the database, so it seems corrupted, We have a backup but we would like to make sure this sort of corruption doesn't occur again. Thanks! -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
