Re: pg_start_backup question - Mailing list pgsql-general

From db de
Subject Re: pg_start_backup question
Date
Msg-id 9530df370910301639r1262e2faqb831f2b5451c0026@mail.gmail.com
Whole thread Raw
In response to Re: pg_start_backup question  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: pg_start_backup question
Re: pg_start_backup question
List pgsql-general
Below is what I did:
I opened a super user connection to creat a super user statement. Then use the super user statement to execute "SELECT pg_start_backup('label')".

try
{
        superuserCont = java.sql.DriverManager.getConnection(URL, su, suPassword);
        suStatement = superuserCont.createStatement();
        boolean ret = suStatement.execute("SELECT pg_start_backup('label')");                                       //LINE1
}
catch(SQLException e)
{
         System.out.println("exception");                                                                                              //LINE2
}
finally
{
        System.out.println("ret:" + ret);                                                                                                //LINE3
}

After LINE1 is executed, LINE3 is run and the output is: ret:false. LINE2 is not executed.

Thanks.


Jack


On Fri, Oct 30, 2009 at 4:06 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
Le vendredi 30 octobre 2009 à 23:41:54, db de a écrit :
> How to execute "SELECT pg_start_backup('label');" from java as a SQL
> statement? I tries to use:
> Statement.execute("SELECT pg_start_backup('label')")
>
> But it does not work.
>

You should have an error message in your PostgreSQL logs. Without this, I
don't think we can help you.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Rewriting select statements
Next
From: Scott Marlowe
Date:
Subject: Re: Rewriting select statements