<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.6000.17095" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma; COLOR: #000000" text=#000000 bgColor=#ffffff>
<DIV>Thanks!! That works great!</DIV>
<DIV> </DIV>
<DIV><BR><BR>>>> Carl-Erik Herheim <carl-erik.herheim@nsd.uib.no> 28/Mar/2011 1:13 am >>><BR>Hi Tony,<BR>I remember having some trouble figuring that out myself. If your connection is named "foo" and the name of the db variable in your jsp is "bar", you can do it like this:<BR><BR><sql:setDataSource dataSource="jdbc:apache:commons:dbcp:opencms:foo" var="bar" /><BR><BR>- Carl-Erik Herheim<BR><BR><BR>Den 20:59, skrev Tony Thul: </DIV>
<BLOCKQUOTE cite=mid:%3C4D8CA232.10F4.00D2.0@regina.ca%3E type="cite">
<META content="MSHTML 6.00.6000.17095" name=GENERATOR>
<DIV>Is there a way to use <sql:setDataSource... in JSTL to get a connection from the pools defined in opencms.properties?</DIV>
<DIV> </DIV>
<DIV>Thanks!</DIV><BR>
<P><FONT face=Tahoma size=2><B>DISCLAIMER:</B> The information transmitted is intended only for the addressee and may contain confidential, proprietary and/or privileged material. Any unauthorized review, distribution or other use of or the taking of any action in reliance upon this information is prohibited. If you received this in error, please contact the sender and delete or destroy this message and any copies. </FONT></P></BLOCKQUOTE><BR>
<p>
<font size="2" face="Tahoma"><b>DISCLAIMER:</b> The information
transmitted is intended only for the addressee and may contain
confidential, proprietary and/or privileged material. Any unauthorized
review, distribution or other use of or the taking of any action in
reliance upon this information is prohibited. If you received this in
error, please contact the sender and delete or destroy this message and
any copies. </font>
</p>
</BODY></HTML>