By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

FATAL: Socket command type A unknown

P: n/a
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.

Nov 11 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Natrually right after I sent this post I found the problem. The String was
'uAKcXMobT3^@AAAAAAAAA
.... 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.


Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.