Postgres Pro
Downloads
Home   >   mailing lists

Re: Problemas with update sentence in postgres from jdbc - Mailing list pgsql-jdbc

From olarte.andres@gmail.com
Subject Re: Problemas with update sentence in postgres from jdbc
Date
Msg-id 3784406671207501583961@fastmobile.com
Whole thread Raw
In response to Problemas with update sentence in postgres from jdbc  ("Joksan Nempu Fernandez" <jnempu@gmail.com>)
List pgsql-jdbc
Tree view 
it seems you are trying to insert an int value in an array column. check your schema

---- Original Message ----
Hi:<br><br>I try this ...<br><br>String sql ="UPDATE crupier
"+<br>                   
"SET c_estado='"+cestado+"' WHERE
"+<br>                   
"c_rut='"+crut+"' ";<br>  
<br>and send me the next exception Error:<br><br>04-04-2008 07:00:03 PM Persistencia.Mesa ActualizarTupla<br>GRAVE:
null<br>org.postgresql.util.PSQLException:ERROR: el valor de array debe comenzar con «{» o información de dimensión<br>

        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)<br>       
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)<br>       
atorg...

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Problemas with update sentence in postgres from jdbc
Next
From: Craig Ringer
Date:
Subject: Re: Hibernate / other ORM and pg_advisory_lock