| From: | Felipe Schnack <felipes(at)ritterdosreis(dot)br> |
|---|---|
| To: | pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | server-side prepared |
| Date: | 2003-01-08 18:34:41 |
| Message-ID: | 1042050881.11829.97.camel@desenv1.ritterdosreis.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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?
--
Felipe Schnack
Analista de Sistemas
felipes(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893
Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter(at)ritterdosreis(dot)br
Fone/Fax.: (51)32303341
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Candis Thomas | 2003-01-08 18:37:40 | Re: JDBC Driver -- getImportedKeys |
| Previous Message | Abel Muiño | 2003-01-08 17:26:22 | Deletion of Large Objects (was Re: [Re: JDBC compliance]) |