Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JSTL SQL, getting started...

843840Jun 28 2008 — edited Jun 29 2008
Hi,

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2008
Added on Jun 28 2008
13 comments
500 views