Is there going to be a 1.1 release? David Graham <[EMAIL PROTECTED]> 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" [EMAIL PROTECTED] > Para: "Jakarta Commons Users List" [email protected] > 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: [email protected] > > > >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: [EMAIL PROTECTED] > > > >For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > Rafael Ubiratam Clemente Afonso > [EMAIL PROTECTED] > --------------------------------- > Where is Debug? > Debug is on the Table! > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Get Firefox! http://www.mozilla.org/firefox/ __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] 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
