jakarta-taglibs-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Morgan Delagrange <mdela...@yahoo.com>
Subject RE: jdbcTagLib: ResultSetTag does not work with Access DB
Date Mon, 05 Feb 2001 22:06:28 GMT
Hey "simple" is my middle name!  Wait, that didn't
come out right... :)

--- "Ciot, Thierry" <thierry.ciot@compuware.com>
wrote:
> You may also be interested to know that, with the
> line commented out (my
> quick fix), when the result set is empty one gets an
> exception + Tomcat
> crashes (rather the VM crashes) with an access
> violation:
>  
> 2001-02-05 04:17:26 - Ctx( /sql-examples ):
> Exception in: R( /sql-examples +
> /jdbc.jsp + null) - javax.servlet.ServletException:
> java.sql.SQLException:
> [Microsoft][ODBC Driver Manager] Invalid cursor
> state
>  
>  
> Anyway, thanks for your taglib it is really useful. 
> 
> I just tried combining it with the Woolox chart
> library and they work like a
> charm.  I got some charts displayed in the browser
> in no time.
> When one thinks how much code there is behind and
> how simple tag libs are to
> use, this is just amazing
>  
> Thierry.
> 
> -----Original Message-----
> From: Delagrange, Morgan
> [mailto:mdelagra@us.britannica.com]
> Sent: Monday, February 05, 2001 4:43 PM
> To: 'taglibs-dev@jakarta.apache.org'
> Subject: RE: jdbcTagLib: ResultSetTag does not work
> with Access DB
> 
> 
> 
> Hi all, 
> 
> Yeah, I use the isBeforeFirst() method to detect if
> the result set is empty.
> Any JDBC 2.0 compliant driver should support that
> method.  However, in the
> interest of Access amity, I'll change it.  :)
> 
> > -----Original Message----- 
> > From: Shawn Bayern [ mailto:shawn.bayern@yale.edu
> <mailto:shawn.bayern@yale.edu> ] 
> > Sent: Monday, February 05, 2001 3:35 PM 
> > To: 'taglibs-dev@jakarta.apache.org' 
> > Subject: Re: jdbcTagLib: ResultSetTag does not
> work with Access DB 
> > 
> > 
> > On Mon, 5 Feb 2001, Ciot, Thierry wrote: 
> > 
> > > When using an access DB with the odbc bridge I
> get an 
> > unsupported feature 
> > > exception at: 
> > > 
> > > ResultSetTag.doStartTag() { 
> > >     ... 
> > >     if (_rset.isBeforeFirst() == false) { return
> SKIP_BODY; } 
> > >     ... 
> > > } 
> > > 
> > > I commented out that line and got the example
> working. 
> > > I suppose the author wanted to check if the
> result set was empty? 
> > > 
> > > Is there any other way to do that such that it
> is 
> > compatable with the ODBC 
> > > bridge? 
> > 
> > Since it does a _rset.next() anyway to prepare the
> ResultSet for later 
> > use, it'd probably be better to turn 
> > 
> >      if (_rset.isBeforeFirst() == false) { return
> SKIP_BODY; } 
> >      _rset.next(); 
> > 
> > into 
> > 
> >     if (!_rset.next()) 
> >       return SKIP_BODY; 
> > 
> > anyway.  I think you're right about the code
> trying to 
> > determine whether 
> > the ResultSet has any rows; if that's true, then
> this fix should work. 
> > 
> > Shawn 
> > 
> 
> 


=====
Morgan Delagrange
Britannica.com

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Mime
View raw message