Re: pg_start_backup question

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(at)lelarge(dot)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
>