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