Re: Strange error

Felipe,

Are you using prepared statements to do this?

Dave
On Thu, 2003-01-02 at 08:48, Felipe Schnack wrote:
>   I'm getting this very strange error. I'm setting the null to Types.NULL..
>
>  INSERT INTO PESSOAS (rg, cpf, nomepessoa, nascimento, sexo, email,
>  endereco,bairro, codcidade,codpessoa) VALUES (null, null, 'Arno João
>  Bosetti', null, 'M', null, 'Av. Prof. Oscar Pereira,1220  /908', 'Santo
>  Antonio',1,1)
>
>  java.sql.SQLException: ERROR:  column "cpf" is of type bigint but
>  expression is of type text
>      You will need to rewrite or cast the expression
>
>      at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:126)
>      at
>  org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:497)
>      at
>  org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
>      at
>  org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
>      at
>  org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
>      at
>  com.w2.login.daemons.UniversusImport.importPessoas(UniversusImport.java:238)
>
--
Dave Cramer <Dave@micro-automation.net>