Re: unterminated quoted string

The server is on high load and produces approx 1GB of statement logs every 3 days. And as I said, it happens very very rarely (last time I saw it was 2 months ago and then two days ago again). Is there any way to turn on only log of statements with errors? Or maybe is there any way to turn on debug logging on the side of the driver?

> -----Original Message-----
> From: Barry Lind [mailto:blind(at)xythos(dot)com]
> Sent: Monday, April 14, 2003 19:04
> To: Alexey Yudichev
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] unterminated quoted string
>
>
> Alexey,
>
> If you had statement logging turned on on the server you
> would see the
> exact sql statement that the server was complaining about.
> That would
> be very useful to know.
>
> thanks,
> --Barry
>
>
> Alexey Yudichev wrote:
> > Having the code
> >
> > String SQL = "SELECT COUNT(*) FROM Destination WHERE
> address=?";
> > st = conn.prepareStatement(SQL);
> > st.setString(1, address);
> > rs = st.executeQuery();
> >
> > and if address is an empty string, sometimes (very rarely) i get
> >
> > java.sql.SQLException: ERROR: Unterminated quoted string
> >
> > at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
> > at org.postgresql.Connection.ExecSQL(Connection.java:398)
> > at
> org.postgresql.jdbc2.Statement.execute(Statement.java:130)
> > at
> org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
> > at
> org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedSt
> atement.java:99)
> >
> > I use PostgreSQL 7.1 and PostgreSQL 7.2 driver with
> "compatible=7.1" option.
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
> >
>
>
>
>