Skip site navigation (1) Skip section navigation (2)

RE: [INTERFACES] JDBC problem with string

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'ALPESH KOTHARI'" <alpeshkothari(at)yahoo(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Cc: "Peter Mount (Home)" <peter(at)retep(dot)org(dot)uk>
Subject: RE: [INTERFACES] JDBC problem with string
Date: 1999-09-30 08:02:06
Message-ID: 1B3D5E532D18D311861A00600865478C25E677@exchange1.nt.maidstone.gov.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)yahoo(dot)com]
Sent: 30 September 1999 02:29
To: pgsql-interfaces(at)postgreSQL(dot)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

pgsql-interfaces by date

Next:From: zhang-lanDate: 1999-09-30 09:19:42
Subject: Access database via Servlet
Previous:From: Tim JoyceDate: 1999-09-30 07:02:19
Subject: Re: [INTERFACES] psql trerminal behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group