Re: Problemas with update sentence in postgres from jdbc

it seems you are trying to insert an int value in an array column. check
yo=
ur schema

---- Original Message ----
Hi:<br><br>I try this ...<br><br>String sql =3D&quot;UPDATE crupier
&quot;+=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;SET&nbsp;
c_estado=3D&#39=
;&quot;+cestado+&quot;&#39; WHERE
&quot;+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; &quot; c_rut=3D&#39;&quot;+crut+&quot;&#39; &quot;;<br>=20
<br>and send me the next exception Error:<br><br>04-04-2008 07:00:03 PM
Per=
sistencia.Mesa ActualizarTupla<br>GRAVE:
null<br>org.postgresql.util.PSQLEx=
ception: ERROR: el valor de array debe comenzar con =C2=AB{=C2=BB o
informa=
ci=C3=B3n de dimensi=C3=B3n<br>=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.postgresql.core.v3.QueryE=
xecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)<br>&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.postgresql.core.v3.QueryExecutorImp=
l.processResults(QueryExecutorImpl.java:1316)<br>&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp; at org...

--=20
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc