Re: How to pass jsonb and inet arguments to a stored function with JDBC? - Mailing list pgsql-general

Thank you, David -

    PreparedStatement st = mDatabase.prepareStatement("SELECT out_uid FROM words_merge_users(?::jsonb, ?::inet)");

seems to work. Is it ok to call setString() then below?

        String str1 = JSON.toString(users);
        String str2 = mSession.getRemoteAddress().getAddress().getHostAddress();
        st.setString(1, str1);
        st.setString(2, str2);
       
        ResultSet rs = st.executeQuery();
        while (rs.next()) {

            System.out.println(rs.getString(1));
        }
        rs.close();
        st.close();