Dear Thomas,
We are trying to use H2 in embedded mode in a
small java application. The application works fine on Windows XP, but
the same application can't insert into database (says DB in read only
mode) when the java app runs on a Windows vista machine. We saw the
posting of bug 311 and used the latest build of DB 1.3.160, but the
problem is still persisting.
Below is the error we are getting.
org.h2.jdbc.JdbcSQLException: The database is read only; SQL
statement:
insert into Mytable (col1 ,col2)values(5,5) [90097-153]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1616)
at org.h2.table.Table.checkWritingAllowed(Table.java:1042)
at org.h2.engine.User.hasRight(User.java:111)
at org.h2.engine.User.checkRight(User.java:97)
at org.h2.command.dml.Insert.insertRows(Insert.java:95)
at org.h2.command.dml.Insert.update(Insert.java:86)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:212)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:
143)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:
129)
Can you please provide some insights on how to resolve it.
We are not getting the error on Vista if we run the database on some
other machine in server mode and app connects to it in client server
mode. Error comes only when DB is run in embedded mode only on Vista
machines.
--
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.
