Thread: Re: FATAL: Socket command type A unknown
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. >
Joseph, It should be fixed in the current driver build on jdbc.postgresql.org. --Barry Joseph Shraibman wrote: > 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. >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >
Barry Lind wrote: > Joseph, > > It should be fixed in the current driver build on jdbc.postgresql.org. So only the 7.4 branch has the fix?
Joseph, Sorry I wasn't clear, it is fixed in either the latest 7.3 build or the current dev (i.e. 7.4) build. --Barry Joseph Shraibman wrote: > Barry Lind wrote: > >> Joseph, >> >> It should be fixed in the current driver build on jdbc.postgresql.org. > > > So only the 7.4 branch has the fix? > >