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 '' at line 1" {prepstmnt 3338151 SELECT COUNT(?) FROM [reused=0]} [code=1064, state=42000]

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.

  • count(1) problem
    via by 3004,
  • Webstart Issue
    via by 3004,
  • Kodo v4.0.0EA2 Bugs List
    via by 3004,
  • Query under Transaction Exception....
    via by 3004,
  • 3.0.0RC2 MappingTool producing bad SQL
    via by 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 '' at line 1" {prepstmnt 3338151 SELECT COUNT(?) FROM [reused=0]} [code=1064, state=42000] at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124) at com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19) at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:708) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:352) at kodo.jdbc.runtime.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1707) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:339) at kodo.jdbc.sql.Select.execute(Select.java:1568) at kodo.jdbc.sql.Select.execute(Select.java:1520) at kodo.jdbc.runtime.SelectResultObjectProvider.open(SelectResultObjectProvider.java:102) at kodo.query.AbstractQuery$PackingResultObjectProvider.open(AbstractQuery.java:2968) at kodo.query.AbstractQuery.getSingleResult(AbstractQuery.java:1111) at kodo.query.AbstractQuery.execute(AbstractQuery.java:1050) at kodo.query.AbstractQuery.executeWithArray(AbstractQuery.java:836) at kodo.query.AbstractQuery.execute(AbstractQuery.java:793) at de.adtech.helios.test.WebsiteAdminTest.testEntityListSize(WebsiteAdminTest.java:1097) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
    No Bugmate found.