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
