Re: Getting vacuum results

It's funny.  Your test program works, but in my server I get this:

Got SQLException: Something unusual has occured to cause the driver to
fail. Please report this exception.

... and nothing else.

Kris Jurka wrote:
>
>
> On Thu, 1 Sep 2005, Joseph Shraibman wrote:
>
>> If I run VACUUM VERBOSE from jdbc, how do I get the output?  There are
>> no SQLWarnings attached to the resultset.
>>
>
> SQLWarnings are attached to the Statement because VACUUM does not
> produce a query result.  The attached test case shows this working fine
> for me.  The one complication is that vacuum puts out some of its
> interesting information in the Detail: part of the log message.  The
> JDBC driver doesn't normally put this information into the warning
> message, so you must either increase the loglevel URL parameter or use
> the 8.1 series and write pg specific code to access the individual
> fields of the ServerErrorMessage class.  We plan to increase the number
> of fields used to construct the error string to include the Detail
> field, but haven't gotten around to it yet.
>
> Kris Jurka
>
>
> ------------------------------------------------------------------------
>
> import java.sql.*;
>
> public class Vacuum {
>
>     public static void main(String args[]) throws Exception {
>         Class.forName("org.postgresql.Driver");
>         Connection conn =
DriverManager.getConnection("jdbc:postgresql://localhost:5432/jurka?loglevel=1","jurka","");
>         Statement stmt = conn.createStatement();
>         stmt.execute("VACUUM VERBOSE");
>         SQLWarning warn = stmt.getWarnings();
>         System.out.println(warn);
>         while (warn != null) {
>             warn = warn.getNextWarning();
>             System.out.println(warn);
>         }
>         stmt.close();
>         conn.close();
>     }
> }
>
>