Natrually right after I sent this post I found the problem. The String was
'[EMAIL PROTECTED]
... which is the old problem with jdbc and embedded 0 charachters. In what version of the driver was that fixed?



Joseph Shraibman wrote:
I'm having a wierd problem with pg 7.3.3

PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)

I have a bunch of inserts being done by JDBC. One of them if causing a problem.

LOG: query: INSERT INTO mailtextlog (mlid,tlog,cdate) VALUES(99999933,'Sent via localhost','2003-08-27 11:07:53.701');
LOG: query: INSERT INTO mailtextlog (mlid,tlog,cdate) VALUES(99999934,'While talking to mx1.lix.aon.at [195.3.86.141]: uAKcXMobT3
ERROR: parser: unterminated quoted string at or near "'While talking to mx1.lix.aon.at [195.3.86.141]: uAKcXMobT3" at character 59
FATAL: Socket command type A unknown



Obviously the pg log is not showing the end of the instert I'm sending via jdbc. I'm not sure what the string is supposed to be because it is dynamically generated, but it should have been something like the line above it.




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to