OK, I did the following:
a)Set Eclipse to launch in c:\users\public\varisk. This is the same
physical location as the UNC path given earlier.
b)Shutdown and then restarted the server.
c)When I launch my java app, it tries to connect to the DB, and I get:
jdbc:h2:tcp://192.168.1.101:9091/file://c:\Users\Public\VARisk\VARiskDB
Could not create database, error received was: IO Exception:
"java.io.SyncFailedException: sync failed";
"C:/Users/Public/VARisk/VARiskDB.h2.db" [90031-147]. Closing program
now.
DB Connect Time=0
org.h2.jdbc.JdbcSQLException: IO Exception:
"java.io.SyncFailedException: sync failed";
"C:/Users/Public/VARisk/VARiskDB.h2.db" [90031-160]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.message.DbException.convertIOException(DbException.java:315)
at org.h2.store.FileStore.sync(FileStore.java:437)
at org.h2.store.PageStore.writeVariableHeader(PageStore.java:924)
at org.h2.store.PageStore.setLogFirstPage(PageStore.java:918)
at org.h2.store.PageLog.openForWriting(PageLog.java:188)
at org.h2.store.PageStore.openExisting(PageStore.java:360)
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.server.TcpServerThread.run(TcpServerThread.java:124)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.SyncFailedException: sync failed
at java.io.FileDescriptor.sync(Native Method)
at org.h2.store.fs.FileDisk.force(FilePathDisk.java:387)
at org.h2.store.FileStore.sync(FileStore.java:435)
... 15 more
at org.h2.engine.SessionRemote.done(Unknown Source)
at org.h2.engine.SessionRemote.a(Unknown Source)
at org.h2.engine.SessionRemote.a(Unknown Source)
at org.h2.engine.SessionRemote.int(Unknown Source)
at org.h2.engine.SessionRemote.createSession(Unknown Source)
at org.h2.jdbc.JdbcConnection.<init>(Unknown Source)
at org.h2.jdbc.JdbcConnection.<init>(Unknown Source)
at org.h2.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dataSource.H2LoanDataSource.<init>(H2LoanDataSource.java:31)
at
dataSource.LoanSourceFactory.getLoanDataSource(LoanSourceFactory.java:60)
at
dataSource.LoanSourceFactory.getLoanDataSource(LoanSourceFactory.java:27)
at tables.ScenarioTable.refreshScenarioData(ScenarioTable.java:287)
at forms.UserInterfaceForm.createContents(UserInterfaceForm.java:1091)
at forms.UserInterfaceForm$1.run(UserInterfaceForm.java:815)
at
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at forms.UserInterfaceForm.open(UserInterfaceForm.java:791)
at exec.FrontEndLauncher.run(FrontEndLauncher.java:54)
at exec.FrontEndLauncher.main(FrontEndLauncher.java:38)
org.h2.jdbc.JdbcSQLException: IO Exception:
"java.io.SyncFailedException: sync failed";
"C:/Users/Public/VARisk/VARiskDB.h2.db" [90031-160]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.message.DbException.convertIOException(DbException.java:315)
at org.h2.store.FileStore.sync(FileStore.java:437)
at org.h2.store.PageStore.writeVariableHeader(PageStore.java:924)
at org.h2.store.PageStore.setLogFirstPage(PageStore.java:918)
at org.h2.store.PageLog.openForWriting(PageLog.java:188)
at org.h2.store.PageStore.openExisting(PageStore.java:360)
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.server.TcpServerThread.run(TcpServerThread.java:124)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.SyncFailedException: sync failed
at java.io.FileDescriptor.sync(Native Method)
at org.h2.store.fs.FileDisk.force(FilePathDisk.java:387)
at org.h2.store.FileStore.sync(FileStore.java:435)
... 15 more
at org.h2.engine.SessionRemote.done(Unknown Source)
at org.h2.engine.SessionRemote.a(Unknown Source)
at org.h2.engine.SessionRemote.a(Unknown Source)
at org.h2.engine.SessionRemote.int(Unknown Source)
at org.h2.engine.SessionRemote.createSession(Unknown Source)
at org.h2.jdbc.JdbcConnection.<init>(Unknown Source)
at org.h2.jdbc.JdbcConnection.<init>(Unknown Source)
at org.h2.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dataSource.H2LoanDataSource.openDataSource(H2LoanDataSource.java:378)
at tables.ScenarioTable.refreshScenarioData(ScenarioTable.java:288)
at forms.UserInterfaceForm.createContents(UserInterfaceForm.java:1091)
at forms.UserInterfaceForm$1.run(UserInterfaceForm.java:815)
at
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at forms.UserInterfaceForm.open(UserInterfaceForm.java:791)
at exec.FrontEndLauncher.run(FrontEndLauncher.java:54)
at exec.FrontEndLauncher.main(FrontEndLauncher.java:38)
java.lang.NullPointerException
java.lang.NullPointerException
at dataSource.LoanDataSource.getFieldNames(LoanDataSource.java:357)
at forms.UserInterfaceForm.createContents(UserInterfaceForm.java:1094)
at forms.UserInterfaceForm$1.run(UserInterfaceForm.java:815)
at
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at forms.UserInterfaceForm.open(UserInterfaceForm.java:791)
at exec.FrontEndLauncher.run(FrontEndLauncher.java:54)
at exec.FrontEndLauncher.main(FrontEndLauncher.java:38)
Any idea on how to "resync" the DB would be great, because I'd hate to
lose the ~40 gig of data in it.
--
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.
