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 [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.
