I also got same exception, below are my qyuery and exception;
org.hibernate.exception.GenericJDBCException: General error:
"java.lang.NullPointerException"; SQL statement:
select eqlvvolsta0_.ID as ID15_0_, eqlvvolsta0_.GROUPID as GROUPID15_0_,
eqlvvolsta0_1_.VERSION as VERSION15_0_, eqlvvolsta0_1_.NAME as NAME15_0_,
eqlvvolsta0_1_.INSTANCE as INSTANCE15_0_, eqlvvolsta0_1_.PARENTID as
PARENTID15_0_, eqlvvolsta0_1_.RETRIEVALTIMESTAMP as RETRIEVA7_15_0_,
eqlvvolsta0_.SIZE as SIZE98_0_, eqlvvolsta0_.INUSESPACE as INUSESPACE98_0_,
eqlvvolsta0_.FREESPACE as FREESPACE98_0_, eqlvvolsta0_.SHAREDSPACE as
SHAREDSP6_98_0_, eqlvvolsta0_.UNSHAREDSPACE as UNSHARED7_98_0_,
eqlvvolsta0_.OPERSTATUS as OPERSTATUS98_0_ from EQLVVOLSTATUSELEM
eqlvvolsta0_ inner join EQLDATAELEMENT eqlvvolsta0_1_ on
eqlvvolsta0_.ID=eqlvvolsta0_1_.ID and
eqlvvolsta0_.GROUPID=eqlvvolsta0_1_.GROUPID where eqlvvolsta0_.ID=? and
eqlvvolsta0_.GROUPID=? [50000-190]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:52)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy157.executeQuery(Unknown Source)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1978)
at org.hibernate.loader.Loader.doQuery(Loader.java:829)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2058)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:82)
at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:72)
at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3697)
at
org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:439)
at
org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:420)
at
org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:204)
at
org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:243)
at
org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:148)
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:954)
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:870)
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:863)
at
com.equallogic.sims.server.core.cache.CacheManagerImpl.get(CacheManagerImpl.java:784)
at sun.reflect.GeneratedMethodAccessor532.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
at
org.jboss.as.weld.ejb.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.java:81)
at
com.equallogic.sims.server.core.LoggingInterceptor.manageTransaction(LoggingInterceptor.java:30)
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.jboss.interceptor.proxy.InterceptorInvocation$InterceptorMethodInvocation.invoke(InterceptorInvocation.java:72)
at
org.jboss.interceptor.proxy.SimpleInterceptionChain.invokeNextInterceptor(SimpleInterceptionChain.java:82)
at
org.jboss.weld.bean.InterceptorImpl.intercept(InterceptorImpl.java:90)
at
org.jboss.as.weld.ejb.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.java:71)
at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:112)
at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125)
at
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135)
at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
at
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
at
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
Caused by: org.h2.jdbc.JdbcSQLException: General error:
"java.lang.NullPointerException"; SQL statement:
select eqlvvolsta0_.ID as ID15_0_, eqlvvolsta0_.GROUPID as GROUPID15_0_,
eqlvvolsta0_1_.VERSION as VERSION15_0_, eqlvvolsta0_1_.NAME as NAME15_0_,
eqlvvolsta0_1_.INSTANCE as INSTANCE15_0_, eqlvvolsta0_1_.PARENTID as
PARENTID15_0_, eqlvvolsta0_1_.RETRIEVALTIMESTAMP as RETRIEVA7_15_0_,
eqlvvolsta0_.SIZE as SIZE98_0_, eqlvvolsta0_.INUSESPACE as INUSESPACE98_0_,
eqlvvolsta0_.FREESPACE as FREESPACE98_0_, eqlvvolsta0_.SHAREDSPACE as
SHAREDSP6_98_0_, eqlvvolsta0_.UNSHAREDSPACE as UNSHARED7_98_0_,
eqlvvolsta0_.OPERSTATUS as OPERSTATUS98_0_ from EQLVVOLSTATUSELEM
eqlvvolsta0_ inner join EQLDATAELEMENT eqlvvolsta0_1_ on
eqlvvolsta0_.ID=eqlvvolsta0_1_.ID and
eqlvvolsta0_.GROUPID=eqlvvolsta0_1_.GROUPID where eqlvvolsta0_.ID=? and
eqlvvolsta0_.GROUPID=? [50000-190]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.command.Command.executeQuery(Command.java:208)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:108)
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
... 155 more
Caused by: java.lang.NullPointerException
On Sunday, November 15, 2015 at 12:22:28 AM UTC+5:30, Karteek Pradyumna
Bulusu wrote:
>
> 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://www.google.com/url?q=http%3A%2F%2Fh2database.com%2Fhtml%2Fsource.html%3Ffile%3Dorg%2Fh2%2Fmessage%2FDbException.java%26line%3D345%26build%3D181&sa=D&sntz=1&usg=AFQjCNHrJMPK-mLsnS6vyHJeFSwgTXdedw>)
>
>
> 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.
