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

Re: Unterminated quoted string error.

From: "Thomas O'Dowd" <tom(at)nooper(dot)com>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Unterminated quoted string error.
Date: 2001-08-28 23:53:31
Message-ID: 20010829085331.K32410@beast.uwillsee.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks Barry,

I turned on debugging in postgresql. I found that the query is being truncated
and is not fully making it to the backend, therefore I'm getting the 
Unterminated string error. I'll have a look into why and report back if
I find anything.

Cheers,

Tom.

On Tue, Aug 28, 2001 at 12:56:50PM -0700, Barry Lind wrote:
> Thomas,
> 
> If you turn on debug messages on the server to print out the SQL 
> statements it receives you should be able to get the exact string that 
> the server is receiving from the client and failing on.  That might help 
> you find the problem.
> 
> thanks,
> --Barry
> 
> Thomas O'Dowd wrote:
> > Hi all,
> > 
> > I'm currently chasing down a bug. Wonder if anyone can throw some light
> > on it. I get the following exception.
> > 
> > An I/O error has occured while flushing the output - Exception: java.io.IOException: Connection reset by peer
> > Stack Trace:
> > 
> > java.io.IOException: Connection reset by peer
> > 	at java.net.SocketOutputStream.socketWrite(Native Method)
> > 	at java.net.SocketOutputStream.write(SocketOutputStream.java:83)
> > 	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72)
> > 	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:130)
> > 	at org.postgresql.PG_Stream.flush(PG_Stream.java:414)
> > 	at org.postgresql.Connection.ExecSQL(Connection.java:479)
> > 	at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
> > 	at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:78)
> > 	at org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:122)
> > 
> > 
> > And in the postgresql.log file I get...
> > 
> > ERROR:  Unterminated quoted string
> > FATAL 1:  Socket command type 
> >  unknown
> > 
> > But I'm pretty sure that my strings are quoted properly. That is to say that
> > there are about 90 escaped single quotes in a string I'm inserting also though.
> > 
> > Anyone seen this before? I'm currently using a version of the driver
> > that I compiled from cvs on the 18th of Jun. Was anything patched since
> > that might effect this?
> > 
> > Anyway, I've been digging around for quite a while now so I thought I'd
> > shoot the list a mail before going to bed.
> > 
> > Tom.
> > 
> 
> 

-- 
Thomas O'Dowd. - Nooping - http://nooper.com
tom(at)nooper(dot)com - Testing - http://nooper.co.jp/labs

In response to

Responses

pgsql-jdbc by date

Next:From: Thomas O'DowdDate: 2001-08-29 00:18:26
Subject: Re: Escape Processing problems
Previous:From: Bruce MomjianDate: 2001-08-28 23:35:02
Subject: Re: Re: Proposal to fix Statement.executeBatch()

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