This may be a stupid question, but do you have a compatible Oracle JDBC
driver on your classpath? (for example - ojdbc14.jar, not classes12.zip)
Download @
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
glassfish_at_javadesktop.org
07/26/2008 11:32 AM
Please respond to
users_at_glassfish.dev.java.net
To
users_at_glassfish.dev.java.net
cc
Subject
Sun Java Web server 7, Oracle Driver
Having a problem deplying this code on Sun Java Webserver 7.0. The same
code works fine with Tomcat.
[b][u]Code[/u]:[/b]
<%@ taglib uri="
http://java.sun.com/jstl/core_rt" prefix="c" %>
<%@ taglib prefix="sql" uri="
http://java.sun.com/jstl/sql_rt" %>
<sql:setDataSource var="datasource"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@MyServer:1521:MySID"
user="XX" password="XX" />
<sql:query var="user_parameters" dataSource="${datasource}">
SELECT * FROM usagers
WHERE user_login ='${param.txt_login}' AND user_password =
'${param.txt_password}'
</sql:query>
[b][u]Error generated by the webserver[/u]:[/b]
failure ( 5636): for host 127.0.0.1 trying to POST
/SPJ/process_authenticate.jsp, service-j2ee reports:
StandardWrapperValve[jsp]: PWC1406: Servlet.service() for servlet jsp
threw exception
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "java.sql.SQLException: No suitable driver found for
jdbc:oracle:thin:@172.20.4.201:1521:dbguce"
at
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:285)
at
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:168)
at
org.apache.jsp.spj_005fprocess_005fauthenticate_jsp._jspx_meth_sql_query_0(Unknown
Source)
at
org.apache.jsp.spj_005fprocess_005fauthenticate_jsp._jspService(Unknown
Source)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:80)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:917)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:457)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:351)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:917)
at
org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:398)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:277)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:255)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:586)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:556)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:586)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:556)
at
com.sun.webserver.connector.nsapi.NSAPIProcessor.service(NSAPIProcessor.java:160)
Anyone ever faced this before?
[Message sent by forum member 'faouzabdul' (faouzabdul)]
http://forums.java.net/jive/thread.jspa?messageID=289551
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net
-----------------------------------------------------------------------
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal, and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply. Thank you.
La présente communication, y compris toute pièce qui y a été jointe, est destinée uniquement à la personne ou à l’entité à laquelle elle a été adressée, et contient des renseignements à caractère confidentiel et personnel. Toute diffusion ou reproduction non autorisée ou toute intervention entreprise relativement à son contenu est strictement interdite. Si vous avez reçu ce message par erreur, veuillez nous le signaler immédiatement afin que nous puissions effectuer la correction à nos dossiers. Veuillez par la suite supprimer ou détruire le contenu de la transmission originale ainsi que toute réponse ultérieure. Merci.
-----------------------------------------------------------------------