Re: Warnings

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Warnings
Date: 2004-05-15 06:23:47
Message-ID: 40A5B773.4030604@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Jeffrey Melloy wrote:
> When I attempt to pull the warning from a statement, and display it on
> the web, I'm getting some garbage at the beginning and end:
>
> SNOTICEC00000MQuery contains only stopword(s) or doesn't contain
> lexem(s), ignoredFrewrite.cL249Rclean_fakeval_v2
>
> While psql just gives "Notice: Query contains only stopwords or doesn't
> contain lexem(s), ignored
>
> Any help would be appreciated.

The "garbage" is the raw server-provided string for a 7.4 notification.
The latest 7.4 driver should turn this into a human-readable form when
creating SQLWarnings. This change went into CVS on Feb 16, so any driver
earlier than that will show the behaviour above. I suggest you upgrade
to the latest binary driver (build 213 on jdbc.postgresql.org) or
rebuild the driver from current CVS yourself.

-O

In response to

  • Warnings at 2004-05-15 00:04:27 from Jeffrey Melloy

Browse pgsql-jdbc by date

  From Date Subject
Next Message Simon Moses 2004-05-16 04:32:10 webserver(tomcat) with postgresql in linux OS required.
Previous Message Oliver Jowett 2004-05-15 06:16:10 Re: Are there any compatibility problem with using pg74jdbc3.jar