Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of dev.mansonthomas@gmail.com
 designates 66.249.82.199 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=NTP95R8WAiWRJPBnoFL737m+F8XgNUCMq/zFALHN+hkeSF3rBCfaZQrdVk3p3ftwVNJ0pKtUsYhLtdTbIR0s3pQhfUG1aksCmx1haR+BWtMLuk8oTiVr9iOYdntYSvlHroA4eJH4nhKsJPHrzTG+xTd3RgSljuZ3A9Xk3auhdpc=
Message-ID: <f43eb7e60511020637m12bbf687ie738842084b700aa@mail.gmail.com>
Date: Wed, 2 Nov 2005 15:37:45 +0100
From: Thomas Manson <dev.mansonthomas@gmail.com>
To: Jakarta Commons Users List <commons-user@jakarta.apache.org>
Subject: Re: [DBUTILS] integer type not retrieve from the database
In-Reply-To: <BAY102-F24EAFE2B9EA0AEA7F8871AC76E0@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <f43eb7e60511011647x4d1f7787n881dfdf31251f54e@mail.gmail.com>
	 <BAY102-F24EAFE2B9EA0AEA7F8871AC76E0@phx.gbl>

Well, i've already tried this : iddelegation, idDelegation. nothing will do=
.
Also, i've added a column that don't use the auto-increment feature
(juste to try) and it still doesn't work

Maybe integer in MySQL 5 metadata has changed?

On 11/2/05, Garth Patil <garthpatil@hotmail.com> wrote:
> try renaming the db field to idDelegation. i've never had success with
> underscores using dbutils.
> /garth
>
> >From: Thomas Manson <dev.mansonthomas@gmail.com>
> >Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
> >To: commons-user@jakarta.apache.org
> >Subject: [DBUTILS] integer type not retrieve from the database
> >Date: Wed, 2 Nov 2005 01:47:35 +0100
> >
> >Hi,
> >
> >I'm trying to use DBUtils (with DBCP) with Java 1.5 and MySQL5.
> >
> >
> >I make this query
> >
> >query =3D "SELECT idDelegation, nom, departement, testint from
> >delegation order by departement asc";
> >
> >on this table :
> >
> >CREATE TABLE `delegation` (
> >   `id_delegation` int(10) unsigned NOT NULL auto_increment,
> >   `nom` varchar(45) NOT NULL,
> >   `departement` varchar(8) NOT NULL,
> >   PRIMARY KEY  (`id_delegation`)
> >) ENGINE=3DInnoDB DEFAULT CHARSET=3Dlatin1;
> >
> >to be mapped with this object :
> >
> >public class DelegationDto
> >{
> >   private int idDelegation;
> >   private String  nom         ;
> >   private String  departement ;
> >   private int testint;
> >/*+Getter & Setter*/
> >}
> >
> >
> >(List)this.queryRunner.query(query, new
> >BeanListHandler(DelegationDto.class));
> >
> >The 2 String columns a retrieved, but not the integer one. I get 0 for
> >int and null for Integer type.
> >
> >Does any one have an idea? Why should it work with string and not with
> >integer? Bug??
> >
> >Thanks for help,
> >
> >Manson Thomas.
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: commons-user-help@jakarta.apache.org
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org