我用weblogc连接池进行数据更新时出现如下错误:小弟很迷惑,因为同样的语句用pl/sql执行就没有错误,这是怎么会事?
请好心大侠帮帮忙,谢谢了!
java.sql.SQLException: ORA-00900: 无效 SQL 语句 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Odscrarr.receive(T4C8Odscrarr.java:206)
at oracle.jdbc.driver.T4CStatement.do_describe(T4CStatement.java:375)
at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:3220)
at oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:63)
at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:133)
at weblogic.jdbc.wrapper.ResultSet.getMetaData(ResultSet.java:185)
at hbgspagw.DataConnCa.executeQuery(dataconnca.java:87)
at jsp_servlet._1zhidui.__shunxu_post._jspService(__shunxu_post.java:175)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:526)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
请好心大侠帮帮忙,谢谢了!
java.sql.SQLException: ORA-00900: 无效 SQL 语句 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Odscrarr.receive(T4C8Odscrarr.java:206)
at oracle.jdbc.driver.T4CStatement.do_describe(T4CStatement.java:375)
at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:3220)
at oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:63)
at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:133)
at weblogic.jdbc.wrapper.ResultSet.getMetaData(ResultSet.java:185)
at hbgspagw.DataConnCa.executeQuery(dataconnca.java:87)
at jsp_servlet._1zhidui.__shunxu_post._jspService(__shunxu_post.java:175)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:526)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
解决方案 »
- java字符串搜索是否包含关键词数组,求效率最高的算法
- 求精典简历模板一份
- servlet 抛出的运行时异常,怎么传到error.jsp页面?
- 字符集转换的问题
- 各位学长,脚本里如何判断字符串有空格呀?挺急的谢谢
- log4j用DailyRollingFileAppender出现的诡异的问题
- 使用DataHandler如何返回MIME类型的response?急急急。。。。
- 100分狂顶,急问各位大侠一个与ftp有关的问题
- 求帮助,调用linux上面.so动态链接和h头文件,显示都源码,就是不知道这个linux的路径怎么使用 System.loadLibrary获取
- Dubbo服务注册不了
- Hibernate问题!
- 有关java的内存溢出问题:对象引用使用完毕后设置为null
SQL呢?错误源都没找到。