Date: Mon, 20 Nov 2017 05:52:21 -0700 (MST)
From: queralt <queraltr@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1511182341138-0.post@n3.nabble.com>
In-Reply-To: 
 <CAFj8pRDY5s3itezU9r4Y6TAh+NPGxLjMmnTZgaeq6ibpXfy2wg@mail.gmail.com>
References: <1510654656203-0.post@n3.nabble.com>
 <CAFj8pRDY5s3itezU9r4Y6TAh+NPGxLjMmnTZgaeq6ibpXfy2wg@mail.gmail.com>
Subject: Re: Line number returned in Postgres Raise Exception sentence
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org


We have found another solution from JDBC. 
We do a catch of SQLException, then we cast the exception to PSQLException
and then we obtain the ServerErrorMessage.
In this ServerErrorMessage the getMessage() returns just the text of the
error message of the Stored Procedure we execute from the try code.
Previously, we set the server log to Terse (set log_error_verbosity=terse).

catch (SQLException se)
	   {
		System.out.println("ServerErrorMessage");
		PSQLException ps = (PSQLException)se;
		ServerErrorMessage sem = ps.getServerErrorMessage();
		System.out.println(sem.getMessage());  
	   }
  }


--
Sent from: http://www.postgresql-archive.org/PostgreSQL-sql-f2142323.html


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql