Обсуждение: Using INET types in prepared statements
Hi,
I am trying to create a prepared statement in JAVA via JDBC and one of the parameters I need to set in the SQL statement is of type INET. As there is no setInet() method how do I pass in the INET value into the sql statement?
I have tried this:
" WHERE b.ip = ?::inet"
But I get “org.postgresql.util.PSQLException: ERROR: cannot cast type character varying to inet”
I also tried
" WHERE b.ip = ?"
And I get “org.postgresql.util.PSQLException: ERROR: cannot cast type character varying to inet”
I really want to use prepared statement as I have to run this SQL statement over and over and it is supposed to be more efficient.
Can anyone help?
Cheers,
Nelson
"LITTLE Nelson" <nelson.little@tenix.com> writes:
> I am trying to create a prepared statement in JAVA via JDBC and one of
> the parameters I need to set in the SQL statement is of type INET. As
> there is no setInet() method how do I pass in the INET value into the
> sql statement?
You'd probably get a more informed response on the pgsql-jdbc list.
regards, tom lane