Re: Re: Unterminated quoted string error.

Hi Barry,

I looked in the postgresql documentation and couldn't find any mention
of a "bytea" type. Well actually, I found ..

$ grep -i bytea *
bki-commands.html:>bytea</TT
catalog-pg-proc.html:>bytea</TT
xfunc-c.html:>bytea</TD
xfunc-c.html:>(bytea *)</TD

but no real info on what it is, or no mention of it in the main types page.
Anyway, I think I'm fine for now, stipping the null chars from my data.

Tom.

On Tue, Aug 28, 2001 at 09:17:19PM -0700, Barry Lind wrote:
> 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
> >>
> >
>
>

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