java.sql.SQLException: File input/output error: saveSorted java.lang.ClassCastException: java.lang.Float in statement \[ALTER TABLE \_DSMS\_2ENCOURS DROP COLUMN ColumnName ;\]

hsqldb | nobody | 1 decade ago
  1. 0

    ClassCast exception

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: File input/output error: saveSorted java.lang.ClassCastException: java.lang.Float in statement \[ALTER TABLE \_DSMS\_2ENCOURS DROP COLUMN ColumnName ;\]
  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

    db:: 4.35::Enterprise Java Bean client connection to server m3

    hivmr.com | 8 months ago
    java.sql.SQLException: Connection is broken
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    BINARY in statement exception

    Oracle Community | 1 decade ago | 843829
    org.jboss.deployment.DeploymentException: Error while creating table MLMEMBER; - nested throwable: (java.sql.SQLException: Unexpected token: BINARY in statement [CREATE TABLE MLMEMBER (email VARCHAR(250) BINARY NOT NULL, name VARCHAR(250) BINARY, CONSTRAINT PK_MLMEMBER PRIMARY KEY (email))])
  6. 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]

    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

      File input/output error: saveSorted java.lang.ClassCastException: java.lang.Float in statement \[ALTER TABLE \_DSMS\_2ENCOURS DROP COLUMN ColumnName ;\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcStatement.executeUpdate
      1. org.hsqldb.Trace.getError(Trace.java:263)
      2. org.hsqldb.jdbcResultSet.<init>(jdbcResultSet.java:6598)
      3. org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:2905)
      4. org.hsqldb.jdbcConnection.execute(jdbcConnection.java:2483)
      5. org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1748)
      6. org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:227)
      6 frames