com.solarmetric.jdbc.ReportingSQLException: 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 {SELECT t0.ID, t0.JDOCLASS, t0.JDOVERSION, t0.ABSOLUTEENDDATE, t0.ABSOLUTESTARTDATE, t0.ADGOALTYPEID, t0.ADVERTISERID, t0.BANNERDELIVERYTYPEID, t0.BARTERWEBSITEID, t0.CAMPAIGNTYPEID, t0.COMMENT, t0.COMPANION, t0.CREATEDAT, t0.CREATEDBY, t0.CURRENTDATERANGEENDDATE, t0.CURRENTDATERANGESTARTDATE, t0.CUSTOMERID, t0.DEFAULTALTTEXT, t0.DEFAULTLINKURL, t0.DELETED, t0.DESCRIPTION, t0.EXCLUSIVE, t0.EXTID, t1.JDOID, t1.JDOCLASS, t1.JDOVERSION, t1.DISTRIBUTED, t1.TYPE0, t1.VIEWS, t0.ISTEMPLATE, t0.LASTMODIFIEDAT, t0.LASTMODIFIEDBY, t0.NAME0, t0.NETWORKID, t0.NUMBEROFBANNERS, t0.OPTIMIZERTYPEID, t2.JDOID, t2.JDOCLASS, t2.JDOVERSION, t2.MINCLICKRATE, t2.MINNOPLACEMENTS, t2.RUNOVERNETWORK, t2.RUNOVERWEBSITE, t0.PAYMENTTYPEID, t3.JDOID, t3.JDOCLASS, t3.JDOVERSION, t3.CLICKVALIDITYPERIOD, t3.COMMISSION, t3.COMMISSIONTYPE, t3.ONLYFIRST, t3.POSTCLICKBEACONID, t3.USERTRACKBEACONID, t4.JDOID, t4.JDOCLASS, t4.JDOVERSION, t4.CLICKRATE, t4.CPC, t4.CPM, t4.CPT, t4.FLATFEE, t0.PRIORITY, t0.RATETYPEID, t0.STATUSTYPEID, t0.SUBNETWORKID, t0.TEMPLATEGROUPID, t0.TEMPLATEIDUSED, t0.TREETYPEID, t0.USESIZEFILTER, t0.VERSION, t0.VIEWCOUNT FROM campaign t0 LEFT OUTER JOIN frequencyconfig t1 ON t0.FREQUENCYCONFIG_JDOID = t1.JDOID LEFT OUTER JOIN optimizingconfig t2 ON t0.OPTIMIZING_JDOID = t2.JDOID LEFT OUTER JOIN postclickconfig t3 ON t0.POSTCLICKCONFIG_JDOID = t3.JDOID LEFT OUTER JOIN pricingconfig t4 ON t0.PRICINGCONFIG_JDOID = t4.JDOID WHERE (t0.NETWORKID = ? AND t0.SUBNETWORKID = ? AND t0.ISTEMPLATE = ?) ORDER BY t0.NAME0 ASC LIMIT ?, ?} [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.

  • Mysql JDBC LIMIT Problem ?
    via by 3004,
  • Kodo v4.0.0EA2 Bugs List
    via by 3004,
  • 3.0.0RC2 MappingTool producing bad SQL
    via by 3004,
  • Webstart Issue
    via by 3004,
  • XA error
    via by 3004,
    • com.solarmetric.jdbc.ReportingSQLException: 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 {SELECT t0.ID, t0.JDOCLASS, t0.JDOVERSION, t0.ABSOLUTEENDDATE, t0.ABSOLUTESTARTDATE, t0.ADGOALTYPEID, t0.ADVERTISERID, t0.BANNERDELIVERYTYPEID, t0.BARTERWEBSITEID, t0.CAMPAIGNTYPEID, t0.COMMENT, t0.COMPANION, t0.CREATEDAT, t0.CREATEDBY, t0.CURRENTDATERANGEENDDATE, t0.CURRENTDATERANGESTARTDATE, t0.CUSTOMERID, t0.DEFAULTALTTEXT, t0.DEFAULTLINKURL, t0.DELETED, t0.DESCRIPTION, t0.EXCLUSIVE, t0.EXTID, t1.JDOID, t1.JDOCLASS, t1.JDOVERSION, t1.DISTRIBUTED, t1.TYPE0, t1.VIEWS, t0.ISTEMPLATE, t0.LASTMODIFIEDAT, t0.LASTMODIFIEDBY, t0.NAME0, t0.NETWORKID, t0.NUMBEROFBANNERS, t0.OPTIMIZERTYPEID, t2.JDOID, t2.JDOCLASS, t2.JDOVERSION, t2.MINCLICKRATE, t2.MINNOPLACEMENTS, t2.RUNOVERNETWORK, t2.RUNOVERWEBSITE, t0.PAYMENTTYPEID, t3.JDOID, t3.JDOCLASS, t3.JDOVERSION, t3.CLICKVALIDITYPERIOD, t3.COMMISSION, t3.COMMISSIONTYPE, t3.ONLYFIRST, t3.POSTCLICKBEACONID, t3.USERTRACKBEACONID, t4.JDOID, t4.JDOCLASS, t4.JDOVERSION, t4.CLICKRATE, t4.CPC, t4.CPM, t4.CPT, t4.FLATFEE, t0.PRIORITY, t0.RATETYPEID, t0.STATUSTYPEID, t0.SUBNETWORKID, t0.TEMPLATEGROUPID, t0.TEMPLATEIDUSED, t0.TREETYPEID, t0.USESIZEFILTER, t0.VERSION, t0.VIEWCOUNT FROM campaign t0 LEFT OUTER JOIN frequencyconfig t1 ON t0.FREQUENCYCONFIG_JDOID = t1.JDOID LEFT OUTER JOIN optimizingconfig t2 ON t0.OPTIMIZING_JDOID = t2.JDOID LEFT OUTER JOIN postclickconfig t3 ON t0.POSTCLICKCONFIG_JDOID = t3.JDOID LEFT OUTER JOIN pricingconfig t4 ON t0.PRICINGCONFIG_JDOID = t4.JDOID WHERE (t0.NETWORKID = ? AND t0.SUBNETWORKID = ? AND t0.ISTEMPLATE = ?) ORDER BY t0.NAME0 ASC LIMIT ?, ?} [code=1064, state=42000] at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:133) at com.solarmetric.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:19) at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:173) at com.solarmetric.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:127) at com.solarmetric.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:156) at com.solarmetric.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:127) at kodo.jdbc.runtime.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1613) at com.solarmetric.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:114) at kodo.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:293) at kodo.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:271) at kodo.jdbc.sql.Select.execute(Select.java:1567) at kodo.jdbc.sql.Select.execute(Select.java:1520) at kodo.jdbc.runtime.SelectResultObjectProvider.open(SelectResultObjectProvider.java:102) at kodo.jdbc.runtime.PagingResultObjectProvider.open(PagingResultObjectProvider.java:169) at com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22) at kodo.query.AbstractQuery.execute(AbstractQuery.java:1052) at kodo.query.AbstractQuery.executeWithArray(AbstractQuery.java:836) at de.adtech.helios.HeliosPersistenceFascade.getEntityList(UnknownSource) at de.adtech.helios.CampaignManagement.CampaignAdmin.getCampaignList(UnknownSource) 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 de.adtech.tools.richcollection.RichCollection.getData(Unknown Source) at de.adtech.tools.richcollection.RichIterator.getNextElement(UnknownSource) at de.adtech.tools.richcollection.RichIterator.<init>(Unknown Source) at de.adtech.tools.richcollection.RichCollection.iterator(UnknownSource) at de.adtech.gui.renderer.ActionTreeRenderer.createRichCollectionIterator(UnknownSource) at de.adtech.gui.renderer.ActionTreeRenderer.createRichCollectionIterator(UnknownSource) at de.adtech.gui.renderer.ActionTreeRenderer.renderElement(UnknownSource) at de.adtech.gui.renderer.ActionTreeRenderer.renderElement(UnknownSource) at de.adtech.gui.renderer.RichBaseHandler.renderElementContext(UnknownSource) at de.adtech.gui.renderer.RichBaseHandler.doEndTag(Unknown Source) at org.apache.jsp.icenter.campaignmgmt_jsp._jspx_meth_rhtml_actiontree_0(campaignmgmt_jsp.java:323) at org.apache.jsp.icenter.campaignmgmt_jsp._jspService(campaignmgmt_jsp.java:147) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966) at org.apache.jsp.icenter.icenterbody_jsp._jspService(icenterbody_jsp.java:112) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534)
    No Bugmate found.