Hi Riaan,
It's even better than that.
Create a context.xml file and add a <Resource> that
describes your data source.
In your web.xml, add these tags:
<context-param>
<param-name>
javax.servlet.jsp.jstl.sql.dataSource
</param-name>
<param-value>jdbc/your-data-source-name</param-value>
</context-param>
<resource-ref>
<description>Your Data Source</description>
<res-ref-name>jdbc/your-data-source-name</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
This data source is now the default for this context.
Your JSTL SQL tags will simply pick it up and use it,
without having to put a <sql:setDataSource> tag in any
page.
You can declaratively change your data source by
modifying the context.xml, leaving your pages free to
simply display.
Thanks to Shawn Bayern for pointing this one out to
me. - MOD
--- Riaan Oberholzer <[EMAIL PROTECTED]>
wrote:
> Thanks, I downloaded the distribution and the JSTL
> specs. It seems my required functionality is there,
> but for one thing:
>
> In the JSLT specifiction, when setting up a
> datasource
> there is no attribute for specifying a JNDI lookup.
> It
> seems I must have the username, password, dburl and
> driver at hand.
>
> In my application, I am only giving a reference
> (JNDI
> lookup) to the datasource as setup by the admin in
> WebLogic. More detail is not known, so it seems I
> cannot setup a datasource with JSTL (the jakarta
> dbtags library DOES give this option)
>
> Do I have an old JSTL spec, is there a way to get a
> datasource via JNDI lookup or is that not possible?
>
>
> --- Mark B Starmer <[EMAIL PROTECTED]>
> wrote:
> > I'm not sure what the db tags library does off
> hand,
> > but JSTL has SQL
> > tags which I'd presume performs most of the
> similar
> > functionality of the
> > db tags, forgive me if I'm wrong...
> >
> > -----Original Message-----
> > From: Riaan Oberholzer
> > [mailto:[EMAIL PROTECTED]
> > Sent: 19 June 2003 11:37
> > To: [EMAIL PROTECTED]
> > Subject: official dbtags release available?
> >
> >
> > Does anyone know if an official release (with
> > version
> > number) is available for the jakarta-dbtags
> library?
> >
> >
> > On the jakarta website you can only download a
> > "current" which proves, in the documentation, to
> be
> > 1.0-B1 (Beta), dated August 2001. The index shows
> > dbtags to be 1.1, though, but no place else is it
> > listed as such.
> >
> > What happened to this specific library's
> development
> > since August 2001?
> >
> > It has really made my work easier, but the place
> > where
> > I work at has a policy that you are not allowed to
> > use
> > any packages tagged as Alpha, Beta of Release
> > Candidate, which officially means I cannot use the
> > dbtags library (*sigh*).
>
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
