Horton

Thread

  1. Postgres Server Odbc driver compatibility matrix

    Silvio Brandani <silvio.brandani@tech.sdb.it> — 2011-05-18T08:51:15Z

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

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

  2. Re: Postgres Server Odbc driver compatibility matrix

    Hiroshi Inoue <inoue@tpf.co.jp> — 2011-05-18T18:34:48Z

    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.

  3. Re: Postgres Server Odbc driver compatibility matrix

    Silvio Brandani <silvio.brandani@tech.sdb.it> — 2011-05-19T07:34:44Z

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

  4. Re: Postgres Server Odbc driver compatibility matrix

    Hiroshi Inoue <inoue@tpf.co.jp> — 2011-05-19T09:07:12Z

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

> regards,

  5. Re: Postgres Server Odbc driver compatibility matrix

    Hiroshi Inoue <inoue@tpf.co.jp> — 2011-05-19T21:51:52Z

    (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

  6. Re: Postgres Server Odbc driver compatibility matrix

    Silvio Brandani <silvio.brandani@tech.sdb.it> — 2011-05-20T07:48:21Z

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

  7. Postgres Server Jdbc driver error

    Silvio Brandani <silvio.brandani@tech.sdb.it> — 2011-08-04T09:35:57Z

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

  8. Re: [JDBC] Postgres Server Jdbc driver error

    Oliver Jowett <oliver@opencloud.com> — 2011-08-04T11:00:01Z

    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

  9. Re: [JDBC] Postgres Server Jdbc driver error

    Silvio Brandani <silvio.brandani@tech.sdb.it> — 2011-08-04T13:47:22Z

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