Hi Thomas, I upgraded to today's new release and I get the following error messages:
Failed to execute runnable (java.lang.IllegalArgumentException: Can not set java.lang.Integer field orderid to java.lang.Long) The orderid column in the database is of type INT. With the older version of H2 database, the engine would return type INT in the java result set. Now it appears today's release is returning type BIGINT instead, and the value it is trying to return is 99. When I swap the old jar back into my workspace this error message goes away. With today's release I have not yet attempted to try to see if the HY000-65 error message reoccurs. I am more concerned with the new error message I have seen. On Dec 16, 1:49 pm, "Thomas Mueller" <[email protected]> wrote: > Hi, > > You are using version 1.0.65 from 2008-01-18. (The -65 in the > exception code HY000-65 is the version). Could you try again using a > newer version please? > > Regards, > Thomas > > On Sun, Dec 14, 2008 at 8:28 PM, Harpal Grover <[email protected]> > wrote: > > > Hello all, > > > I am executing a rather simple SQL Query and running into a General > > error: java.lang.NullPointerException [HY000-65]. > > > STACKTRACE > > ================================ > > > java.lang.NullPointerException > > at org.h2.table.TableFilter.getValue(TableFilter.java:553) > > at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java: > > 163) > > at org.h2.expression.Alias.getValue(Alias.java:33) > > at org.h2.command.dml.Select.queryGroup(Select.java:181) > > at org.h2.command.dml.Select.queryWithoutCache(Select.java:382) > > at org.h2.command.dml.Query.query(Query.java:226) > > at org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java: > > 113) > > at org.h2.command.dml.SelectUnion.query(SelectUnion.java:323) > > at org.h2.command.dml.Insert.update(Insert.java:95) > > at org.h2.command.ddl.CreateTable.update(CreateTable.java:169) > > at org.h2.command.CommandContainer.update(CommandContainer.java:68) > > at org.h2.command.Command.executeUpdate(Command.java:171) > > at org.h2.jdbc.JdbcPreparedStatement.execute > > (JdbcPreparedStatement.java:161) > > > SQL QUERY > > ===================================== > > CREATE TABLE TEST AS > > SELECT * FROM ORDERS O, ORDERS_INFO OI WHERE O.ID = OI.ORDERID AND > > OI.DATE BETWEEN '20081201' AND '20081209' > > > The result should be no rows returned because there are no orders. > > However I get the exception above instead. When I change the date > > values to fall in a wider range, then I am able to successfully > > retrieve records because the orders fall into the specified date > > range. > > > I altered the query as follows: > > > CREATE TABLE TEST AS > > SELECT * FROM ORDERS O, ORDERS_INFO OI WHERE O.ID = OI.ORDERID AND > > OI.DATE > '20081201' AND OI.DATE < '20081209'; > > > And ran it again and got the same exception. Is this a bug or is there > > a flaw in my logic? > > > Thanks > > > Harpal --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
