I am having a problem retrieving a text field from MS SQL, using ResultSet rs.getString() Here is the error I am getting in JRun
500 Internal Server Error
/dev/kiosk/data_entry/testText.jsp:
Exception thrown on line '16' from page 'D:\\JSP\\Development\\kiosk\\data_entry\\testText.jsp'.
java.sql.SQLException: [JRun][SQLServer
JDBC Driver]null
at allaire.jrun.db.jdbc.base.BaseExceptions.getException(Unknown Source)
at allaire.jrun.db.jdbc.base.BaseData.convertToString(Unknown Source)
at allaire.jrun.db.jdbc.base.BaseData.convert(Unknown Source)
at allaire.jrun.db.jdbc.base.BaseData.getData(Unknown Source)
at allaire.jrun.db.jdbc.base.BaseResultSet.getString(Unknown Source)
at allaire.jrun.db.jdbc.base.BaseResultSet.getString(Unknown Source)
at jrun__kiosk__data_entry__testText2ejsp1e._jspService(jrun__kiosk__data_entry__testText2ejsp1e.java:111)
I have a feeling it is due to the size of the returned ResultSet. Any ideas?