PostgreSQL, Java : How to print jast the RAISE EXCEPTION message without info about the place in the code?

Question

This is my java method:

    public static boolean addEmployee(Employee employee) {
        String sql = "SELECT addemployee(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);";

        try (Connection conn = connect();
             PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setString(1, employee.getFirstName());
            .
            .
            .
            ps.execute();
            return true;
        } catch (SQLException e) {
            showMessageDialog(null, e.getMessage());
            System.out.println(e.getMessage());
        }
        return false;
    }

This is my PostgreSQL function:

CREATE OR REPLACE FUNCTION addEmployee(. . .)
    RETURNS BOOLEAN AS
$$
DECLARE
    existsCheck BOOLEAN;
    iddd        INTEGER;
BEGIN
    SELECT EXISTS(SELECT ed.username
                  FROM employee_data ed
                  WHERE ed.username = usernameAdd)
    INTO existsCheck;
    IF (SELECT existsCheck = FALSE) THEN
       .
       .
       .
    ELSE
        RAISE EXCEPTION 'Nazwa użytkownika jest zajęta!';
    END IF;
    RETURN TRUE;
END ;
$$

When the exception is thrown, I get such a message dialog: [image]

Error message is gotten when I try to register and the username I put already exists. So I get the alert "Username is taken by someone, try else" (1 line on the screenshot). And I want to print only these words, without this second line on the screenshot.

How can I get rid of this second line?

Error message is gotten when I try to register and the username I put already exists. So I get the alert "Username is taken by someone, try else" (1 line on the screenshot). And I want to print only these words, without this second line on the screenshot. — Hleb Shypula
– Hleb Shypula, Commented Jan 7, 2021 at 20:16

Hleb Shypula · Accepted Answer · 2021-02-24 19:45:02Z

0

Use String.split() to split tne exception message and print what needed.

answered Feb 24, 2021 at 19:45

Hleb Shypula

2041 gold badge2 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL, Java : How to print jast the RAISE EXCEPTION message without info about the place in the code?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related