does any one know why this is not getting parsed? thanks in advance On Feb 13, 11:40 pm, petko <[email protected]> wrote: > Data conversion error converting "+10"; SQL statement: > SELECT CAST("timeZoneString" as INT) FROM COUNTRY1 [90021-147] > 90021/90021 (Help) > org.h2.jdbc.JdbcSQLException: Data conversion error converting "+10"; > SQL statement: > SELECT CAST("timeZoneString" as INT) FROM COUNTRY1 [90021-147] > at org.h2.message.DbException.getJdbcSQLException(DbException.java: > 327) > at org.h2.message.DbException.get(DbException.java:156) > at org.h2.value.Value.convertTo(Value.java:837) > at org.h2.expression.Function.getSimpleValue(Function.java:703) > at org.h2.expression.Function.getValueWithArgs(Function.java:852) > at org.h2.expression.Function.getValue(Function.java:416) > at org.h2.command.dml.Select.queryFlat(Select.java:504) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:597) > at org.h2.command.dml.Query.query(Query.java:257) > at org.h2.command.dml.Query.query(Query.java:227) > at org.h2.command.CommandContainer.query(CommandContainer.java:78) > at org.h2.command.Command.executeQuery(Command.java:132) > at org.h2.server.TcpServerThread.process(TcpServerThread.java:278) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:137) > at java.lang.Thread.run(Thread.java:662) > Caused by: java.lang.NumberFormatException: For input string: "+10" > at > java.lang.NumberFormatException.forInputString(NumberFormatException.java: > 48) > at java.lang.Integer.parseInt(Integer.java:449) > at java.lang.Integer.parseInt(Integer.java:499) > at org.h2.value.Value.convertTo(Value.java:794) > ... 12 more > > at org.h2.engine.SessionRemote.done(SessionRemote.java:543) > at org.h2.command.CommandRemote.executeQuery(CommandRemote.java: > 152) > at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java: > 174) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:153) > at org.h2.server.web.WebApp.getResult(WebApp.java:1316) > at org.h2.server.web.WebApp.query(WebApp.java:1004) > at org.h2.server.web.WebApp$1.next(WebApp.java:967) > at org.h2.server.web.WebApp$1.next(WebApp.java:970) > at org.h2.server.web.WebThread.process(WebThread.java:166) > at org.h2.server.web.WebThread.run(WebThread.java:93) > at java.lang.Thread.run(Thread.java:662)
-- 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.
