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

Re: Problemas with update sentence in postgres from jdbc

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Joksan Nempu Fernandez <jnempu(at)gmail(dot)com>,pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problemas with update sentence in postgres from jdbc
Date: 2008-04-06 08:19:16
Message-ID: 47F88784.4090209@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-jdbc
Joksan Nempu Fernandez wrote:
> Hi , thanx for answer me, well here is the sql string that i send from my
> web app. Im using a context connection for the pool in tomcat.

In future I recommend replying to the mailing list, not just to me, so
that everybody can read your message. I was telling you that you should
send more information so that *everybody* on the list would have more
chance of helping you.

As it happens your query string does not explain the problem, so:

Please set:
	log_statement = 'all'
in your postgresql.conf, restart postgresql, and run your problem query
again. Look in the postgresql logs and find the query. Then include the
full text of the query as shown in PostgreSQL's logs, as well as the
following error message, in your reply.

Please also include the output of running "\d mesa" in psql. Without
being able to see your schema it is hard to tell what is going on.

I've left your statement included below.

> AbrirMesa: abriendo mesa...
> update mesa set  m_col1=1 , m_col2=2 , m_col3=3 , m_col4=4 , m_col5=5 ,
> m_col6=6 , m_col7=7 , m_col8=8 , m_col9=9 , m_col10=10 , m_col11=11 ,
> m_col12=12 , m_col13=13 , m_col14=0 , m_col15=0 , m_col16=0 ,
> m_estado='abierta' where m_cod='2'
> Mesa: AT ERROR:ERROR: el valor de array debe comenzar con «{» o información
> de dimensión
> AbrirMesa: mesa cerrada...
> 05-04-2008 01:15:46 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)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236)
>         at
> org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
>         at Persistencia.Mesa.ActualizarTupla(Mesa.java:207)
>         at Persistencia.Supervisor.abrirMesa(Supervisor.java:186)
>         at controladores.AbrirMesa.processRequest(AbrirMesa.java:46)
>         at controladores.AbrirMesa.doGet(AbrirMesa.java:67)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

In response to

pgsql-jdbc by date

Next:From: olarte.andresDate: 2008-04-06 17:06:23
Subject: Re: Problemas with update sentence in postgres from jdbc
Previous:From: Craig RingerDate: 2008-04-05 05:13:41
Subject: Re: Problemas with update sentence in postgres from jdbc

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