aspose file tools*
The moose likes JDBC and the fly likes Problems w/ retrieving Text field in SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problems w/ retrieving Text field in SQL Server " Watch "Problems w/ retrieving Text field in SQL Server " New topic
Author

Problems w/ retrieving Text field in SQL Server

Tapan Parikh
Greenhorn

Joined: Jun 28, 2001
Posts: 26

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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Problems w/ retrieving Text field in SQL Server