com.solarmetric.jdbc.ReportingSQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINT" {prepstmnt 23459640 SELECT COUNT(t0.JDOID) FROM entityinter t0 INNER JOIN entityintersourceidentity t1 ON t0.SOURCEIDENTITY_JDOID = t1.JDOID WHERE (? = ? AND t1.CLIENTIDENTITY_JDOID IS NULL AND t0.TYPESTR = ? AND (? <> ? OR 0 = (SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINTERACTIONPROPS_JDOID IS NULL) AND t0.JDOID = t2.JDOID))) [params=(String) 1, (String) 1, (String) EMAIL_SENT, (String) 1, (String) 1] [reused=0]} [code=1064, state=42000]

Oracle Community | 3004 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Kodo 3.0.1 KodoQuery generate invalid subselect SQL for MYSQL

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINT" {prepstmnt 23459640 SELECT COUNT(t0.JDOID) FROM entityinter t0 INNER JOIN entityintersourceidentity t1 ON t0.SOURCEIDENTITY_JDOID = t1.JDOID WHERE (? = ? AND t1.CLIENTIDENTITY_JDOID IS NULL AND t0.TYPESTR = ? AND (? <> ? OR 0 = (SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINTERACTIONPROPS_JDOID IS NULL) AND t0.JDOID = t2.JDOID))) [params=(String) 1, (String) 1, (String) EMAIL_SENT, (String) 1, (String) 1] [reused=0]} [code=1064, state=42000]

    Root Cause Analysis

    1. com.solarmetric.jdbc.ReportingSQLException

      Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINT" {prepstmnt 23459640 SELECT COUNT(t0.JDOID) FROM entityinter t0 INNER JOIN entityintersourceidentity t1 ON t0.SOURCEIDENTITY_JDOID = t1.JDOID WHERE (? = ? AND t1.CLIENTIDENTITY_JDOID IS NULL AND t0.TYPESTR = ? AND (? <> ? OR 0 = (SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINTERACTIONPROPS_JDOID IS NULL) AND t0.JDOID = t2.JDOID))) [params=(String) 1, (String) 1, (String) EMAIL_SENT, (String) 1, (String) 1] [reused=0]} [code=1064, state=42000]

      at kodo.query.AbstractQuery.executeWithMap()
    2. kodo.query
      AbstractQuery.executeWithMap
      1. kodo.query.AbstractQuery.executeWithMap(AbstractQuery.java:760)
      1 frame
    3. com.jario.server
      Column.run
      1. com.jario.server.console.report.queries.EmailedExternally.runQuery(EmailedExternally.java:77)
      2. com.jario.server.console.report.engine.Column.run(Column.java:222)
      2 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame
    5. com.jario.server
      Row.run
      1. com.jario.server.console.report.engine.Column.runReport(Column.java:195)
      2. com.jario.server.console.report.engine.Row.run(Row.java:100)
      2 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame