I had to leave early yesterday. I'm just getting back to it. A question, I've been developing JSPs using
Servlets and
Java classes for several years. I've never used JSTLs. My boss has developed his own taglibs and I implement some of them. I stumbled upon the JSTLs while looking for authentication information. Anyway, I don't see what I'm gaining by using them opposed to using a servlet. What advantages do you find in using JSTL, if any?
I've included the first error I receive as well as the code that either causes the error or that at least contains the variable that it is complaining about. I'm not sure how to answer your question when you ask about my setup. Sorry!
Error:
java.lang.NumberFormatException: For input
string: "${noOfRows}"
java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
java.lang.Integer.parseInt(Integer.java:447)
java.lang.Integer.valueOf(Integer.java:553)
org.apache.jasper.compiler.JspUtil.coerceToInt(JspUtil.java:752)
org.apache.jasper.compiler.Generator$GenerateVisitor.convertString(Generator.java:2916)
org.apache.jasper.compiler.Generator$GenerateVisitor.evaluateAttribute(Generator.java:2719)
org.apache.jasper.compiler.Generator$GenerateVisitor.generateSetters(Generator.java:2825)
org.apache.jasper.compiler.Generator$GenerateVisitor.generateCustomStart(Generator.java:2158)
org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1669)
org.apache.jasper.compiler.Node$CustomTag.accept(Node.java:1441)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2213)
org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1689)
org.apache.jasper.compiler.Node$CustomTag.accept(Node.java:1441)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2213)
org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2219)
org.apache.jasper.compiler.Node$Root.accept(Node.java:456)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)
org.apache.jasper.compiler.Generator.generate(Generator.java:3272)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:244)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:470)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
Code:
<jsp_core:set var="noOfRows" value="5" />
<jsp_sql:query
var="students"
dataSource="${ds}"
scope="session"
maxRows="${noOfRows}"
startRow="${begin}">
SELECT a.StudentID, a.StuLName, a.StuFName, a.StuUsername, a.Created, a.Inactive, b.Reason, b.UserId, InactiveDate, c.Fname, c.Lname FROM Student a LEFT OUTER JOIN Inactive b ON a.StudentID = b.StudentID LEFT OUTER JOIN Users c ON b.UserId = c.UserId WHERE UPPER( StuLName ) LIKE ? ORDER BY a.StuLName
<jsp_sql:param value="${param.letter}%" />
</jsp_sql:query>