当前位置: 代码迷 >> Java Web开发 >> 在执行查询的时候出现的问题
  详细解决方案

在执行查询的时候出现的问题

热度:249   发布时间:2007-10-18 08:35:25.0
在执行查询的时候出现的问题
数据库oracle
web服务器weblogic

执行查询语句的时候报
SQLException: SQLState(null) vendor code(17110)
java.sql.SQLException: 执行完毕, 但带有警告
搜索更多相关主题的帖子: 数据库  服务器  java  SQLException  vendor  

----------------解决方案--------------------------------------------------------
把你的源代码和详细的错误信息帖出来

因为详细的错误信息会告诉你哪一行错了

----------------解决方案--------------------------------------------------------

错误的详细信息是
SQLException: SQLState(null) vendor code(17110)
java.sql.SQLException: 执行完毕, 但带有警告
at oracle.jdbc.driver.DatabaseError.newSqlException(DatabaseError.java:71)
at oracle.jdbc.driver.DatabaseError.newSqlException(DatabaseError.java:88)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:357)
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.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1060)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4051)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10804)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3314)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:131)
at com.mtkj.company.dao.CompanyDao.queryComp(CompanyDao.java:449)
at com.mtkj.company.ejb.CompanyBean.queryComp(CompanyBean.java:155)
at com.mtkj.company.ejb.Company_ho4qfk_ELOImpl.queryComp(Company_ho4qfk_ELOImpl.java:909)
at com.mtkj.company.action.manage.ListCompanyMAction.executeAction(ListCompanyMAction.java:78)
at com.mtkj.common.BaseAction.execute(BaseAction.java:44)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1077)


----------------解决方案--------------------------------------------------------
错误出现的那段代码指定的位置是
CompanyVo cv = null;
if (rs.next()) {
olist = new ArrayList();
do {
cv = Rs2Vo(rs);


----------------解决方案--------------------------------------------------------
Rs2Vo(rs);这是什么
----------------解决方案--------------------------------------------------------
从VO里面取数据出来



----------------解决方案--------------------------------------------------------

真是不好意思,我帮不了忙了,我不会oracle


----------------解决方案--------------------------------------------------------
  相关解决方案