java.sql.SQLException: 未执行语句句柄

最新推荐文章于 2021-04-07 05:08:13 发布

原创最新推荐文章于 2021-04-07 05:08:13 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Java #SQL #Oracle #Apache #Struts

本文探讨了在使用Java进行SQL查询时遇到的未执行语句句柄错误，提供了排查和解决该问题的方法。

 Failed to Find: sql = select type,name,description,remark,tableinfoid from  tablefield  where tableinfoid = ( select id from tableinfo where name = 'NEWSPAPER') order by name
java.sql.SQLException: 未执行语句句柄
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
	at oracle.jdbc.driver.T4CStatement.doDescribe(T4CStatement.java:726)
	at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3307)
	at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1925)
	at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1514)
	at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:225)
	at com.paradise.util.Transformer.invokeMethod(Transformer.java:50)
	at com.paradise.dao.BaseDaoImpl.find(BaseDaoImpl.java:129)
	at com.autonomy.configPlus.acommon.bean.BDao.selectFieldByName(BDao.java:768)
	at com.autonomy.configPlus.dbMg.service.dbService.getListToJson(dbService.java:712)
	at com.autonomy.configPlus.dbMg.view.DbMgAction.getAlltablefieldsByName(DbMgAction.java:399)
	at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.autonomy.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:42)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
	at java.lang.Thread.run(Unknown Source)