短信需求的时候报错
DBOper'Sql in SQLString, it's : select * from LXCalMode where ItemCode='XQGX0009'
java.sql.SQLException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:97)
at com.sinosoft.utility.ExeSQL.execSQL(ExeSQL.java:2101)
at com.sinosoft.lis.sms.LXCalculator.executeSQL(LXCalculator.java:257)
at com.sinosoft.lis.sms.LXCalculator.interpretSQL(LXCalculator.java:246)
at com.sinosoft.lis.sms.LXCalculator.dealData(LXCalculator.java:169)
at com.sinosoft.lis.sms.LXCalculator.submitData(LXCalculator.java:84)
at com.sinosoft.lis.sms.LXEveryDayAuto.dealData(LXEveryDayAuto.java:93)
at com.sinosoft.lis.sms.LXEveryDayAuto.submitData(LXEveryDayAuto.java:34)
at jsp_servlet._autorun.__autolxagentbirthdayservice1._jspService(__autolxagentbirthdayservice1.java:120)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3404)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1398)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
##### Error Sql in ExeSQL at execSQL(String sql): select a.agentcode,a.name,a.sex,a.mobile, b.appntname,b.contno,d.sumactupaymoney
from laagent a, lccont b , ljapay d
where b.conttype = '1'
and not exists(select 1 from lccont x where x.salechnl='02' and x.salechnldetail='05' and x.contno=b.contno)
and b.payintv<>'1'
and d.incomeno=b.contno and d.getnoticeno like '1021%'
and exists(select 1 from ljapayperson l where d.getnoticeno=l.getnoticeno and l.paycount>