Hi,
Something is corrupted in database and I do not know how to search for
a reason. Seems like H2 bug.
This is three times confirmed by three different users of my
application.
I have KATEGORIA table in the db and SELECT * from KATEGORIA works,
but
SELECT 'eportfel.db.Kategoria' AS
NUCLEUS_TYPE,THIS.ID,THIS.KATEGORIA_NADRZEDNA_ID_OID,THIS.NAZWA AS
NUCORDER0,THIS.TYP FROM KATEGORIA THIS WHERE 0 = THIS.USER_ID_OID AND
THIS.TYP = 'W' ORDER BY NUCORDER0
throws
General error: java.lang.ArrayIndexOutOfBoundsException: i=0 size=0
at org.h2.message.Message.getSQLException(Message.java:107)
at org.h2.message.Message.convert(Message.java:278)
at org.h2.message.Message.convert(Message.java:247)
at org.h2.command.Command.executeQueryLocal(Command.java:143)
at org.h2.command.Command.executeQuery(Command.java:122)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery
(JdbcPreparedStatement.java:96)
even when this query seems to be ok.
The corrupted database files are accessible here:
http://www.chcezyc.eu/files/dberror.zip
There you have database files and the problematic query text.
The db was created by H2 version 1.1.108 and this version was used to
work on the data.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
