Hi,
I had been following the "heated" discussion about the apostrophe thingy
Could 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://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
___________________________________________________________________________
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
