Have you tried deleting the Index file? H2 will rebuild it when you
reopen the database.
The new version uses the pagestore and it seems to be a more robust
format. I haven't had any issues with it.
On 31/08/2010 3:38 PM, raj wrote:
Hi Ryan,
I got this exception while using ver 119 and was wondering if someone
could help with version 119 only or could tell if this defect is
solved in 1.2.140.
Thanks
Raj
On Aug 30, 1:17 pm, Ryan How<[email protected]> wrote:
Hi,
Is it a different client and server version?
The error indicated version 1.1.119, not 1.2.140 ?
I think somewhere along the line there was an issue where with different
client and server versions. It outputs an error that doesn't make sense
like what you are getting. So I think the cause is an incompatible
client and server version.
Hope this helps.
Ryan
On 30/08/2010 3:53 PM, raj wrote:
Hi,
I am getting this exception
org.h2.jdbc.JdbcSQLException: General error:
java.lang.RuntimeException: File ID mismatch got=0 expected=18
pos=1420361 false org.h2.store.DiskFile:/u/users/framewrk/mfwscc/flow/
tomcat/apache-tomcat-6.0.20/mfui/db/mfui_h2_db.index.db blockCount:0;
SQL statement:
SELECT USER_ID FROM MFUI_USERS WHERE USER_ID =? [50000-119]
at org.h2.message.Message.getSQLException(Message.java:106)
at org.h2.message.Message.convert(Message.java:283)
at org.h2.message.Message.convert(Message.java:244)
at org.h2.command.Command.executeQueryLocal(Command.java:144)
at org.h2.command.Command.executeQuery(Command.java:123)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:
98)
at
--
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.
