Re: How to pass jsonb and inet arguments to a stored function with JDBC?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

​Please don't top-post.

On Tue, Jun 14, 2016 at 10:44 AM, Alexander Farber <alexander.farber@xxxxxxxxx> wrote:

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();

​

​I don't understand the question...​

​David J.​

​