java.sql.SQLException: Unexpected token: COLUMNVERSION in statement [alter table addresses add columnversion INTEGER]

Hibernate JIRA | Mathias Bogaert | 1 decade ago
  1. 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]
  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

    Problems executing SHUTDOWN SCRIPT

    hsqldb | 1 decade ago | jakorsme
    java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement \[SHUTDOWN SCRIPT\]
  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

      Unexpected token: COLUMNVERSION in statement [alter table addresses add columnversion INTEGER]

      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. net.sf.hibernate
      SchemaUpdate.execute
      1. net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:116)
      1 frame
    4. com.intrasoft.persistence
      HibernatePersistenceManager.init
      1. com.intrasoft.persistence.hibernate.HibernatePersistenceManager.buildSessionFactory(HibernatePersistenceManager.java:59)
      2. com.intrasoft.persistence.hibernate.HibernatePersistenceManager.init(HibernatePersistenceManager.java:38)
      2 frames
    5. com.opensymphony.xwork
      AbstractInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.component.DefaultComponentManager.loadResource(DefaultComponentManager.java:152)
      2. com.opensymphony.xwork.interceptor.component.DefaultComponentManager.loadResource(DefaultComponentManager.java:137)
      3. com.opensymphony.xwork.interceptor.component.DefaultComponentManager.initializeComponent(DefaultComponentManager.java:73)
      4. com.opensymphony.xwork.interceptor.component.ComponentInterceptor.before(ComponentInterceptor.java:29)
      5. com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:36)
      5 frames
    6. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148)
      1 frame
    7. com.opensymphony.xwork
      AbstractInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37)
      1 frame
    8. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148)
      1 frame
    9. com.opensymphony.xwork
      AbstractInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37)
      1 frame
    10. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148)
      1 frame
    11. com.opensymphony.xwork
      AbstractInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37)
      1 frame
    12. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148)
      1 frame
    13. com.opensymphony.xwork
      AbstractInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AbstractInterceptor.intercept(AbstractInterceptor.java:37)
      1 frame
    14. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148)
      1 frame
    15. com.opensymphony.xwork
      TimerInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.TimerInterceptor.intercept(TimerInterceptor.java:66)
      1 frame
    16. XWork Tiger Extensions
      DefaultActionProxy.execute
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:148)
      2. com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:108)
      2 frames
    17. WebWork
      ServletDispatcher.service
      1. com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:164)
      1 frame
    18. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:1264)
      1 frame
    19. com.caucho.server
      FilterChainServlet.doFilter
      1. com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
      1 frame
    20. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129)
      2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
      2 frames
    21. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    22. com.intrasoft.security
      LoginFilter.doFilter
      1. com.intrasoft.security.LoginFilter.doFilter(LoginFilter.java:76)
      1 frame
    23. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    24. com.intrasoft.security
      SecurityFilter.doFilter
      1. com.intrasoft.security.SecurityFilter.doFilter(SecurityFilter.java:34)
      1 frame
    25. com.caucho.server
      FilterChainFilter.doFilter
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      1 frame
    26. WebWork
      RequestLifecycleFilter.doFilter
      1. com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:61)
      1 frame
    27. com.caucho.server
      TcpConnection.run
      1. com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
      2. com.caucho.server.http.Invocation.service(Invocation.java:315)
      3. com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
      4. com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
      5. com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
      6. com.caucho.server.TcpConnection.run(TcpConnection.java:139)
      6 frames
    28. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame