jdbc driver problem? - Mailing list pgsql-jdbc

From sathish kumar shanmugavelu
Subject jdbc driver problem?
Date
Msg-id ee0ad3a30605152051x21af0692jc6a5046096263471@mail.gmail.com
Whole thread Raw
Responses Re: jdbc driver problem?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc

Hi all,
   Iam using postgresql-8.2dev-501.jdbc3.jar jdbc.
   We used a query like
            SELECT * FROM patient_head WHERE  patient_name = ?
   in the prepared statement. And set the parameter as setString(1,name) , where 'name' is the java string variable.
   while printing the prepared statement the query is displayed like
            SELECT * FROM patient_head WHERE  patient_name = James Cameroon
   instead of
             SELECT * FROM patient_head WHERE  patient_name = 'James Cameroon'
   with single quotes.
   It happens in both the 7.4.7 and 8.1 version of the postgresql.
   Because of this the query does not executes and no result is fetched.
   Why? do i miss anything? please help?

with advanced thanks
--
Sathish Kumar.S
SpireTEK

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: JPOX Types.CHAR error
Next
From: Oliver Jowett
Date:
Subject: Re: jdbc driver problem?