Re: Re: Unterminated quoted string error.

Thomas,

The text datatypes in postgres (i.e. char, varchar, text) do not support
storing null characters. If your data contains nulls then you need to
use the binary datatype bytea. Unfortunately the JDBC drivers do not
currently support the bytea datatype.

thanks,
--Barry

Thomas O'Dowd wrote:
> I found problem. My string has a null character in the middle of it. I
> noticed from the Connection.java code that the null character idicates
> end of query so I guess that is what is happening. I'll strip out my
> null strings in the mean time as they are not needed before sending them
> to the driver but I'm wondering if the preparedStatement.setString()
> shouldn't escape nulls or something. It already escapes single quotes and
> backslashes. What do people think?
>
> Cheers,
>
> Tom.
>
> On Wed, Aug 29, 2001 at 08:53:31AM +0900, Thomas O'Dowd wrote:
>
>>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
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>>
>