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

Postgres Server Jdbc driver error

From: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Postgres Server Jdbc driver error
Date: 2011-08-04 09:35:57
Message-ID: 4E3A67FD.10501@tech.sdb.it (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-jdbcpgsql-odbc
We get error with the following query where the paramater is 'att', the 
query return result if the parameter is different than 'att'.

Probably a bug.

the postgresql log is:

2011-08-04 10:44:56 CEST [28741]: [59238-1] LOG: execute S_1: BEGIN
2011-08-04 10:44:56 CEST [28741]: [59239-1] LOG: duration: 0.019 ms
2011-08-04 10:44:56 CEST [28741]: [59240-1] LOG: duration: 0.099 ms
2011-08-04 10:44:56 CEST [28741]: [59241-1] LOG: duration: 1.774 ms
2011-08-04 10:44:56 CEST [28741]: [59242-1] LOG: execute <unnamed>: 
select this_.trouble_ticket_id as y0_ from helpdesk.batch_sequences 
this_ where (this_.comment ilike $1 or this_.tech_note ilike $2)
2011-08-04 10:44:56 CEST [28741]: [59243-1] DETAIL: parameters: $1 = 
'%att%', $2 = '%att%'
2011-08-04 10:44:57 CEST [28741]: [59244-1] LOG: duration: 896.461 ms
2011-08-04 10:44:57 CEST [28741]: [59245-1] LOG: *incomplete message 
from client *
2011-08-04 10:44:57 CEST [28741]: [59246-1] LOG: disconnection: session 
time: 21:43:01.890 user=j01t02 database=webtng host=jblade01.sdb.it 
port=38173

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)


Any comment higly appreciated



-- 
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

Responses

pgsql-odbc by date

Next:From: Oliver JowettDate: 2011-08-04 11:00:01
Subject: Re: [JDBC] Postgres Server Jdbc driver error
Previous:From: McCaughey, Michael JDate: 2011-07-28 21:16:29
Subject: FW: Unicode error on WinXP x64

pgsql-bugs by date

Next:From: Oliver JowettDate: 2011-08-04 11:00:01
Subject: Re: [JDBC] Postgres Server Jdbc driver error
Previous:From: blammo72Date: 2011-08-04 09:31:36
Subject: Re: BUG #6120: Problem running post-install step in Mac OS X Lion (GM)

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2011-08-04 11:00:01
Subject: Re: [JDBC] Postgres Server Jdbc driver error
Previous:From: David FetterDate: 2011-08-03 16:56:52
Subject: Re: Copyright notices

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