search

sagarswathi / h2database

Automatically exported from code.google.com/p/h2database
0 stars 1 forks source link

java.lang.ArrayIndexOutOfBoundsException: 0 #382

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
java.sql.SQLException: org.h2.jdbc.JdbcSQLException: General error: 
"java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT * FROM STOCK WHERE 1=1  and STOCKFLAG='JINHUO' ORDER BY DATETIMED DESC 
LIMIT 20 OFFSET 0 [50000-164]
    at com.fafasoft.flow.dao.impl.BaseDAO.execute(BaseDAO.java:91)
    at com.fafasoft.flow.dao.impl.BaseDAO.queryForList(BaseDAO.java:250)
    at com.fafasoft.flow.dao.impl.StockDAOImpl.getStockByParm(StockDAOImpl.java:968)
    at com.fafasoft.flow.ui.panel.StockQueryPanel$1.mouseClicked(StockQueryPanel.java:159)
    at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
    at java.awt.Component.processMouseEvent(Component.java:6266)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
    at java.awt.Component.processEvent(Component.java:6028)
    at java.awt.Container.processEvent(Container.java:2041)
    at java.awt.Component.dispatchEventImpl(Component.java:4630)
    at java.awt.Container.dispatchEventImpl(Container.java:2099)
    at java.awt.Component.dispatchEvent(Component.java:4460)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
    at java.awt.Container.dispatchEventImpl(Container.java:2085)
    at java.awt.Window.dispatchEventImpl(Window.java:2478)
    at java.awt.Component.dispatchEvent(Component.java:4460)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
    at com.fafasoft.flow.ui.widget.TCPopupEventQueue.dispatchEvent(TCPopupEventQueue.java:49)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: org.h2.jdbc.JdbcSQLException: General error: 
"java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT * FROM STOCK WHERE 1=1  and STOCKFLAG='JINHUO' ORDER BY DATETIMED DESC 
LIMIT 20 OFFSET 0 [50000-164]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:158)
    at org.h2.message.DbException.convert(DbException.java:281)
    at org.h2.command.Command.executeQuery(Command.java:191)
    at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
    at com.fafasoft.flow.dao.impl.BaseDAO$3QqueryStatementCallback.doInStatement(BaseDAO.java:242)
    at com.fafasoft.flow.dao.impl.BaseDAO$3QqueryStatementCallback.doInStatement(BaseDAO.java:1)
    at com.fafasoft.flow.dao.impl.BaseDAO.execute(BaseDAO.java:84)
    ... 25 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
    at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:327)
    at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97)
    at org.h2.index.PageDataCursor.next(PageDataCursor.java:49)
    at org.h2.index.IndexCursor.next(IndexCursor.java:238)
    at org.h2.table.TableFilter.next(TableFilter.java:353)
    at org.h2.command.dml.Select.queryFlat(Select.java:513)
    at org.h2.command.dml.Select.queryWithoutCache(Select.java:618)
    at org.h2.command.dml.Query.query(Query.java:297)
    at org.h2.command.dml.Query.query(Query.java:267)
    at org.h2.command.dml.Query.query(Query.java:36)
    at org.h2.command.CommandContainer.query(CommandContainer.java:82)
    at org.h2.command.Command.executeQuery(Command.java:187)
    ... 29 more

Original issue reported on code.google.com by lyc...@gmail.com on 29 Feb 2012 at 1:39

GoogleCodeExporter commented 8 years ago 
I use  Version h2-1.2.124

Original comment by lyc...@gmail.com on 1 Mar 2012 at 1:13

GoogleCodeExporter commented 8 years ago 
Hi,

I'm sorry about this. I believe this is already fixed in a newer version, as 
there were such problems in older version (see the change log). Even if it is 
not fixed: without having a reproducible test case I'm afraid there is not much 
I can do about it. It's still good that you report this problem of course! I 
suggest to use the Recover tool to get the data and create a new database.

Original comment by thomas.t...@gmail.com on 18 Mar 2012 at 5:39