java.sql.SQLException: Unexpected token: CALL in statement \[INSERT INTO phone\_call (id,line,phone\_id,arrive\_time,begin\_time,end\_time,long\_distance\_company,category,direction,collect\_call)  VALUES (?,?,?,?,?,?,?,?,?,?) CALL IDENTITY()\]

hsqldb | mecva | 1 decade ago
  1. 0

    CALL IDENTITY

    hsqldb | 1 decade ago | mecva
    java.sql.SQLException: Unexpected token: CALL in statement \[INSERT INTO phone\_call (id,line,phone\_id,arrive\_time,begin\_time,end\_time,long\_distance\_company,category,direction,collect\_call)  VALUES (?,?,?,?,?,?,?,?,?,?) CALL IDENTITY()\]
  2. 0

    Adding DataSource

    oreports | 1 decade ago | juniriola
    java.sql.SQLException: Unexpected token: LAST\_INSERT\_ID in statement \[SELECT LAST\_INSERT\_ID()\]
  3. 0

    Adding DataSource

    oreports | 1 decade ago | juniriola
    java.sql.SQLException: Unexpected token: LAST\_INSERT\_ID in statement \[SELECT LAST\_INSERT\_ID()\]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Big Problem..Could not execute query..

    oreports | 1 decade ago | schneexy4
    java.sql.SQLException: Table not found: REPORT\_USER in statement \[select reportuser0\_.REPORTUSER\_ID as REPORTUS1\_, reportuser0\_.NAME as NAME, reportuser0\_.PASSWORD as PASSWORD, reportuser0\_.ADMIN as ADMIN, reportuser0\_.EXTERNAL\_ID as EXTERNAL5\_, reportuser0\_.EMAIL\_ADDRESS as EMAIL\_AD6\_, reportuser0\_.PDF\_EXPORT\_TYPE as PDF\_EXPO7\_ from REPORT\_USER reportuser0\_ where (reportuser0\_.NAME=? )\]
  6. 0

    how to run openreports-tomcat 0.9.0 in Linux

    oreports | 1 decade ago | slp1961
    java.sql.SQLException: Table not found: REPORT\_USER in statement \[select reportuser0\_.REPORTUSER\_ID as REPORTUS1\_, reportuser0\_.NAME as NAME, reportuser0\_.PASSWORD as PASSWORD, reportuser0\_.ADMIN as ADMIN, reportuser0\_.EXTERNAL\_ID as EXTERNAL5\_, reportuser0\_.EMAIL\_ADDRESS as EMAIL\_AD6\_, reportuser0\_.PDF\_EXPORT\_TYPE as PDF\_EXPO7\_ from REPORT\_USER reportuser0\_ where (reportuser0\_.NAME=? )\]

    8 unregistered visitors
    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: CALL in statement \[INSERT INTO phone\_call (id,line,phone\_id,arrive\_time,begin\_time,end\_time,long\_distance\_company,category,direction,collect\_call)  VALUES (?,?,?,?,?,?,?,?,?,?) CALL IDENTITY()\]

      at org.hsqldb.jdbc.jdbcUtil.throwError()
    2. HSQLDB
      jdbcConnection.prepareStatement
      1. org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      3. org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      3 frames
    3. org.tools4j.dbfw
      AbstractDAO.insert
      1. org.tools4j.dbfw.HSQLDBService.insert(HSQLDBService.java:104)
      2. org.tools4j.dbfw.TableDataAccess.insert(TableDataAccess.java:150)
      3. org.tools4j.dbfw.AbstractDAO.insert(AbstractDAO.java:77)
      3 frames
    4. com.icc.soneto
      ConfirmedSocket$2.run
      1. com.icc.soneto.business.SonetoBusiness.createPhoneCall(SonetoBusiness.java:398)
      2. com.icc.soneto.business.SonetoBusiness.createPhoneCall(SonetoBusiness.java:364)
      3. com.icc.soneto.business.SonetoBusiness.processBeginCall(SonetoBusiness.java:325)
      4. com.icc.soneto.business.SonetoBusiness.processEvent(SonetoBusiness.java:99)
      5. com.icc.soneto.business.SonetoBusiness.access$1(SonetoBusiness.java:93)
      6. com.icc.soneto.business.SonetoBusiness$2.objectReceived(SonetoBusiness.java:73)
      7. com.icc.soneto.socket.ConfirmedSocket.dispatchObject(ConfirmedSocket.java:180)
      8. com.icc.soneto.socket.ConfirmedSocket.access$1(ConfirmedSocket.java:178)
      9. com.icc.soneto.socket.ConfirmedSocket$2.run(ConfirmedSocket.java:137)
      9 frames