commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Garth Patil" <garthpa...@hotmail.com>
Subject RE: [DBUTILS] integer type not retrieve from the database
Date Wed, 02 Nov 2005 01:11:28 GMT
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 = "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=InnoDB DEFAULT CHARSET=latin1;
>
>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


Mime
View raw message