Re: [GENERAL] JDBC and inet type

2015-12-07 Thread Tim Smith
Great, thanks! On 4 December 2015 at 12:17, Bill Moran wrote: > On Fri, 4 Dec 2015 09:41:24 + > Tim Smith wrote: > >> When I use "preparedStatement.setString(5,ip);" to send values to a >> stored function, it obviously gets sent to

Re: [GENERAL] JDBC and inet type

2015-12-04 Thread rob stone
On Fri, 2015-12-04 at 09:41 +, Tim Smith wrote: > 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

Re: [GENERAL] JDBC and inet type

2015-12-04 Thread Bill Moran
On Fri, 4 Dec 2015 09:41:24 + Tim Smith wrote: > 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

[GENERAL] JDBC and inet type

2015-12-04 Thread Tim Smith
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