I don't necessarily think the discussion was heated in any manner,
however, with that said . . .
This has been taken off line - since it has become, for some,
uninteresting and, in all actuality, only vaguely related to Servlets.
My question would be why are you using access when other alternatives
are available? I know nothing of access or JDBC/ODBC bridges since I
don't need or use them.
----- Original Message -----
From: Yeo Lee Seng <[EMAIL PROTECTED]>
Date: Friday, April 6, 2001 5:51 am
Subject: Re: Escape apostrophe
> Hi,
>
> I had been following the "heated" discussion about the apostrophe
> thingyCould Flores kindly elaborate on his example on the
> StringBuffer ?
> I had tried both the prepareStatement & StringBuffer approach
> The prepareStatement worked !
> but the StringBuffer din ... (my setup : MS Access + jdbc.odbc .. ;p)
> Does this particular behaviour very much depend on the driver ?
>
> "T.A. Flores" wrote:
>
> > FYI - keep posts below 300 lines or they will be rejected. Now
> back to
> > our regularly sponsored programming. . . .
> >
> > Stephen we'd all like to be right . . .
> >
> > Hmmm - not quite sure and at this point I won't be able to find out
> > because I am no longer with the company where I had this
> problem. Not
> > sure which version of Oracle 8i we were using <shrug> and I almost
> > always use the thin driver. But this I do know everyone had that
> > particular issue.
> >
> > The problem as I see it would be determing what the exact cause
> would> be like chasing a needle in a haystack. Can't say it was my IDE
> > because I don't use one, was it the JSP to servlet to the
> whatever and
> > something being lost? A database issue? The only character I
> have ever
> > had an issue with is that <edit> single quote and as far as the
> > prepared statement I find that I am usually using it.
> >
> > Are you using a Connection pool? What app server are you using? The
> > problem your having with the prepared statement doesn't sound
> > right . . . have you tried something like ?
> >
> > try{
> > ps.close( );//close the statment
> > conn.closeConnection( );//close
> connection> }catch . . .. {
> >
> > When I get more time I'll take another look at the single quote
> thing,> but for now - my lesson for the day - keep an open mind :-)
> >
> > ----- Original Message -----
> > From: Stephen Casey <[EMAIL PROTECTED]>
> > Date: Thursday, April 5, 2001 9:30 am
> > Subject: Re: how to escape apostrophe
> >
> > > Dion's example below is pretty much the same as what I use. I'm
> > > not sure
> > > what the database or JDBC driver is. I'm going against an
> Oracle 8.1.6
> > > database using their thin driver. So far I've been able to insert
> > > anythinga user types into the html form (i.e. ', ; , : , & ,
> > > %). I just use
> > > String vars instead of enclosing the string in double quotes. One
> > > problem I
> > > have with PreparedStatements is they don't go away until you
> close the
> > > connection. I've tried the close() and setting = null but they
> > > persist. My
> > > knowledge is not absolute so, please correct me if I'm wrong
> > > (cause I want
> > > to be right:-)
> >
> >
>
________________________________________________________________________
___> To unsubscribe, send email to [EMAIL PROTECTED] and include in
the body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http:
> > Resources: http://java.sun.com/products/servlet/external-
> resources.html> LISTSERV Help:
> http://www.lsoft.com/manuals/user/user.html
>
________________________________________________________________________
___
> To unsubscribe, send email to [EMAIL PROTECTED] and include in
> the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http:
> Resources: http://java.sun.com/products/servlet/external-
> resources.htmlLISTSERV Help:
> http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
