I said previously I am using Oracle... sorry, I'm using sybase (that's what happens when you work on multiple projects in different enviroments!)
Driver classes are sybase-jconnect-5.2. That's pretty much fixed, no alternatives there (it already in production with x number of applications). --- Mark B Starmer <[EMAIL PROTECTED]> wrote: > You need to add a database driver to the libs dir of > tomcat, what dbms > are you using? > > -----Original Message----- > From: Riaan Oberholzer > [mailto:[EMAIL PROTECTED] > Sent: 20 June 2003 11:40 > To: Tag Libraries Users List > Subject: Re: JSTL:sql - Datasource via jndi lookup? > > > I have done exactly what you describe below, except > not creating the resource reference - the > "jdbc/your-data-source-name" > value points to a JNDI lookup supplied by the > administrator, which is a > datasource global to all apps, not just my context. > (That should work, > right?) > > The Datasource works - other parts of my application > can use it fine, but JSTL throws this exception when > I > try to use it: > > javax.servlet.jsp.JspException: Unable to get > connection, DataSource invalid: "No suitable driver" > > Any ideas? > > > > --- Michael Duffy <[EMAIL PROTECTED]> wrote: > > > > 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] > > > > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > === message truncated === __________________________________ 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]
