作一个统计功能的时候遇到的问题。我通过循环取出数据,在同一个循环开始的一些存取中数据是正常的,但是到后面还剩两次循环的时候写SQL语句的字符串就被截断了,,
程序和报错如下:
{
  String strSqlTJ="select continent,count(WEB_LOG_DLSJ) as CS  from WEB_LOG  left join Continent on WEB_LOG.WEB_LOG_ADDJ  like '%'||Continent.Country||'%' where WEB_LOG.WEB_LOG_URL like '"+sURL+"%' and WEB_LOG_DLSJ between To_Date('"+strStart+"','YYYY-MM-DD') and To_Date('"+strEnd+"','YYYY-MM-DD') group by continent"; 
   out.print(strSqlTJ); ////这里出问题字符串截断。
 dbRst = stmt.executeQuery(strSqlTJ);
  while(dbRst.next())
{       
iCount++;
List ARow = new ArrayList();
ARow.add(dbRst.getString("continent"));//区域
ARow.add(dbRst.getString("CS"));//次数   
LArea.add(ARow);
}
dbRst.close();
dbRst = null;

}
最后几个循环的SQL输出
select continent,count(WEB_LOG_DLSJ) as CS from WEB_LOG left join Continent on WEB_LOG.WEB_LOG_ADDJ like '%'||Continent.Country||'%' where WEB_LOG.WEB_LOG_URL like '/keling/page/power/guangfu%' and WEB_LOG_DLSJ between To_Date('2005-1-1','YYYY-MM-DD') and To_Date('2006-1-1','YYYY-MM-DD') group by continentselect continent,count(WEB_LOG_DLSJ) as CS from WEB_LOG left join Continent on WEB_LOG.WEB_LOG_ADDJ like '%'||Continent.Country||'%' where WEB_LOG.WEB_LOG_URL like '/keling/page/power/igbt%' and WEB_LOG_DLSJ between To_Date('2005-1-1','YYYY-MM-DD') and To_Date('2006-1-1','YYYY-MM-DD') group by continentselect continent,count(WEB_LOG_DLSJ) as CS from WEB_LOG left join Continent on WEB_LOG.WEB_LOG_ADDJ like '%'||Continent.Country||'%' where 
报错:
Error: 500
Location: /keling/page/gongsi/ToEXCEL.jsp
Internal Servlet Error:javax.servlet.ServletException: ORA-00936: missing expression at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:412)
at keling.page.gongsi.ToEXCEL_25._jspService(ToEXCEL_25.java:524)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:78)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:534)
at org.apache.tomcat.core.Handler.invoke(Handler.java:280)
at org.apache.tomcat.core.Handler.service(Handler.java:193)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:445)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:874)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:790)
at org.apache.coyote.tomcat3.Tomcat3Adapter.service(Tomcat3Adapter.java:64)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
at java.lang.Thread.run(Thread.java:484)
Root cause:
java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:572)
at keling.page.gongsi.ToEXCEL_25._jspService(ToEXCEL_25.java:429)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:78)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:534)
at org.apache.tomcat.core.Handler.invoke(Handler.java:280)
at org.apache.tomcat.core.Handler.service(Handler.java:193)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:445)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:874)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:790)
at org.apache.coyote.tomcat3.Tomcat3Adapter.service(Tomcat3Adapter.java:64)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
at java.lang.Thread.run(Thread.java:484)