Postgres Pro
Downloads
Home   >   mailing lists

Using INET types in prepared statements in Java? - Mailing list pgsql-jdbc

From LITTLE Nelson
Subject Using INET types in prepared statements in Java?
Date
Msg-id 200706130558.l5D5wOl4031981@sprint2.tenix.com
Whole thread Raw
Responses Re: Using INET types in prepared statements in Java?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: Using INET types in prepared statements in Java?  (Thomas Burdairon <tburdairon@entelience.com>)
List pgsql-jdbc
Tree view

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

 

pgsql-jdbc by date:

Previous
From:
Date:
Subject: Error reporting issue in SimpleParameterList
Next
From: Achilleas Mantzios
Date:
Subject: Re: Using INET types in prepared statements in Java?