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]

Oracle Community | 3004 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Mysql JDBC LIMIT Problem ?

    Oracle Community | 1 decade ago | 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]

    Root Cause Analysis

    1. 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()
    2. com.solarmetric.jdbc
      DelegatingConnection.prepareStatement
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:133)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:173)
      4. com.solarmetric.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:127)
      5. com.solarmetric.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:156)
      6. com.solarmetric.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:127)
      6 frames
    3. kodo.jdbc.runtime
      JDBCStoreManager$RefCountConnection.prepareStatement
      1. kodo.jdbc.runtime.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1613)
      1 frame
    4. com.solarmetric.jdbc
      DelegatingConnection.prepareStatement
      1. com.solarmetric.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:114)
      1 frame
    5. kodo.jdbc.sql
      Select.execute
      1. kodo.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:293)
      2. kodo.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:271)
      3. kodo.jdbc.sql.Select.execute(Select.java:1567)
      4. kodo.jdbc.sql.Select.execute(Select.java:1520)
      4 frames
    6. kodo.jdbc.runtime
      PagingResultObjectProvider.open
      1. kodo.jdbc.runtime.SelectResultObjectProvider.open(SelectResultObjectProvider.java:102)
      2. kodo.jdbc.runtime.PagingResultObjectProvider.open(PagingResultObjectProvider.java:169)
      2 frames
    7. com.solarmetric.rop
      EagerResultList.<init>
      1. com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22)
      1 frame
    8. kodo.query
      AbstractQuery.executeWithArray
      1. kodo.query.AbstractQuery.execute(AbstractQuery.java:1052)
      2. kodo.query.AbstractQuery.executeWithArray(AbstractQuery.java:836)
      2 frames
    9. de.adtech.helios
      CampaignAdmin.getCampaignList
      1. de.adtech.helios.HeliosPersistenceFascade.getEntityList(UnknownSource)
      2. de.adtech.helios.CampaignManagement.CampaignAdmin.getCampaignList(UnknownSource)
      2 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    11. de.adtech.tools
      RichCollection.iterator
      1. de.adtech.tools.richcollection.RichCollection.getData(Unknown Source)
      2. de.adtech.tools.richcollection.RichIterator.getNextElement(UnknownSource)
      3. de.adtech.tools.richcollection.RichIterator.<init>(Unknown Source)
      4. de.adtech.tools.richcollection.RichCollection.iterator(UnknownSource)
      4 frames
    12. de.adtech.gui
      RichBaseHandler.doEndTag
      1. de.adtech.gui.renderer.ActionTreeRenderer.createRichCollectionIterator(UnknownSource)
      2. de.adtech.gui.renderer.ActionTreeRenderer.createRichCollectionIterator(UnknownSource)
      3. de.adtech.gui.renderer.ActionTreeRenderer.renderElement(UnknownSource)
      4. de.adtech.gui.renderer.ActionTreeRenderer.renderElement(UnknownSource)
      5. de.adtech.gui.renderer.RichBaseHandler.renderElementContext(UnknownSource)
      6. de.adtech.gui.renderer.RichBaseHandler.doEndTag(Unknown Source)
      6 frames
    13. org.apache.jsp
      campaignmgmt_jsp._jspService
      1. org.apache.jsp.icenter.campaignmgmt_jsp._jspx_meth_rhtml_actiontree_0(campaignmgmt_jsp.java:323)
      2. org.apache.jsp.icenter.campaignmgmt_jsp._jspService(campaignmgmt_jsp.java:147)
      2 frames
    14. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      1 frame
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    16. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      3 frames
    17. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    18. Glassfish Core
      ApplicationDispatcher.include
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)
      4. org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590)
      5. org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510)
      5 frames
    19. GWT dev
      JspRuntimeLibrary.include
      1. org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)
      1 frame
    20. org.apache.jsp
      icenterbody_jsp._jspService
      1. org.apache.jsp.icenter.icenterbody_jsp._jspService(icenterbody_jsp.java:112)
      1 frame
    21. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      1 frame
    22. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    23. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      3 frames
    24. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    25. Glassfish Core
      ApplicationDispatcher.forward
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)
      4. org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)
      5. org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)
      6. org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
      6 frames
    26. struts
      ActionServlet.doPost
      1. org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
      2. org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
      3. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
      4. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
      5. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
      5 frames
    27. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      2 frames
    28. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      2 frames
    29. filters
      SetCharacterEncodingFilter.doFilter
      1. filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
      1 frame
    30. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
      4. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      6. org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
      8. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      10. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
      11. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      12. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      13. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      14. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      15. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      16. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      17. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      18. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      18 frames
    31. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      1 frame
    32. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
      3 frames
    33. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      1 frame
    34. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame