public class VariableInViewIssue {

    private static DataSource ds = JdbcConnectionPool.create("jdbc:h2:mem:test", "sa", "sa");

    public static void main(String[] args) throws SQLException {
        try (Connection conn = ds.getConnection()) {
            Statement stmt = conn.createStatement();
            stmt.execute(
                    "CREATE TABLE Book (ID INTEGER, title VARCHAR(30), PRIMARY KEY(ID))");
            stmt.execute(
                    "CREATE TABLE Book_texts (locale VARCHAR(14), ID INTEGER, title VARCHAR(30), PRIMARY KEY(locale, ID))");
            stmt.execute(
                    "CREATE VIEW localized_texts AS SELECT * FROM Book_texts WHERE locale = @LOCALE");

            stmt.execute("CREATE VIEW localized_Book AS "
                    + "SELECT b.ID, t.title AS title "
                    + "FROM (Book AS b LEFT JOIN Book_texts AS t ON t.ID = b.ID AND t.locale = @LOCALE)");

            stmt.execute("INSERT INTO Book (ID, title) VALUES (1, 'Book 1')");
            stmt.execute("INSERT INTO Book_texts (locale, ID, title) VALUES ('de', 1, 'Buch 1')");
            stmt.execute("INSERT INTO Book_texts (locale, ID, title) VALUES ('fr', 1, 'Libre 1')");
        }
        
        // 1st execution
        checkLocale("de");

        // 2nd execution
        checkLocale("fr");
    }

    private static void checkLocale(String locale) throws SQLException {
        try(Connection conn = ds.getConnection(); Statement stmt = conn.createStatement()) {
            System.out.println("setting @LOCALE to '" + locale + "'");
            stmt.execute("SET @LOCALE = '" + locale + "'");
            System.out.println("SELECT title, locale FROM localized_texts");
            try (ResultSet rs = stmt.executeQuery("SELECT title, locale FROM localized_texts")) {
                rs.next();
                
                System.out.println("title  : " + rs.getString(1));
                System.out.println("@LOCALE: " + rs.getString(2));
            }
            System.out.println("-----");
            
            System.out.println("SELECT title, locale FROM localized_Book");
            try (ResultSet rs = stmt.executeQuery("SELECT title, @LOCALE AS locale FROM localized_Book")) {
                rs.next();
                
                System.out.println("title  : " + rs.getString(1));
                System.out.println("@LOCALE: " + rs.getString(2));
            }
            System.out.println("\n");
        }
    }
}