commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Graham <grahamdavid1...@yahoo.com>
Subject Re: DbUtils question
Date Wed, 03 Dec 2003 18:49:58 GMT
Try BigInteger.  I think the problem you're experienceing is what caused
other people to suggest smarter bean handling for 1.1.  You might try a
1.1 nightly build to see if that works.

David

--- Emerson Cargnin <emerson@tre-sc.gov.br> wrote:
> forgot to insert the sql :)
> 
> David Graham wrote:
>  > --- Emerson Cargnin <emerson@tre-sc.gov.br> wrote:
>  >
>  >>It looks that my problem is with oracle number fields. WHat's the
>  >>mapping for bean and database types?
>  >
>  >
>  > DbUtils 1.0 performs a very simple mapping: If the column type 
> matches the
>  > bean type exactly, the setter will be called.  We have added an
>  > enhancement to be released with 1.1 that performs a more useful
> mapping.
>  > We will also make changes to BasicRowProcessor to make customized 
> mappings
>  > easier to implement.
>  >
>  > Also see the javadoc:
>  > 
>
http://jakarta.apache.org/commons/dbutils/apidocs/org/apache/commons/dbutils/BasicRowProcessor.html#toBean(java.sql.ResultSet,%20java.lang.Class)
>  >
> 
> Ok, I'm having a problem :
> 
> I have a bean that has getIdEmpresa/setIdEmpresa methods.
> My sql is:
> 
> "SELECT id_empresa as idEmpresa , Nom_empresa as nome ,Num_tel_empresa 
> as telefone , fax, des_endereco as endereco , nom_bairro as bairro , 
> cep, email, razao, id_tipo as idTipo , sgl_uf as uF
> FROM empresa
>   WHERE id_empresa=?"
> 
> It happens that all fields are properly populated, except ones that had
> number (oracle) as the type of the field.
> 
> I tried to change my bean field to int or Integer, still not working.
> Should I use long for oracle number type ?
> 
>  >
>  >>As a suggestion, for the subject of naming mappings, dbutils could
> try
>  >>to map getAttName bean method to att_name database field.
>  >
>  >
>  > DbUtils will not perform this kind of custom mapping.  You can either
> use
>  > an SQL "AS" or write a custom RowProcessor implementation.
>  >
> Now it doesn't work this way, you mean that it's not a good idea to be
> implemented in a future version? I think that this way (not excluding
> the way it works now) would be less intrusive in the sql's people have
> already, and since the filed_name being the pattern that is most used
> for filed names, it could avoid changing sql's to adapt to the DbUtils
> framework.
> 
>  > David
>  >
>  >
>  >>David Graham wrote:
>  >>
>  >>>--- Emerson Cargnin <emerson@tre-sc.gov.br> wrote:
>  >>>
>  >>>
>  >>>>I'm giving my first steps into dbutils, and i'd like to make a
>  >>>
>  >>question,
>  >>
>  >>>>since the docs are still  small:
>  >>>>
>  >>>>What's the mapping from the db field names and the get/set
> properties
>  >>>
>  >>of
>  >>
>  >>>>my bean (the one sent to the sqlrunner).
>  >>>>
>  >>>>an example :
>  >>>>
>  >>>>if I have a sql command
>  >>>>select * from mytable
>  >>>>
>  >>>>my table has two fields :
>  >>>>
>  >>>>id
>  >>>>id_othertable
>  >>>>
>  >>>>What's are the allowed get/set mapping to get the bean with all the
>  >>>>properties of the resultset.
>  >>>>
>  >>>>it can translate from id_company to setCompany ?? or I have to use
> the
>  >>>
>  >>>>'as', modifying all the sql's?
>  >>>
>  >>>
>  >>>You should use an SQL "AS" to change the column names to match your
>  >>
>  >>bean
>  >>
>  >>>property names.  Your id column would call setId() on your bean. 
> I'm
>  >>
>  >>not
>  >>
>  >>>sure about id_othertable because it contains an underscore but it
>  >>
>  >>should
>  >>
>  >>>call setId_othertable.
>  >>>
>  >>>David
>  >>>
>  >>>
>  >>>
>  >>>>Anyone could show me some complete examples???
>  >>>>
>  >>>>Thanks and congratulation for this excellent tool.
>  >>>>
>  >>>>
>  >>>>--
>  >>>>Emerson Cargnin
>  >>>>Analista de Sistemas
>  >>>>Setor de Desenvolvimento de Sistemas - TRE-SC
>  >>>>tel : (048) - 251-3700 - Ramal 3181
>  >>>>
>  >>>>
> 
>
>>>>---------------------------------------------------------------------
>  >>>>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>  >>>>For additional commands, e-mail:
> commons-user-help@jakarta.apache.org
>  >>>>
>  >>>
>  >>>
>  >>>
>  >>>__________________________________
>  >>>Do you Yahoo!?
>  >>>Free Pop-Up Blocker - Get it now
>  >>>http://companion.yahoo.com/
>  >>>
> 
> >>>---------------------------------------------------------------------
>  >>>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>  >>>For additional commands, e-mail:
> commons-user-help@jakarta.apache.org
>  >>>
>  >>>
>  >>
>  >>
>  >>--
>  >>Emerson Cargnin
>  >>Analista de Sistemas
>  >>Setor de Desenvolvimento de Sistemas - TRE-SC
>  >>tel : (048) - 251-3700 - Ramal 3181
>  >>
>  >>
>  >>---------------------------------------------------------------------
>  >>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>  >>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>  >>
>  >
>  >
>  >
>  > __________________________________
>  > Do you Yahoo!?
>  > Free Pop-Up Blocker - Get it now
>  > http://companion.yahoo.com/
>  >
>  > ---------------------------------------------------------------------
>  > To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>  > For additional commands, e-mail: commons-user-help@jakarta.apache.org
>  >
>  >
> 
> 
> -- 
> Emerson Cargnin
> Analista de Sistemas
> Setor de Desenvolvimento de Sistemas - TRE-SC
> tel : (048) - 251-3700 - Ramal 3181
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

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