Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: Dave CramerDate: 2007-02-13 12:24:53
Subject: Re: Problem with loginTimeout
Previous:From: Heikki LinnakangasDate: 2007-02-12 16:46:07
Subject: Re: Problem with loginTimeout

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group