The server is on high load and produces approx 1GB of statement logs every 3 days. And as I said, it happens very
veryrarely (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
statementswith 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@xythos.com]
> Sent: Monday, April 14, 2003 19:04
> To: Alexey Yudichev
> Cc: pgsql-jdbc@postgresql.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@postgresql.org
> >
>
>
>
>