Hi
I was getting above message while trying to parameter values in JDBC
request, below is the info that i was trying to do:
Connection was made to the pgSQl DB adn it works when i tried without
parameter values:
select * from product where product_id =1000 ---it works with this but when
i tried with
select * from product where product_id =?
parameter values : 1000
parameter type: Numeric
Reponse message: org.postgresql.util.PSQLException: ERROR: syntax error at
end of input
I havent seen anything in the logs.
The same way i was tryin to send parameter values from CSV data file, but
taht also fails.
CSV file name: c:/filepath
Variables: track_id,trackname,.....
Jdbc request:
select * from product where product_id =?
Parameter values: ${track_id}
Parametr type: Numeric
I have gone through the archive mails for the same issue and I downgrade to
pgSQL-jdbc dirver to 8.2 but no luck.
Please help me with the above.
Regards,
Siri
