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]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 3004, 1 year ago
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
via Oracle Community by 3004, 1 year ago
ERROR: syntax error at or near "WHERE" {prepstmnt 16398807 SELECT AVG(t0.lengthinminutes) FROM WHERE t1.jdoclass = ? [reused=0]} [code=0, state=42601]
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(AbstractQuery.java:760)
at com.jario.server.console.report.queries.EmailedExternally.runQuery(EmailedExternally.java:77)
at com.jario.server.console.report.engine.Column.run(Column.java:222)
at java.lang.Thread.run(Thread.java:534)
at com.jario.server.console.report.engine.Column.runReport(Column.java:195)
at com.jario.server.console.report.engine.Row.run(Row.java:100)
at java.lang.Thread.run(Thread.java:534)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.