Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of mailtolanger@googlemail.com
 designates 209.85.134.191 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=beta;
        h=received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding;
        b=emLv2CMBNBckOp6K3j4oeLqSL1Oj5UcQtZPK88B+DB0KTXfw6tqlq458KGnpy82U2I/EB84jHs0wKKpYQDiyiLkC/IA6UrucNZFrfOsxqBrG1nstyLFNaNteG71rcgpV91S16QD6oYK3L4AYuI4njV+oXXll4wrJAqV/YfUxFCY=
Message-ID: <46011A79.6020209@googlemail.com>
Date: Wed, 21 Mar 2007 12:43:53 +0100
From: Stefan Langer <mailtolanger@googlemail.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Locale problems?
References: <1174380934.45ffa186775ff@www.kattare.com>
 <a10a823c0703200440r4f548185u77953e0aa24348f3@mail.gmail.com>
 <1174394817.45ffd7c17e0b6@www.kattare.com>
 <Pine.LNX.4.64.0703201302070.7764@localhost.localdomain>
 <1174404468.45fffd74273cc@www.kattare.com>
 <Pine.LNX.4.64.0703201613350.9019@localhost.localdomain>
 <1174408993.46000f21b96ca@www.kattare.com>
 <Pine.LNX.4.64.0703201657090.9200@localhost.localdomain>
 <1174412715.46001dab17ece@www.kattare.com>
 <Pine.LNX.4.64.0703211008330.2368@localhost.localdomain>
 <1174476522.460116ea1b99b@www.kattare.com>
In-Reply-To: <1174476522.460116ea1b99b@www.kattare.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

andrew.kitchen@kattare.com schrieb:
> Hi Greame,
>
> Thanks for your efforts again.
>
>   
>>> --- Check the result mapping for the 'lastLogin' property.
>>> --- Cause: com.ibatis.common.exception.NestedRuntimeException:
>>>       
>> Error
>>     
>>> setting properties of 'BaseObject [107, null, null, null]'.  Cause:
>>> java.text.ParseException: Unparseable date: "1975-01-15"
>>>       
>> According to this 'lastLogin' is of type 'datetime' but is
>> receiving a 'date' formatted result which  means it's receiving
>> the wrong column value when deployed on the remote server.
>>     
>
> I think the two errors are unconnected. The unparseable 'date' shown is
> from the dob column not the lastLogin column. I think that is a red
> herring. I have no idea why 'lastLogin' is causing an issue as well.
>
>
>   
>> I can't see why this would help since User.userResult has column
>> mapping but change
>>
>>     
>>>  <statement id="getUserByEmailAddress" resultMap="userResult"
>>> parameterClass="string">
>>>    select * from User where emailAddress = #value#
>>>  </statement>
>>>       
>> to
>>
>> select id, title, firstName, lastName, gender, dob, telephoneNumber,
>> emailAddress, password, newsletter, preferredCurrency, activationKey,
>> activated, lastLogin  from User where emailAddress = #value#
>>     
>
> You are right - no effect when the change made I'm afraid :-(
>
> Back to the drawing board again I think. I appreciate your help here -
> thanks again!
>
> Andrew
Have you actually looked at the data the jdbc driver gives you from your 
database?
DO this for both servers and compare. Maybe the issue lies somewhere 
between iBatis and the Database.

Regards
Stefan