Re: Problem with loginTimeout

From: Nicolas Vervelle <nicolas(dot)vervelle(at)steria(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with loginTimeout
Date: 2007-02-13 07:08:59
Message-ID: 45D1640B.3020904@steria.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2007-02-13 12:24:53 Re: Problem with loginTimeout
Previous Message Heikki Linnakangas 2007-02-12 16:46:07 Re: Problem with loginTimeout