I am trying to configure a JNDI data source within a JSTL application.
The app server is weblogic 7.0
I have added the following to the web.xml
<context-param>
<param-name>javax.servlet.jsp.jstl.sql.dataSource</param-name>
<param-value>spsDataSource</param-value>
</context-param>
In the JSp I am trying to use the sql tags as follows:
<sql:setDataSource var="edmDataSource" dataSource="spsDataSource"/>
<sql:query var="results" dataSource="${edmDataSource}" scope="session">
SELECT x.*,y.name FROM sps_carrier_vendor_station x, sps_vendor y WHERE
x.vendor=y.id ORDER BY x.carrier asc, x.station asc
</sql:query>
This is giving me the sollowing error on the app serve. It works if I do
not use a data source and configure the
DB connection ( URl, driver, user password etc.) right there in the JSP.
Any ideas?? Thanks.
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "N
o suitable driver"
at
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnect
ion(QueryTagSupport.java:308)
at
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag
(QueryTagSupport.java:192)
at
org.apache.taglibs.standard.tag.el.sql.QueryTag.doStartTag(QueryTag.j
ava:125)
at
jsp_servlet._carrier_vendor_station.__list_results._jspService(__list
_results.java:171)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:1058)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:401)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:445)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:306)
at
weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispat
cherImpl.java:542)
at
weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispat
cherImpl.java:368)
at
weblogic.servlet.jsp.PageContextImpl.include(PageContextImpl.java:120
)
at
jsp_servlet._carrier_vendor_station.__list._jspService(__list.java:32
4)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:1058)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:401)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:445)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:306)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:5412)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic
eManager.java:744)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3086)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
