Postgres Server Odbc driver compatibility matrix

Hi Silvio,

(2011/05/18 17:51), Silvio Brandani wrote:

Hi,

where can I found the compatibility matrix between Postgresql server and
odbc drivers ??

we are going to upgrade our production databases to 9.0.2 and we get
problems with new odbc drivers 9.0.x .

What kind of problems are you seeing?

regards,
Hiroshi Inoue

Il 18/05/2011 20.34, Hiroshi Inoue ha scritto:

Hi Silvio,

(2011/05/18 17:51), Silvio Brandani wrote:

Hi,

where can I found the compatibility matrix between Postgresql server and
odbc drivers ??

we are going to upgrade our production databases to 9.0.2 and we get
problems with new odbc drivers 9.0.x .

What kind of problems are you seeing?

regards,
Hiroshi Inoue

So we need to know if the "old" 8.3 or 8.4 drivers are still working
from new postgres server version.

any comment higly appreciated.

We have problems using visual fox pro views to postgres through odbc
driver 9.0.x but it works with driver 8.4.x

regards,

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

(2011/05/19 16:34), Silvio Brandani wrote:

Il 18/05/2011 20.34, Hiroshi Inoue ha scritto:

Hi Silvio,

(2011/05/18 17:51), Silvio Brandani wrote:

Hi,

where can I found the compatibility matrix between Postgresql server and
odbc drivers ??

we are going to upgrade our production databases to 9.0.2 and we get
problems with new odbc drivers 9.0.x .

What kind of problems are you seeing?

regards,
Hiroshi Inoue

So we need to know if the "old" 8.3 or 8.4 drivers are still working
from new postgres server version.

any comment higly appreciated.

We have problems using visual fox pro views to postgres through odbc
driver 9.0.x but it works with driver 8.4.x

Unfortunately I don't have a fox pro environemnt.
Could you please tell me a concrete information?

(2011/05/19 18:40), Silvio Brandani wrote:

Il 19/05/2011 11.07, Hiroshi Inoue ha scritto:

(2011/05/19 16:34), Silvio Brandani wrote:

Il 18/05/2011 20.34, Hiroshi Inoue ha scritto:

Hi Silvio,

(2011/05/18 17:51), Silvio Brandani wrote:

Hi,

<snip>

We have problems using visual fox pro views to postgres through odbc
driver 9.0.x but it works with driver 8.4.x

Unfortunately I don't have a fox pro environemnt.
Could you please tell me a concrete information?

regards,

The problem is on foxpro remote view , we define a remote view on:

SELECT * FROM gen_param Gen_param WHERE Gen_param.tipo_par = E'INVOICE'
AND Gen_param.cod_par = E'DRAFT' AND Gen_param.azienda = E'60 '

and we do not get any results ( no errors message no warning)

with driver 8.4 we get the results.

In attach the odbc logs

Thanks.
It will take some time to fix the bug.

Anyway please try to turn on the *Server side prepare* option.

regards,
Hiroshi Inoue

Il 19/05/2011 23.51, Hiroshi Inoue ha scritto:

(2011/05/19 18:40), Silvio Brandani wrote:

Il 19/05/2011 11.07, Hiroshi Inoue ha scritto:

(2011/05/19 16:34), Silvio Brandani wrote:

Il 18/05/2011 20.34, Hiroshi Inoue ha scritto:

Hi Silvio,

(2011/05/18 17:51), Silvio Brandani wrote:

Hi,

<snip>

We have problems using visual fox pro views to postgres through odbc
driver 9.0.x but it works with driver 8.4.x

Unfortunately I don't have a fox pro environemnt.
Could you please tell me a concrete information?

regards,

The problem is on foxpro remote view , we define a remote view on:

SELECT * FROM gen_param Gen_param WHERE Gen_param.tipo_par = E'INVOICE'
AND Gen_param.cod_par = E'DRAFT' AND Gen_param.azienda = E'60 '

and we do not get any results ( no errors message no warning)

with driver 8.4 we get the results.

In attach the odbc logs

Thanks.
It will take some time to fix the bug.

Anyway please try to turn on the *Server side prepare* option.

regards,
Hiroshi Inoue

Turning on the " server side prepare ", it works .

thanks a lot.

Anyway, can we use the 8.4 driver with 9.x servers or is not compatible??

regards,

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

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

2011/8/4 Silvio Brandani <silvio.brandani@tech.sdb.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

Il 04/08/2011 13.00, Oliver Jowett ha scritto:

2011/8/4 Silvio Brandani<silvio.brandani@tech.sdb.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.
--