Monday, February 21, 2011

using jstl sql with a connection pool

view the post at:-  http://groups.google.com/group/oop_programming/browse_thread/thread/62099c680f049077?hl=en

with a jndi name of jdbc_void in the container 


and the following text in web.xml file




        MySQL Database Connection
        jdbc_void
        javax.sql.DataSource
        Container
        Shareable
    




and the following text in jsp file:



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




            call sp_sel_user_shouts(?,?);
            ${myID}
            ${vis}
        


${row.columnName}


download the latest jstl jar file from http://tomcat.apache.org/taglibs/standard/





No comments: