jdbc driver problem?
От | sathish kumar shanmugavelu |
---|---|
Тема | jdbc driver problem? |
Дата | |
Msg-id | ee0ad3a30605152051x21af0692jc6a5046096263471@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: jdbc driver problem?
|
Список | 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 по дате отправления: