Re: server-side prepared

Felipe Schnack wrote:

>   I just can't use server-side prepared statements
>   Here is a snippet of my sources, note that the column I'm inserting is
> of "bigint" data type
>   PreparedStatement prep = Connection.prepareStatement("insert into
> tablename values (?)");
>   prep.setNull(1, Types.BIGINT);
>   prep.executeUpdate();
>   For some strange reasons when I execute that I get the following
> error: "Column 'cpf' is of type BIGINT, but expression is of type text"
>   Well, I specified the BIGINT type correctly, What can I do?
>
>

Are you using the latest CVS release? I encountered this bug, too -
you'll probably find setting a non-null integer value works, but it
always thinks nulls are of type text. It was fixed in CVS a while ago,
but that version wasn't released with 7.3.0 or 7.3.1.

Scott