ca.edbc.util.EdbcEx: line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type.

Apereo Issues | Robert Sherratt | 1 decade ago
  1. 0

    Select a column and try to change the column width - get an error message "Problem changing column widths". I am using an updated RDBMUserLayoutStore so the line numbers may not be quite the same. We use Ingres as our RDBMS. Stack trace: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: ca.edbc.util.E dbcEx: line 1, You cannot assign a value of type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. ca.edbc.util.EdbcEx: line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type. at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:782) at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:573) at ca.edbc.jdbc.EdbcStmt.exec(EdbcStmt.java:907) at ca.edbc.jdbc.EdbcStmt.executeUpdate(EdbcStmt.java:357) at com.codestudio.sql.PoolManStatement.executeUpdate(PoolManStatement.ja va:218) at org.jasig.portal.RDBMUserLayoutStore.setStructureStylesheetUserPrefer ences(RDBMUserLayoutStore.java:2255) at org.jasig.portal.RDBMUserLayoutStore.putUserPreferences(RDBMUserLayou tStore.java:2923) at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:324) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState(UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection (HttpRequest.java:158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484) followed by a second error: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: org.jasig.port al.GeneralRenderingException: line 1, You cannot assign a value of type 'varcha r' to a column of type 'integer'. Explicitly convert the value to the required t ype. org.jasig.portal.GeneralRenderingException: line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:336) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState (UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java: 158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484)

    Apereo Issues | 1 decade ago | Robert Sherratt
    ca.edbc.util.EdbcEx: line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type.
  2. 0

    Select a column and try to change the column width - get an error message "Problem changing column widths". I am using an updated RDBMUserLayoutStore so the line numbers may not be quite the same. We use Ingres as our RDBMS. Stack trace: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: ca.edbc.util.E dbcEx: line 1, You cannot assign a value of type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. ca.edbc.util.EdbcEx: line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type. at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:782) at ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:573) at ca.edbc.jdbc.EdbcStmt.exec(EdbcStmt.java:907) at ca.edbc.jdbc.EdbcStmt.executeUpdate(EdbcStmt.java:357) at com.codestudio.sql.PoolManStatement.executeUpdate(PoolManStatement.ja va:218) at org.jasig.portal.RDBMUserLayoutStore.setStructureStylesheetUserPrefer ences(RDBMUserLayoutStore.java:2255) at org.jasig.portal.RDBMUserLayoutStore.putUserPreferences(RDBMUserLayou tStore.java:2923) at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:324) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState(UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection (HttpRequest.java:158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484) followed by a second error: ERROR [tcpConnection-8080-0] root.[] Mar/20 15:36:12 - EXCEPTION: org.jasig.port al.GeneralRenderingException: line 1, You cannot assign a value of type 'varcha r' to a column of type 'integer'. Explicitly convert the value to the required t ype. org.jasig.portal.GeneralRenderingException: line 1, You cannot assign a value o f type 'varchar' to a column of type 'integer'. Explicitly convert the value to the required type. at org.jasig.portal.UserLayoutManager.setNewUserLayoutAndUserPreferences (UserLayoutManager.java:336) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.saveUse rPreferences(TabColumnPrefsState.java:641) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.changeC olumnWidths(TabColumnPrefsState.java:361) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.access$ 1100(TabColumnPrefsState.java:91) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState$Default State.setRuntimeData(TabColumnPrefsState.java:839) at org.jasig.portal.channels.UserPreferences.TabColumnPrefsState.setRunt imeData(TabColumnPrefsState.java:174) at org.jasig.portal.channels.UserPreferences.CUserPreferences.setRuntime Data(CUserPreferences.java:223) at org.jasig.portal.ChannelManager.processRequestChannelParameters(Chann elManager.java:639) at org.jasig.portal.ChannelManager.setReqNRes(ChannelManager.java:718) at org.jasig.portal.UserInstance.renderState (UserInstance.java:261) at org.jasig.portal.UserInstance.writeContent(UserInstance.java:186) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java :236) at org.jasig.portal.PortalSessionManager.doPost(PortalSessionManager.jav a:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet .java:82) at com.caucho.server.http.Invocation.service(Invocation.java:277) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216 ) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java: 158) at com.caucho.server.TcpConnection.run(TcpConnection.java:140) at java.lang.Thread.run(Thread.java:484)

    Apereo Issues | 1 decade ago | Robert Sherratt
    ca.edbc.util.EdbcEx: line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type.
  3. 0

    Protocol Exception using Hibernate on Ingres

    Oracle Community | 1 decade ago | 843859
    ca.edbc.util.EdbcEx: Connection aborted due to a communications protocol error.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Protocol Exception using Hibernate on Ingres

    Oracle Community | 1 decade ago | 843859
    ca.edbc.util.EdbcEx: Connection aborted due to a communications protocol error.
  6. 0

    JDBC: Connection aborted due to a communications protocol error. - comp.databases.ingres

    compgroups.net | 1 year ago
    ca.edbc.util.EdbcEx: Connection aborted due to a communications protocol error.

    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. ca.edbc.util.EdbcEx

      line 1, You cannot assign a value of type 'varchar' to a c olumn of type 'integer'. Explicitly convert the value to the required type.

      at ca.edbc.jdbc.EdbcObj.readResults()
    2. ca.edbc.jdbc
      EdbcStmt.executeUpdate
      1. ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:782)
      2. ca.edbc.jdbc.EdbcObj.readResults(EdbcObj.java:573)
      3. ca.edbc.jdbc.EdbcStmt.exec(EdbcStmt.java:907)
      4. ca.edbc.jdbc.EdbcStmt.executeUpdate(EdbcStmt.java:357)
      4 frames