Re: Unterminated quoted string error.

Thats exactly what I'm doing :) My preparedStatement is like. You'll
notice its a PreparedStatement if you look at the stack trace below.

con.prepareStatement("INSERT INTO A VALUES(?)");
ps.setString(1, stringdata);
ps.executeUpdate();

I'm wondering is it a length problem since the field is type text and
the string is length 42,460.

Any ideas?

Tom.

On Tue, Aug 28, 2001 at 11:18:25AM -0600, T(dot)R(dot)Missner(at)level3(dot)com wrote:
> I had a similar problem and fixed it by using a preparedStatement and
> setting the parameter of my string data using
> myPreparedStatement.setString(myString)
>
>
> t.r. missner
> level(3) communications
>
> -----Original Message-----
> From: Thomas O'Dowd [mailto:tom(at)nooper(dot)com]
> Sent: Tuesday, August 28, 2001 9:23 AM
> To: pgsql-jdbc(at)postgresql(dot)org
> 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.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

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