I had a similar problem and fixed it by using a preparedStatement and 
setting the parameter of my string data using

t.r. missner
level(3) communications

-----Original Message-----
From: Thomas O'Dowd [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 9:23 AM
Subject: [JDBC] Unterminated quoted string error.

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.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)

And in the postgresql.log file I get...

ERROR:  Unterminated quoted string
FATAL 1:  Socket command type 

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

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.

Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to