Hi, I'm new to H2 db. I'm getting following exception when I try to run java application using hibernate.
h2 version - 1.4.197 jdk - 8 Please help me. Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT MAX(SCOREBOARD0_.SCORE_BOARD) AS COL_0_0_ FROM SCORE_BOARD SCOREBOARD0_ WHERE SCOREBOARD0_.SCORE_ID IN () [*]"; SQL statement: select max(scoreboard0_.score_board) as col_0_0_ from score_board scoreboard0_ where scoreboard0_.score_id in () [42000-197] at org.h2.message.DbException.getJdbcSQLException(DbException.java:357) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.message.DbException.getSyntaxError(DbException.java:203) at org.h2.command.Parser.getSyntaxError(Parser.java:548) at org.h2.command.Parser.readCondition(Parser.java:2436) at org.h2.command.Parser.readAnd(Parser.java:2342) at org.h2.command.Parser.readExpression(Parser.java:2334) at org.h2.command.Parser.parseSelectSimple(Parser.java:2291) at org.h2.command.Parser.parseSelectSub(Parser.java:2133) at org.h2.command.Parser.parseSelectUnion(Parser.java:1946) at org.h2.command.Parser.parseSelect(Parser.java:1919) at org.h2.command.Parser.parsePrepared(Parser.java:463) at org.h2.command.Parser.parse(Parser.java:335) at org.h2.command.Parser.parse(Parser.java:311) at org.h2.command.Parser.prepareCommand(Parser.java:278) at org.h2.engine.Session.prepareLocal(Session.java:611) at org.h2.engine.Session.prepareCommand(Session.java:549) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:304) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ... 37 more *Note - It was working fine in 1.4.188 h2 version.* -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1bb1b084-0cb3-4bbc-975b-0ea3905eeff0%40googlegroups.com.
