JDBC and inet type

From: Tim Smith <randomdev4+postgres(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: JDBC and inet type
Date: 2015-12-04 09:41:24
Message-ID: CA+HuS5Hk=rxq7do0J9AeTcXkMz2WwU-zHkHK3AKF_7k+eg2BxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

When I use "preparedStatement.setString(5,ip);" to send values to a
stored function, it obviously gets sent to postgres as "character
varying".

Postgres obviously complains loudly and says " Hint: No function
matches the given name and argument types. You might need to add
explicit type casts.".

What is the appropriate workaround ?

Thanks!

Tim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2015-12-04 10:15:34 Re: plperlu stored procedure seems to freeze for a minute
Previous Message Andreas Kretschmer 2015-12-04 06:49:35 Re: BDR: ALTER statement hanging