java.sql.SQLException: Invalid Column Index
843854Feb 22 2004 — edited Feb 23 2004Hello,
I am writing a query and execute it with rs = statement.executeQuery(query)
everything works fine until rs tries to retrieve the second value.
rs.getString(1) works but fails while working on rs.getString(2).
I executed the query on sql and that works fine as well. My exact error log is:
java.sql.SQLException: Invalid Column Index
void oracle.jdbc.dbaccess.DBError.throwSqlException(java.lang.String, java.lang.String, int)
DBError.java:187
void oracle.jdbc.dbaccess.DBError.throwSqlException(int, java.lang.Object)
DBError.java:229
void oracle.jdbc.dbaccess.DBError.throwSqlException(int)
DBError.java:292
void oracle.jdbc.driver.OracleStatement.prepare_for_new_get(boolean, int)
OracleStatement.java:3018
long oracle.jdbc.driver.OracleStatement.getLongValue(boolean, int)
OracleStatement.java:4079
long oracle.jdbc.driver.OracleResultSetImpl.getLong(int)
OracleResultSetImpl.java:339
long com.evermind.sql.FilterResultSet.getLong(int)
FilterResultSet.java:455
void tr.com.erdemir.duks.reporting.ReportSorgu.getElekTamburRes (tr.com.erdemir.duks.reporting.Table, java.sql.Timestamp, java.sql.Timestamp, java.lang.String)
ReportSorgu.java:190
void reports.SinterCh._jspService(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
SinterCh.jsp:87
void oracle.jsp.runtime.HttpJsp.service(javax.servlet.ServletRequest, javax.servlet.ServletResponse)
HttpJsp.java:139
void oracle.jsp.runtimev2.JspPageTable.service(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, java.lang.String)
JspPageTable.java:317
void oracle.jsp.runtimev2.JspServlet.internalService(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
JspServlet.java:465
void oracle.jsp.runtimev2.JspServlet.service(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
JspServlet.java:379
void javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest, javax.servlet.ServletResponse)
HttpServlet.java:853
void com.evermind.server.http.ServletRequestDispatcher.invoke(javax.servlet.ServletRequest, javax.servlet.ServletResponse)
ServletRequestDispatcher.java:721
void com.evermind.server.http.ServletRequestDispatcher.forwardInternal(javax.servlet.ServletRequest, javax.servlet.http.HttpServletResponse)
ServletRequestDispatcher.java:306
boolean com.evermind.server.http.HttpRequestHandler.processRequest(com.evermind.server.ApplicationServerThread, com.evermind.server.http.EvermindHttpServletRequest, com.evermind.server.http.EvermindHttpServletResponse, java.io.InputStream, java.io.OutputStream, boolean)
HttpRequestHandler.java:767
void com.evermind.server.http.HttpRequestHandler.run(java.lang.Thread)
HttpRequestHandler.java:259
void com.evermind.server.http.HttpRequestHandler.run()
HttpRequestHandler.java:106
void EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run()
PooledExecutor.java:803
void java.lang.Thread.run()
Thread.java:484
========
I searched the forum but couldn't find any topic related to mine. Any help is appreciated. Thank you very much in advance.
Aylin