java.sql.SQLException: String or binary data would be truncated.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Exception经验记录
    via by Unknown author,
  • The query language substitution does not recognize the token || (pipe pipe - string concatenation in Oracle). The log shows: ... 19/10/2004 10:20:23 net.sf.hibernate.cfg.SettingsFactory buildSettings INFO: Query language substitutions: {||=+} 19/10/2004 10:20:23 net.sf.hibernate.cfg.SettingsFactory buildSettings ... but the query goes to the database with the || example: HQL query: from previne.dominio.AeronaveImpl a where a.identificacao like 'W'||'%' generated SQL query: Hibernate: select aeronaveim0_.id as id, aeronaveim0_.ANO_REGISTRO as ANO_REGI3_, aeronaveim0_.DATA_HORA_GRAVACAO as DATA_HOR4_, aeronaveim0_.CHAVE_EXTERNA as CHAVE_EX5_, aeronaveim0_.SITUACAO as SITUACAO, aeronaveim0_.DATA_HORA_VALIDACAO as DATA_HOR7_, aeronaveim0_.IDENTIFICACAO as IDENTIFI8_, aeronaveim0_.NUMERO_VOO as NUMERO_VOO, aeronaveim0_.USUARIO_FK as USUARIO_FK, aeronaveim0_.VEICULO_CARGA_FK as VEICULO11_, aeronaveim0_.FONTE_DADOS_FK as FONTE_D12_ from AERONAVE aeronaveim0_ where aeronaveim0_.class='AeronaveImpl' and ((aeronaveim0_.IDENTIFICACAO like 'W'||'%' )) log error: WARNING: SQL Error: 170, SQLState: 37000 19/10/2004 11:04:38 net.sf.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Line 1: Incorrect syntax near '|'. 19/10/2004 11:04:38 net.sf.hibernate.util.JDBCExceptionReporter logExceptions WARNING: SQL Error: 170, SQLState: 37000 19/10/2004 11:04:38 net.sf.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Line 1: Incorrect syntax near '|'. 19/10/2004 11:04:38 net.sf.hibernate.JDBCException <init> SEVERE: Could not execute query java.sql.SQLException: Line 1: Incorrect syntax near '|'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2217) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:1696)
    via by Walter Mourão,
  • The query language substitution does not recognize the token || (pipe pipe - string concatenation in Oracle). The log shows: ... 19/10/2004 10:20:23 net.sf.hibernate.cfg.SettingsFactory buildSettings INFO: Query language substitutions: {||=+} 19/10/2004 10:20:23 net.sf.hibernate.cfg.SettingsFactory buildSettings ... but the query goes to the database with the || example: HQL query: from previne.dominio.AeronaveImpl a where a.identificacao like 'W'||'%' generated SQL query: Hibernate: select aeronaveim0_.id as id, aeronaveim0_.ANO_REGISTRO as ANO_REGI3_, aeronaveim0_.DATA_HORA_GRAVACAO as DATA_HOR4_, aeronaveim0_.CHAVE_EXTERNA as CHAVE_EX5_, aeronaveim0_.SITUACAO as SITUACAO, aeronaveim0_.DATA_HORA_VALIDACAO as DATA_HOR7_, aeronaveim0_.IDENTIFICACAO as IDENTIFI8_, aeronaveim0_.NUMERO_VOO as NUMERO_VOO, aeronaveim0_.USUARIO_FK as USUARIO_FK, aeronaveim0_.VEICULO_CARGA_FK as VEICULO11_, aeronaveim0_.FONTE_DADOS_FK as FONTE_D12_ from AERONAVE aeronaveim0_ where aeronaveim0_.class='AeronaveImpl' and ((aeronaveim0_.IDENTIFICACAO like 'W'||'%' )) log error: WARNING: SQL Error: 170, SQLState: 37000 19/10/2004 11:04:38 net.sf.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Line 1: Incorrect syntax near '|'. 19/10/2004 11:04:38 net.sf.hibernate.util.JDBCExceptionReporter logExceptions WARNING: SQL Error: 170, SQLState: 37000 19/10/2004 11:04:38 net.sf.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Line 1: Incorrect syntax near '|'. 19/10/2004 11:04:38 net.sf.hibernate.JDBCException <init> SEVERE: Could not execute query java.sql.SQLException: Line 1: Incorrect syntax near '|'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2217) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:1696)
    via by Walter Mourão,
    • java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)

    Users with the same issue

    odd
    odd72 times, last one,
    Unknown visitor1 times, last one,
    Eric
    Eric3 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    22 more bugmates