搜索一直报错：错误代码:1301 数据集配置错误Query:ORA-00933: SQL 命令未正确结束

zsh334412(提问者)

语句就是这个：
select * from clf_yd_st
${if(len(bm)==0,\"\",\"  and 部门 = \'\"+bm+\"\'\")}
order by 中心

clf_yd_st 表是我建的视图

回复

2016-08-04 15:59 

取消 回复

macro_hard

and 改成where

回复

2016-08-04 16:01 

取消 回复

gxy120313

select * from clf_yd_st where 1=1 ${if(len(bm)==0,\"\",\"  and 部门 = \'\"+bm+\"\'\")} order by 中心
这样写试试

回复

2016-08-04 16:06 

取消 回复

zsh334412(提问者)

我看之前设置的是and ，是生效的，所以我都用and 了。改成where以后，单条数据是可以查询的，如果我用下拉复选框，选择超过一个，又报错了。麻烦再帮忙看下

Oops!!!非常抱歉，您当前无法访问此页。
发生的问题是：错误代码:1301 数据集配置错误Query:ORA-00933: SQL 命令未正确结束

     
  详细信息   
     

java.lang.RuntimeException: 错误代码:1301 数据集配置错误Query:ORA-00933: SQL 命令未正确结束 at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.r.A(Unknown Source) at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.I.E(Unknown Source) at com.fr.report.core.A.I.A(Unknown Source) at com.fr.report.core.A.I.B(Unknown Source) at com.fr.report.worksheet.WorkSheet._execute(Unknown Source) at com.fr.report.worksheet.WorkSheet.execute(Unknown Source) at com.fr.report.core.A.C.C.E(Unknown Source) at com.fr.report.core.A.C.C.C(Unknown Source) at com.fr.main.impl.WorkBook.execute(Unknown Source) at com.fr.log.LogUtils$1.exe(Unknown Source) at com.fr.log.LogUtils.executeAndLogAndRecord(Unknown Source) at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source) at com.fr.web.cache.ReportCache.getResultWorkBook(Unknown Source) at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source) at com.fr.web.core.ShowWorkBookPolicy$Policy4Page.show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.showDirect(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.createPageSetChain(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getReportPage(Unknown Source) at com.fr.web.core.A.yA$_A.A(Unknown Source) at com.fr.web.core.A.yA$_A.A(Unknown Source) at com.fr.web.core.A.yA.process(Unknown Source) at com.fr.web.core.ReportDispatcher.dealInOp(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source) at com.fr.web.BaseServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)Caused by: com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误Query:ORA-00933: SQL 命令未正确结束 at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckInColumns(Unknown Source) at com.fr.data.impl.AbstractDBDataModel.getColumnCount(Unknown Source) ... 45 moreCaused by: java.sql.SQLException: ORA-00933: SQL 命令未正确结束 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:800) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273) at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) ... 47 more

回复

2016-08-04 16:05 

取消 回复

gxy120313

使用下拉复选框，分割符要注意写法，如图

回复

2016-08-04 16:09 

取消 回复

macro_hard

复选框要用in，部门 in (\"+bm+\")，复选框的设置参照gxy120313大神的

回复

2016-08-04 16:13 

取消 回复

zsh334412(提问者)

加 where 1=1 有用。 把and改成 where 也有用，真是神奇

回复

2016-08-04 16:10 

取消 回复

zsh334412(提问者)

默认有加逗号的

回复

2016-08-04 16:12 

取消 回复

gxy120313

使用where 1=1 那样写就可以，分隔符不能直接使用\"，\"必须是\',\'不然就会报错

回复

2016-08-04 16:15 

取消 回复