Thank you for your prompt reply Martin and for your suggestion. Given that I have the ojdbc14.jar in the WEB-INF/lib, doesn't that the version of the OracleDriver suitable for jdk 1.4+? It *seems* like it started working when I replaced jstl-1.2.jar w/ jstl-1.1.2.jar - does that make any sense?

This is tomcat 6.0.18 on a RHEL 5 box w/ JDK 1.6.

--john

Martin Gainty wrote:
please download classes12.jar from
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
and place classes12.jar into $TOMCAT_HOME/AppContext/WEB-INF/lib/

HTH
Martin Gainty ______________________________________________ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni et de confidentialité This message is confidential. If you should not be the intended receiver, then we ask politely to report. Each unauthorized forwarding or manufacturing of a copy is inadmissible. This message serves only for the exchange of information and has no legal binding effect. Due to the easy manipulation of emails we cannot take responsibility over the the contents.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger 
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung 
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem 
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. 
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung 
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le 
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez 
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est 
interdite. Ce message sert à l'information seulement et n'aura pas n'importe 
quel effet légalement obligatoire. Étant donné que les email peuvent facilement 
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité 
pour le contenu fourni.






Date: Mon, 13 Apr 2009 16:24:31 -0600
From: john.c.cartwri...@noaa.gov
Subject: JSP: "No suitable driver found"
To: users@tomcat.apache.org

Hello All,

I have what should be a simple problem, but can't seem to resolve it. Basic JSP using a non-pooled connection:

<sql:setDataSource var="myDS"
   url="jdbc:oracle:thin:@host.example.com:1521:ORACLE"
   driver="oracle.jdbc.driver.OracleDriver"
   user="username"
   password="password"
/>


I'm getting the exception:
javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for ${myDS}"

I've confirmed that the host, user, password are correct. Of course it looks 
like a classpath problem, but WEB-INF/lib contains: jstl-1.2.jar  ojdbc14.jar  
standard.jar

Can anyone suggest what else I might try to resolve this?

Thanks!

--john






---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org


_________________________________________________________________
Rediscover Hotmail®: Get e-mail storage that grows with you. http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Storage1_042009

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to