java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement \[SHUTDOWN SCRIPT\]

hsqldb | jakorsme | 1 decade ago
  1. 0

    Problems executing SHUTDOWN SCRIPT

    hsqldb | 1 decade ago | jakorsme
    java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement \[SHUTDOWN SCRIPT\]
  2. 0

    It seems that there is a small but major bug in the code generation of SchemaUpdate. It doesn't add a space after 'add column'. Here is my stacktrace: alter table addresses add columnversion INTEGER 12:24:51,038 ERROR SchemaUpdate:121 - Error while executing alter table addresses add columnversion INTEGER java.sql.SQLException: Unexpected token: COLUMNVERSION in statement [alter table addresses add columnversion INTEGER] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:116) at com.intrasoft.persistence.hibernate.HibernatePersistenceManager.buildSessionFactory(HibernatePersistenceManager.java:59) at com.intrasoft.persistence.hibernate.HibernatePersistenceManager.init(HibernatePersistenceManager.java:38) at com.opensymphony.xwork.interceptor.component.DefaultComponentManager.loadResource(DefaultComponentManager.java:152) at com.opensymphony.xwork.interceptor.component.DefaultComponentManager.loadResource(DefaultComponentManager.java:137) at com.opensymphony.xwork.interceptor.component.DefaultComponentManager.initializeComponent(DefaultComponentManager.java:73) at com.opensymphony.xwork.interceptor.component.ComponentInterceptor.before(ComponentInterceptor.java:29) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:36) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.TimerInterceptor.intercept(TimerInterceptor.java:66) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:108) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:164) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.intrasoft.security.LoginFilter.doFilter(LoginFilter.java:76) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.intrasoft.security.SecurityFilter.doFilter(SecurityFilter.java:34) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534)

    Hibernate JIRA | 1 decade ago | Mathias Bogaert
    java.sql.SQLException: Unexpected token: COLUMNVERSION in statement [alter table addresses add columnversion INTEGER]
  3. 0

    It seems that there is a small but major bug in the code generation of SchemaUpdate. It doesn't add a space after 'add column'. Here is my stacktrace: alter table addresses add columnversion INTEGER 12:24:51,038 ERROR SchemaUpdate:121 - Error while executing alter table addresses add columnversion INTEGER java.sql.SQLException: Unexpected token: COLUMNVERSION in statement [alter table addresses add columnversion INTEGER] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:116) at com.intrasoft.persistence.hibernate.HibernatePersistenceManager.buildSessionFactory(HibernatePersistenceManager.java:59) at com.intrasoft.persistence.hibernate.HibernatePersistenceManager.init(HibernatePersistenceManager.java:38) at com.opensymphony.xwork.interceptor.component.DefaultComponentManager.loadResource(DefaultComponentManager.java:152) at com.opensymphony.xwork.interceptor.component.DefaultComponentManager.loadResource(DefaultComponentManager.java:137) at com.opensymphony.xwork.interceptor.component.DefaultComponentManager.initializeComponent(DefaultComponentManager.java:73) at com.opensymphony.xwork.interceptor.component.ComponentInterceptor.before(ComponentInterceptor.java:29) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:36) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.interceptor.TimerInterceptor.intercept(TimerInterceptor.java:66) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:108) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:164) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.intrasoft.security.LoginFilter.doFilter(LoginFilter.java:76) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.intrasoft.security.SecurityFilter.doFilter(SecurityFilter.java:34) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:61) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534)

    Hibernate JIRA | 1 decade ago | Mathias Bogaert
    java.sql.SQLException: Unexpected token: COLUMNVERSION in statement [alter table addresses add columnversion INTEGER]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OutOfMemoryError in executeUpdate

    hsqldb | 1 decade ago | matthiasrose
    java.sql.SQLException: out of memory
  6. 0

    Creating a trigger?

    hsqldb | 1 decade ago | aslane
    java.sql.SQLException: Table not found: TABLE in statement \[create trigger test after insert on table fasteKonti call OpdaterKontoplan.class\]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      S1000 General error java.lang.NullPointerException in statement \[SHUTDOWN SCRIPT\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcStatement.executeUpdate
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.jdbcResultSet.<init>(Unknown Source)
      3. org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      4. org.hsqldb.jdbcConnection.execute(Unknown Source)
      5. org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      6. org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
      6 frames
    3. com.jak.EMP
      HsqlDbUpgrade.main
      1. com.jak.EMP.HsqlDbUpgrade.shutdownScript(HsqlDbUpgrade.java:28)
      2. com.jak.EMP.HsqlDbUpgrade.<init>(HsqlDbUpgrade.java:20)
      3. com.jak.EMP.HsqlDbUpgrade.main(HsqlDbUpgrade.java:51)
      3 frames