Re: unterminated quoted string

> > > and if address is an empty string, sometimes (very rarely) i get
> > >
> > > java.sql.SQLException: ERROR: Unterminated quoted string

I once in a while got a similar error when somehow a '\0' managed to sneek
inside a string. As a result, the whole Tomcat<->Postgresql communication
stopped (in most cases). The problem probably comes from the different
treatment of zeroes in Strings in Java and C/C++.

I solved the problem by filtering out such zeroes before passing them as
parameters into prepared statements.

Mit freundlichem Gruß / With kind regards
Holger Klawitter
--
lists(at)klawitter(dot)de