Beginner,help needed with JSTL.
Hello,
I just started on JSP.I have a simple code to query a table:
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<sql:setDataSource var="example" scope="application"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.2.1:1521:oracle"
user="xyz"
password="abc"
/>
<sql:query var="empDbInfo" dataSource="${example}">
select * from ss.emp
</sql:query>
<table>
<tr>
<c:forEach items="${empDbInfo.columnNames}" var="colName">
<th><u>${fn:escapeXml(colName)}   </u></th>
</c:forEach>
</tr>
<c:forEach items="${empDbInfo.rowsByIndex}" var="row">
<tr>
<c:forEach items="${row}" var="column">
<td>${fn:escapeXml(column)}</td>
</c:forEach>
</tr>
</c:forEach>
</table>
--
The table has been define in "ss" schema within oracle.This is the result of same query in SQL Plus:
select * from ss.emp;
N NAME
1 h
The output html that I get is just:
NNAME
and no values.
Why dont the values come?I;ve tried different things,but no luck..please help me on this.Thanks.
