JSTL SQL, getting started...
843840Jun 28 2008 — edited Jun 29 2008Hi,
I am trying to get started on a simple JSP-application using JSTL SQL-tags, but keep getting an error:
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//localhost:1521:oradb01
I have been googling this for hours now, without success...
I am using Netbeans6.1 under WinXP and created a Web Application with
JavaEE5, and
Glassfish V2
Under Libraries, I added Oracle's ojdbc14.jar
In the JSP-file, I have added:
*<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>*
*<%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %>*
and then try:
*<sql:setDataSource*
driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//localhost:1521:oradb01"
user="xx"
password="xx" />
*<sql:query var="rs">*
select * from user_catalog;
*</sql:query>*
The connection-string and user/password above work fine,
when I create a connection from Services=>Databases in Netbeans,
but give the error above, when starting the jsp-page.
What am I missing?