commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Norris Shelton <norrisshel...@yahoo.com>
Subject Re: [DBUTILS] integer type not retrieve from the database
Date Tue, 13 Dec 2005 21:40:32 GMT
Is there going to be a 1.1 release?

David Graham <grahamdavid1980@yahoo.com> wrote: Download the latest nightly DbUtils
build and give it a try.  The code in
1.0 was not very smart about mapping database datatypes to Java datatypes.

http://jakarta.apache.org/commons/dbutils/downloads.html

David


--- "Rafael U. C. Afonso"  wrote:

> 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  wrote:
> > > try renaming the db field to idDelegation. i've never had success
> with
> > > underscores using dbutils.
> > > /garth
> > >
> > > >From: Thomas Manson 
> > > >Reply-To: "Jakarta Commons Users List"
> 
> > > >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
> 
> 


Get Firefox!
http://www.mozilla.org/firefox/


 
  
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

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






Norris Shelton
Software Engineer
Sun Certified Java 1.1 Programmer
Appriss, Inc.
ICQ# 26487421
AIM NorrisEShelton
YIM norrisshelton

			
---------------------------------
Yahoo! Shopping
 Find Great Deals on Holiday Gifts at Yahoo! Shopping 
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message