• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with JSTL sql library in JSP

 
Purushoth Thambu
Ranch Hand
Posts: 425
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am using Tomcat 5.0.27,

I am trying to use the JSTL sql library in the JSP file. I registered JDBC with JNDI. The problem is with JSTL sql library. When I try to use the JDBC/JNDI in servlet I don't face any problem.

I copied the jstl.jar and standard.jar to common\lib folder and well as my applications WEB-INF\lib folder.

Below is the test jsp

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>

<sql:query var="rs" dataSource="jdbc/BramhaDB">
select ename from emp
</sql:query>

<html>
<head>
<title>DB Test</title>
</head>
<body>

<h2>Results</h2>
<c:forEach var="row" items="${rs.rows}">
Foo <c ut value="${row.empno}" /> <br/>
</c:forEach>

</body>
</html>

Output
======

Results
Foo ${row.empno}

I guess there is some problem with some setup.. please let me know how to make the sql tag library work.. core library is working fine..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic