JSP JSTL and Glassfish V3 using Eclipse Helios
I have been developing Web Services using JDNI Connection Pools and it has been working great. I wanted to learn how to get my data using JSP and so I am working through a book on JSP 2. In the book, we created a jsp file and entered <sql:datasource tag line but it kept giving me a no suitable driver found error. I tried everything and could not get it to work. So I thought how about using a connection pool that I already know works and so I removed the datasource tag line and added the connection pool instead. I found this when I googled connection pool and JSTL. Well, I am still getting the same error. I have tried copying the sqljdbc.jar file into the lib folder of the domain. The ext folder, the database folder. It was already int he glassfish lib folder. And still the same error. I added the JPA facet and that didnt work. I am currently using Eclipse Helios. Glassfish v3. SQL Server 2005. Maybe someone could point me in the right direction. Please provide examples.
taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
sql:query var="books" dataSource="jdbc/Work">
SELECT id, title, price FROM book