Return-Path: 
 <user-java-return-11112-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 34112 invoked from network); 21 Mar 2007 12:25:22 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 21 Mar 2007 12:25:22 -0000
Received: (qmail 11470 invoked by uid 500); 21 Mar 2007 12:25:27 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 11413 invoked by uid 500); 21 Mar 2007 12:25:27 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 11402 invoked by uid 99); 21 Mar 2007 12:25:26 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 05:25:26 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=NO_REAL_NAME,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of andrew.kitchen@kattare.com
 designates 65.212.180.66 as permitted sender)
Received: from [65.212.180.66] (HELO sphinx-05.kattare.com) (65.212.180.66)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 05:25:17 -0700
Received: from localhost (pyramid-04.kattare.com [65.212.180.79])
	by sphinx-05.kattare.com (8.13.8/8.13.6) with ESMTP id l2LCOX0W017151;
	Wed, 21 Mar 2007 05:24:33 -0700
Received: from newton.ngfl.gov.uk (newton.ngfl.gov.uk [193.63.51.10])
	by www.kattare.com (IMP) with HTTP
	for <andrew.kitchen@localhost>; Wed, 21 Mar 2007 05:24:33 -0700
Message-ID: <1174479873.460124010ec5a@www.kattare.com>
Date: Wed, 21 Mar 2007 05:24:33 -0700
From: andrew.kitchen@kattare.com
To: user-java@ibatis.apache.org, Graeme J Sweeney <ibatis.user@gjsweeney.com>
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>
 <Pine.LNX.4.64.0703211205030.2979@localhost.localdomain>
In-Reply-To: <Pine.LNX.4.64.0703211205030.2979@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.2.8
X-Greylist: Sender IP whitelisted,
 not delayed by milter-greylist-1.4 (sphinx-05.kattare.com [65.212.180.66]);
 Wed, 21 Mar 2007 05:24:33 -0700 (PDT)
X-Kattare-MailScanner-Information: Please contact Kattare Support for more
 information
X-Kattare-MailScanner: Found to be clean
X-Kattare-MailScanner-SpamCheck: not spam, SpamAssassin (score=0.905,
	required 5, autolearn=disabled, AWL 0.35, NO_REAL_NAME 0.55)
X-MailScanner-From: andrew.kitchen@kattare.com
X-Virus-Checked: Checked by ClamAV on apache.org

OK - i'll have a look later today. One other interesting thing is this -
if I remove the lastLogin column from the query and the resultMap I get
this error - which seems to show that lastLogin is a red herring:

====

com.ibatis.dao.client.DaoException: Failed to execute queryForObject -
id [getUserByEmailAddress], parameterObject [<emailaddress removed>]. 
Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
uk/co/toydreams/shop/persistence/sqlmapdao/sql/User.xml.
--- The error occurred while applying a result map.
--- Check the User.userResult.
--- Check the result mapping for the 'activated' 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"
Caused by: java.text.ParseException: Unparseable date: "1975-01-15"
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error
setting properties of 'BaseObject [107, null, null, null]'.  Cause:
java.text.ParseException: Unparseable date: "1975-01-15"
Caused by: java.text.ParseException: Unparseable date: "1975-01-15"
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
uk/co/toydreams/shop/persistence/sqlmapdao/sql/User.xml.
--- The error occurred while applying a result map.
--- Check the User.userResult.
--- Check the result mapping for the 'activated' 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"
Caused by: java.text.ParseException: Unparseable date: "1975-01-15"
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error
setting properties of 'BaseObject [107, null, null, null]'.  Cause:
java.text.ParseException: Unparseable date: "1975-01-15"
Caused by: java.text.ParseException: Unparseable date: "1975-01-15"
	com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:153)
	uk.co.toydreams.shop.persistence.sqlmapdao.UserSqlMapDao.getUserByEmailAddress(UserSqlMapDao.java:37)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:585)
	com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:61)
	$Proxy11.getUserByEmailAddress(Unknown Source)
	uk.co.toydreams.shop.service.UserService.getUserByEmailAddress(UserService.java:59)
	uk.co.toydreams.shop.actions.user.UserActivateAction.execute(UserActivateAction.java:64)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

====

What could cause this? The resultMap isn't the cause as the same error
occurs if I use resultClass and map directly to my java object instead.

Thanks, Andrew






Quoting Graeme J Sweeney <ibatis.user@gjsweeney.com>:

> On Wed, 21 Mar 2007, andrew.kitchen@kattare.com wrote:
>
> > 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.
>
> The value is from the dob column but iBatis, according to the error,
> is
> assigning it to the lastLogin paramater (?).
>
> I would turn on all the logging and check what java.sql.* is sending
> and
> receiving.
>
> Something like this in log4j:
>
> log4j.logger.java.sql.Connection=DEBUG
> log4j.logger.java.sql.Statement=DEBUG
> log4j.logger.java.sql.PreparedStatement=DEBUG
> log4j.logger.java.sql.ResultSet=DEBUG
>
> Can you confirm both servers are running the same MySQL version?
> Check for another MySQL connector on the classpath.
>
> --
> Graeme -
>