Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group