Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: Invalid Column Index

843854Feb 22 2004 — edited Feb 23 2004
Hello,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2004
Added on Feb 22 2004
2 comments
375 views