Every insert gives this in bms.trace.db org.h2.jdbc.JdbcSQLException: The database is read only; SQL statement: insert into Element (lastSeen, sources, name, options, tupple, host_string, assets2, DTYPE, string) values (?, ?, ?, ?, ?, ?, ?, 'DeviceCapabilityService', ?) [90097-168]^M at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)^M at org.h2.message.DbException.get(DbException.java:169)^M at org.h2.message.DbException.get(DbException.java:146)^M at org.h2.message.DbException.get(DbException.java:135)^M at org.h2.engine.Database.checkWritingAllowed(Database.java:1702)^M at org.h2.table.Table.checkWritingAllowed(Table.java:1060)^M at org.h2.engine.User.hasRight(User.java:111)^M at org.h2.engine.User.checkRight(User.java:97)^M at org.h2.command.dml.Insert.insertRows(Insert.java:93)^M at org.h2.command.dml.Insert.update(Insert.java:84)^M at org.h2.command.CommandContainer.update(CommandContainer.java:75)^M at org.h2.command.Command.executeUpdate(Command.java:230)^M at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156)^M at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142)^M at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)^M at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:125)^M at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)^M at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3058)^M at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3499)^M at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)^M at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)^M at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)^M at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:275)^M at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:328)^M at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)^M at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1212)^M at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:996)^M at org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:439)^M at ...my code
Note that the problem started off on a win7, next i copied the bms.h2.db file to my ubuntu laptop, restart my app, and i get stuck the same way. The file permissions on linux are set to allow everyone to read/write. The file permissions on Win7 were also such that the SYSTEM user can do anything. So i guess it must be something inside the file. -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.