oracle数据库,Db.find()Db.query()在执行“
SELECT A.ID, SPH.GENINBILLNO, A.COMPID, A.OWNERID, A.BILLNO, A.SENDADDR, A.SALEDEPTID, A.CREATEUSER, A.CREATEDATE, A.GATHFLAG, A.ISGENMA, C.DEPTCODE, C.DEPTNAME, E.EMPCODE, E.EMPNAME, A.BALDAY, A.BALBIZSTATUS, A.BALFINSTATUS, A.BIZTYPE, A.GATHDATE, A.TOTALVALUE, B.CODE, B.NAME, B.TEL, A.RXNO, E.NAME AS RXNAME, E.CODE AS MTUCODE, E.DNAME AS MTUDNAME, A.DELIVDATE, A.INVCSTNAME, A.MITYPE, A.STOPFLAG, A.SOID FROM SCM_SALBILL_GRP A, SCM_SALBILL_HDR SPH, PUB_DEPT C, PUB_EMP E, PUB_RTLCUSTOMER B, ( SELECT C.ID, C.NAME, D.CODE, D.DNAME FROM PUB_RTLRX_HDR C, PUB_RTLMTU D WHERE C.MTUID = D.ID ( + )) E WHERE A.SALEDEPTID = C.DEPTID ( + ) AND A.CREATEUSER = E.EMPID AND A.FLOWID IN ( '1600', '1110', '1640' ) AND A.CUSTOMERID = B.ID ( + ) AND A.RXID = E.ID ( + ) AND A.ID = SPH.GRPID AND ( A.COMPID = 1 AND A.OWNERID = 1 AND A.SALEDEPTID = 9001001 AND TO_CHAR( A.CREATEDATE, 'YYYY/MM/DD' ) >= TO_CHAR( TO_DATE( '2019-03-14', 'YYYY/MM/DD' ), 'YYYY/MM/DD' ) AND TO_CHAR( A.CREATEDATE, 'YYYY/MM/DD' ) <= TO_CHAR( TO_DATE( '2019-03-14', 'YYYY/MM/DD' ), 'YYYY/MM/DD' ) AND A.FLOWID = '1600' )
”时无报错无结果,但在plsql和navicat中是有返回结果的。
项目:JFinal
此外注意 jdbcUrl 配置的数据库地址是对的