Problemas with update sentence in postgres from jdbc

From: "Joksan Nempu Fernandez" <jnempu(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problemas with update sentence in postgres from jdbc
Date: 2008-04-04 23:06:12
Message-ID: d06c90a20804041606m64381805teeda35d1d2864c2b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi:

I try this ...

String sql ="UPDATE crupier "+
"SET c_estado='"+cestado+"' WHERE "+
" c_rut='"+crut+"' ";

and send me the next exception Error:

04-04-2008 07:00:03 PM Persistencia.Mesa ActualizarTupla
GRAVE: null
org.postgresql.util.PSQLException: ERROR: el valor de array debe comenzar
con «{» o información de dimensión
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)

I no t understand what happen in my code and i put the sql sentence in
pgadmin3 , i run this update and send me the same error.

Im using postgresql 8.3

THanx in advance.
--
Joksan Nempu Fernandez
Estudiante Ingeniería Civil en Computación e Informática.
Encargado del Laboratorio de Sistemas Distribuidos.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2008-04-05 05:13:41 Re: Problemas with update sentence in postgres from jdbc
Previous Message Albe Laurenz 2008-04-03 08:25:28 Re: CallableStatement and getUpdateCount