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

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