Re: Problemas with update sentence in postgres from 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)