David Graham wrote:
> --- Emerson Cargnin <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >>>>For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>> >>> >>> >>>__________________________________ >>>Do you Yahoo!? >>>Free Pop-Up Blocker - Get it now >>>http://companion.yahoo.com/ >>> >>>--------------------------------------------------------------------- >>>To unsubscribe, e-mail: [EMAIL PROTECTED] >>>For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >> >> >>-- >>Emerson Cargnin >>Analista de Sistemas >>Setor de Desenvolvimento de Sistemas - TRE-SC >>tel : (048) - 251-3700 - Ramal 3181 >> >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >> > > > > __________________________________ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now > http://companion.yahoo.com/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
-- Emerson Cargnin Analista de Sistemas Setor de Desenvolvimento de Sistemas - TRE-SC tel : (048) - 251-3700 - Ramal 3181
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
