Dear
es kranthi thanks for answering. But unfortunately I didn't understand. ResultSetFormatter returns the value of ResultSet in different formats. I've tried Text and XML so far but the output doesn't look nice. A sample output of the program (as Text run in console) looks like the image. The same program when run in jsp is unable to format new line and dashed line according to the lenght and number of returned result which makes it unreadable. The only indicator of a new line is ( | ) which also appears before every new column value too. So I'm not sure if using it to detect a new line is possible?
sample output from jsp (queries are different cause I can't run the program anymore but it looks sth like this):
-----------------------------------------------------------------------------------------------| title | subject | course ===============================================================================================| "alphabet" | " vowel, consonant" | "english" || "abc" | "alphabet" | "writing" |-----------------------------------------------------------------------------------------------
The error given is from line ( 20 ) :
HTTP Status 500 - javax.servlet.ServletException: java.lang.Error: Unresolved compilation problem: The method getValue(int) is undefined for the type String
type Exception report
message javax.servlet.ServletException: java.lang.Error: Unresolved compilation problem: The method getValue(int) is undefined for the type String
description The server encountered an internal error (javax.servlet.ServletException: java.lang.Error: Unresolved compilation problem: The method getValue(int) is undefined for the type String ) that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.Error: Unresolved compilation problem:
The method getValue(int) is undefined for the type String