Re: Problem with loginTimeout - Mailing list pgsql-jdbc

From Nicolas Vervelle
Subject Re: Problem with loginTimeout
Date
Msg-id 45D1640B.3020904@steria.com
Whole thread Raw
In response to Re: Problem with loginTimeout  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-jdbc
Heikki Linnakangas wrote:
> Nicolas Vervelle wrote:
>> I tried updating to the latest JDBC driver (8.2 build 504), and the
>> problem seems to be fixed.
>> But then I am getting errors with my EJB Entities when trying to
>> create new instances :
>> Could not create entity
>> org.postgresql.util.PSQLException: ERROR: column
>> "tab_alarme_emis_pcc" is of type boolean but expression is of type
>> character
>> The corresponding field is defined as :
>> - in the EJB entity: with
>>     @ejb.persistence column-name="TAB_ALARME_EMIS_PCC"
>>     public abstract Boolean getEmisPcc();
>> - in the database: with tab_alarme_emis_pcc boolean
>
> It seems there's a problem in your EJB container or mapping etc.
> causing it to send booleans as CHARs instead.
>
>> What is the problem ? Please help.
>> Is there a global setting to have the pgdriver behaving as it was in
>> 7.4 ?
>
> Try protocolVersion=2, see
> http://jdbc.postgresql.org/documentation/82/connect.html#connection-parameters
>
>
Thanks,

protocolVersion=2 in the datasource configuration fixed the problem.

Nicolas



pgsql-jdbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Problem with loginTimeout
Next
From: Dave Cramer
Date:
Subject: Re: Problem with loginTimeout