What version of the driver are you using?
The Exception you noted usually means that you missed out setting a
value to one or more parameters, but you haven't missed any in your
code.
I'll check this out when I get back home. I'm not aware of any problems
with PreparedStatement.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: ALPESH KOTHARI [mailto:alpeshkothari@yahoo.com]
Sent: 30 September 1999 02:29
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] JDBC problem with string
Hello Everybody,
I have written one program in java2 to write the data
in postgresql. I am storing one integer and one string
in the database. When i read the string from the file
it is proper. But when i want to store it, it gives
the
following exception:
java.sql.SQLException: ERROR: parser: parse error at
or near ""
I am not able to detect the error. Can any one run the
code and correct the problem?
When I assign the string test1 some fixed value (say
"foo") and run the code, then the program works fine.
Here is the code:
*************************************************
The file which i read is test1 which is something
like:
wyt7GIsstustututuC4??
Please run the code on your computer and let me know
the problem.
Thanking You
=====
KOTHARI ALPESH D.
STUDENT M. TECH.
CEDT
INDIAN INSTITUTE OF SCIENCE
BANGALORE-560 012
INDIA