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]>