Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Problemas with ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 1919 of 1997
Post > Topic >>

Problemas with update sentence in postgres from jdbc

by jnempu@[EMAIL PROTECTED] ("Joksan Nempu Fernandez") Apr 4, 2008 at 07:06 PM

------=_Part_8103_28153804.1207350372358
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi:

I try this ...

String sql =3D"UPDATE crupier "+
                    "SET  c_estado=3D'"+cestado+"' WHERE "+
                    " c_rut=3D'"+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 =AB{=BB o informaci=F3n de dimensi=F3n
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutor=
Impl.java:1548)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.j=
ava: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(AbstractJdbc2S=
tatement.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.
--=20
Joksan Nempu Fernandez
Estudiante Ingenier=EDa Civil en Computaci=F3n e Inform=E1tica.
Encargado del Laboratorio de Sistemas Distribuidos.

------=_Part_8103_28153804.1207350372358
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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>
<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 =AB{=BB o
informaci=F3n=
 de dimensi=F3n<br>
&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.postgresql.core.v3.QueryExecutorImpl.execute(QueryE=
xecutorImpl.java:191)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.postgresql.jdbc2.Abstract=
Jdbc2Statement.execute(AbstractJdbc2Statement.java:452)<br>&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; at
org.postgresql.jdbc2.AbstractJdbc2Statement.e=
xecuteWithFlags(AbstractJdbc2Statement.java:337)<br clear=3D"all"><br>
I no t understand what happen in my code and i put the sql sentence in
pgad=
min3 , i run this update and send me the same error.<br><br>Im using
postgr=
esql 8.3<br><br>THanx in advance.<br>-- <br>Joksan Nempu
Fernandez<br>Estud=
iante Ingenier=EDa Civil en Computaci=F3n e Inform=E1tica.<br>
Encargado del Laboratorio de Sistemas Distribuidos.

------=_Part_8103_28153804.1207350372358--
 




 3 Posts in Topic:
Problemas with update sentence in postgres from jdbc
jnempu@[EMAIL PROTECTED]   2008-04-04 19:06:12 
Re: Problemas with update sentence in postgres from jdbc
craig@[EMAIL PROTECTED]   2008-04-05 13:13:41 
Re: Problemas with update sentence in postgres from jdbc
craig@[EMAIL PROTECTED]   2008-04-06 16:19:16 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 7:10:07 CDT 2008.