anand wrote:
> 
> Well what I mean was how you tell the JSTL to use what datasource.
> I have more than one datasource defined in config.xml that are
> Connection pooled.  In web xml
> 
> Can I just say like this
> 
> <context-param>
>   <param-name>
>        javax.servlet.jsp.jstl.sql.dataSource
>  </param-name>
>  <paramvalue>
>        myDataSource
>  </param-value>
> </context-param>

If that's the name it's been registered with in the JNDI java:comp/env/
context, yes. The J2EE spec recommends that you use a name that starts
with "jdbc", however, so "jdbc/myDataSource" would be the full name if
you follow the recommended conventions. The hard rule is that you must
use the same name as you declare with the <res-ref-name> element in the
web.xml file for the application.

How to tell the container how to create and configure a data source with
this name varies between containers. For Tomcat 4, it's done with the
<ResourceParams> element in the conf/server.xml file. See the Tomcat
docs for details:

 
<http://jakarta.apache.org/tomcat/tomcat-4.0-doc/jndi-resources-howto.html>

Hans
<plug>I cover this in great detail in JavaServer Pages, Second Edition
(O'Reilly), to be released in August</plug>
-- 
Hans Bergsten           [EMAIL PROTECTED]
Gefion Software         http://www.gefionsoftware.com
JavaServer Pages        http://TheJSPBook.com


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to