commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rafael U\. C\. Afonso" <r.u.c.afo...@uol.com.br>
Subject Re: [DBUTILS] integer type not retrieve from the database
Date Wed, 02 Nov 2005 23:28:50 GMT
Hello:

Why don't you try use alias for your query:

SELECT id_delegation AS idDelegation, nom, departement, testint from
delegation order by departement asc

I would do this.

Tahnks,

Rafael U. C. Afonso

---------- InĂ­cio da mensagem original -----------

      De: "Thomas Manson" dev.mansonthomas@gmail.com
    Para: "Jakarta Commons Users List" commons-user@jakarta.apache.org
      Cc: 
    Data: Wed, 2 Nov 2005 15:37:45 +0100
 Assunto: Re: [DBUTILS] integer type not retrieve from the database

> 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 = "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
> >
> >
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 
> 

Rafael Ubiratam Clemente Afonso
r.u.c.afonso@uol.com.br
---------------------------------
Where is Debug?
Debug is on the Table!


---------------------------------------------------------------------
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