I was implementing full outer join and am stuck with null pointer exception, Did anyone face something similar before and have an idea to rectify it.
this is what I am getting: select * from one full outer join test where one.name = test.name; General error: "java.lang.NullPointerException" [50000-181] <http://192.168.2.14:8084/query.do?jsessionid=ab8802ad76573c3b0f1ba38181abbbe2#> HY000/50000 (Help) <http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c50000> org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-181] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=345&build=181>) at org.h2.message.DbException.get(DbException.java:168 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=168&build=181>) at org.h2.message.DbException.convert(DbException.java:295 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=295&build=181>) at org.h2.message.DbException.toSQLException(DbException.java:268 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=268&build=181>) at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352 <http://h2database.com/html/source.html?file=org/h2/message/TraceObject.java&line=352&build=181>) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:160 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=160&build=181>) at org.h2.server.web.WebApp.getResult(WebApp.java:1390 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1390&build=181>) at org.h2.server.web.WebApp.query(WebApp.java:1063 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1063&build=181>) at org.h2.server.web.WebApp$1.next(WebApp.java:1025 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1025&build=181>) at org.h2.server.web.WebApp$1.next(WebApp.java:1 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1&build=181>) at org.h2.server.web.WebThread.process(WebThread.java:167 <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=167&build=181>) at org.h2.server.web.WebThread.run(WebThread.java:93 <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=93&build=181>) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NullPointerException at org.h2.command.Parser.parseSelectSub(Parser.java:1951 <http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1951&build=181>) at org.h2.command.Parser.parseSelectUnion(Parser.java:1715 <http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1715&build=181>) at org.h2.command.Parser.parseSelect(Parser.java:1703 <http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1703&build=181>) at org.h2.command.Parser.parsePrepared(Parser.java:435 <http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=435&build=181>) at org.h2.command.Parser.parse(Parser.java:307 <http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=307&build=181>) at org.h2.command.Parser.parse(Parser.java:279 <http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=279&build=181>) at org.h2.command.Parser.prepareCommand(Parser.java:244 <http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=244&build=181>) at org.h2.engine.Session.prepareLocal(Session.java:446 <http://h2database.com/html/source.html?file=org/h2/engine/Session.java&line=446&build=181>) at org.h2.engine.Session.prepareCommand(Session.java:388 <http://h2database.com/html/source.html?file=org/h2/engine/Session.java&line=388&build=181>) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1190 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=1190&build=181>) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:170 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=170&build=181>) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=158&build=181>) ... 7 more Thank you. Looking forward for a positive response. Karteek Bulusu,:) -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
