jdbc driver problem?

From: "sathish kumar shanmugavelu" <sathishkumar(dot)shanmugavelu(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: jdbc driver problem?
Date: 2006-05-16 03:51:26
Message-ID: ee0ad3a30605152051x21af0692jc6a5046096263471@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2006-05-16 05:42:53 Re: jdbc driver problem?
Previous Message Kris Jurka 2006-05-15 22:22:31 Re: JPOX Types.CHAR error