Re: [JDBC] Postgres Server Jdbc driver error

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Postgres Server Jdbc driver error
Date: 2011-08-04 11:00:01
Message-ID: CA+0W9LOjLY6SfGMpAx3mzUaBZ53n7E09DkczeidaVarPxna=5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc pgsql-odbc

2011/8/4 Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>:

> On the Tomcat side we get followin message:
>
>
> Caused by: java.io.IOException: Tried to send an out-of-range integer as a
> 2-byte value: 34027
> at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201)
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:1236)
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1508)
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1097)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

What is the query that triggers this exception? (Not the one logged on
the server side, it is the next query that's the problem)
Taking the exception at face value implies that your query has 34,027
parameters, which seems somewhat unlikely (!!) unless you have a badly
garbled query string.

Oliver

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shivakumar Ramannavar 2011-08-04 11:16:04 BUG #6149: My table is empty but pg_relation_size(name) returns 39 MB
Previous Message Silvio Brandani 2011-08-04 09:35:57 Postgres Server Jdbc driver error

Browse pgsql-jdbc by date

  From Date Subject
Next Message Silvio Brandani 2011-08-04 13:47:22 Re: [JDBC] Postgres Server Jdbc driver error
Previous Message Silvio Brandani 2011-08-04 09:35:57 Postgres Server Jdbc driver error

Browse pgsql-odbc by date

  From Date Subject
Next Message Silvio Brandani 2011-08-04 13:47:22 Re: [JDBC] Postgres Server Jdbc driver error
Previous Message Silvio Brandani 2011-08-04 09:35:57 Postgres Server Jdbc driver error