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