Upon executing a simple query as given below:
Select * from corp_users where lower(user_id) = 'abcd123' or
lower(email)='abc...@company.com'
through a Statement object, we get the following SQL Exception:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not
re-read row data for column 8.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown
Source)
at com.microsoft.jdbc.base.BaseResultSet.getShort(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getShort(Unknown Source)
at corporate.CorpUserManager.fetchData(CorpUserManager.java:1197)
at
jrun__login_confirmation2ejsp17._jspService(jrun__login_confirmation2ejsp17.
java:234)
at allaire.jrun.jsp.HttpJSPServlet.service(../jsp/HttpJSPServlet.java:40)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:925)
at
allaire.jrun.servlet.JRunNamedDispatcher.forward(../servlet/JRunNamedDispatc
her.java:34)
at allaire.jrun.jsp.JSPServlet.service(../jsp/JSPServlet.java:175)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:925)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDis
patcher.java:88)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1131)
at allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:330)
at allaire.jrun.jrpp.ProxyEndpoint.run(../jrpp/ProxyEndpoint.java:382)
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272)
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)
Any help regarding this would be greatly appreciated!
Regards,
Yatin Kulkarni
Fremont, CA