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
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 |