[Q] Transformers.aliasToBean and Case

khoying · **Joined:** Fri Jun 24, 2005 3:57 pm **Posts:** 11

I am attempting to use the Transformers.aliasToBean functionality to map results from a Names Native SQL query to a DTO bean. This seems to work great as long as the setter methods on my bean are all upper case (ex setMYPROPERTY). Is this just a limitation, a bug or is there a setting somewhere that I need to be specifying to maintain the case?

Thank you in Advance!

Hibernate version: 3.2.4.sp1

Name and version of the database you are using: Oracle 10

christian · **Posted:** Thu Aug 16, 2007 8:22 am

Hibernate takes whatever comes from the database in the resultset, which is not defined. So one solution would be to subclass the Transformer and lowercase it all the time, if that's how you want your properties to look like.

khoying · **Joined:** Fri Jun 24, 2005 3:57 pm **Posts:** 11

Thank you for the quick response. I was able to locate another topic on this subject and they suggested specifying a return scalar for the query with the name in the desired case. This seems to have worked.

Thank you!

dusura · **Joined:** Mon Aug 15, 2005 9:19 pm **Posts:** 8

e.g. something like:

Code:

   <sql-query name="getSomethingStupid">
      <return-scalar column="iLoveYou" type="string"/>
      <![CDATA[
   select word iLoveYou
   from missive
                        where
                        word_type='fluffy_bunnies'
      ]]>
    </sql-query>

with bean:

Code:

class Missive {
    private String iLoveYou;

    public Missive() {}

    public String getILoveYou() {
        return iLoveYou;
    }

    public void setILoveYou() {
        this.iLoveYou = iLoveYou;
    }
}