日期:2014-05-17  浏览次数:20711 次

短信需求的时候报错
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>