Re: [JDBC] Postgres Server Jdbc driver error

From: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
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 13:47:22
Message-ID: 4E3AA2EA.9010308@tech.sdb.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc pgsql-odbc

Il 04/08/2011 13.00, Oliver Jowett ha scritto:
> 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
>
thanks for the support, we find the bug in the application , we will
limt the number of parameters.

--
Silvio Brandani

---

Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei all'attività lavorativa o contrari a norme.
--

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2011-08-04 15:24:30 Re: BUG #6149: My table is empty but pg_relation_size(name) returns 39 MB
Previous Message Shivakumar Ramannavar 2011-08-04 11:16:04 BUG #6149: My table is empty but pg_relation_size(name) returns 39 MB

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruno Harbulot 2011-08-06 03:00:40 JDBC SSL hostname verification
Previous Message Oliver Jowett 2011-08-04 11:00:01 Re: [JDBC] Postgres Server Jdbc driver error

Browse pgsql-odbc by date

  From Date Subject
Next Message tamanna madaan 2011-08-18 09:34:25 "idle in transaction" postgres connection
Previous Message Oliver Jowett 2011-08-04 11:00:01 Re: [JDBC] Postgres Server Jdbc driver error