java.sql.SQLException

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.

  • vSphere 5.1 SSO upgrade issue
    via Server Fault by Rene
    ,
  • 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: Invalid object name 'LS_CONFIGURATION'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

    Users with the same issue

    odd
    72 times, last one,
    Unknown visitor1 times, last one,
    Eric
    3 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    22 more bugmates