在执行查询的时候出现的问题 - 编程论坛

#2

千里冰封2007-10-18 11:21

把你的源代码和详细的错误信息帖出来

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

#3

yjm2392007-10-18 13:23

错误的详细信息是
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)

#4

yjm2392007-10-18 13:24

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

#5

千里冰封2007-10-18 13:29

Rs2Vo(rs);这是什么

#6

yjm2392007-10-18 14:09

从VO里面取数据出来

#7

xinxue2007-10-22 08:48

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