RE: java.util.UUID to postgres uuid column

[Niels Beekman]

Try #value#, this will use your parameter object directly. Using #id#
tries to obtain the id property from it.

 

________________________________

From: Vikram Subbarao [mailto:vikra...@directi.com] 
Sent: Thursday, February 11, 2010 7:50 AM
To: user-java@ibatis.apache.org
Subject: Re: java.util.UUID to postgres uuid column

 

With this approach i tried this in a query - 

    <select id="findById" parameterClass="java.util.UUID"
resultMap="fullResult" cacheModel="cache">
        SELECT users.*
        FROM users
        WHERE id = #id#
    </select>    


When i call this query as - 

    sqlMapClientTemplate.queryForObject("User.findById", id);

    Note: id is an java.util.UUID object.

I get an error - 

    com.ibatis.common.beans.ProbeException: There is no READABLE
property named 'id' in class 'java.util.UUID'

Regards
Vikram

Larry Meadors wrote: 

This might work:
 
public class UUIDTypeHandler implements TypeHandlerCallback {
    @Override
    public void setParameter(ParameterSetter setter, Object parameter)
throws SQLException {
        setter.setObject(parameter);
    }
 
    @Override
    public Object getResult(ResultGetter getter) throws SQLException {
        return getter.getObject();
    }
 
    @Override
    public Object valueOf(String s) {
        return UUID.fromString(s);
    }
}
 
Add this in your sqlmapconfig.xml:
 
<typeAlias alias="UUID" type="java.util.UUID" />
<typeHandler javaType="UUID" callback="UUIDTypeHandler"/>
 
Larry
 
 
 
On Tue, Feb 9, 2010 at 3:35 AM, Vikram Subbarao <vikra...@directi.com>
<mailto:vikra...@directi.com>  wrote:
  

        I am using postgres db and would like to map a java.util.UUID to
a postgres
        uuid column. Latest postgres driver supports mapping of this if
i was
        directly creating my prepared statements but since i use ibatis
inbetween, i
        am unable to achive this as ibatis does not seem to understand
that
        java.util.UUID can be based down to jdbc. I could use
typehandler if the db
        column was a VARCHAR, but since the postgres db is a 'uuid'
type, i have  no
        option but to use the driver supported option of using
java.util.UUID, but
        it does not work with ibatis for me.
         
        Please help me if some one has a solution to this.
         
        Regards
        Vikram
         
        
---------------------------------------------------------------------
        To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
        For additional commands, e-mail:
user-java-h...@ibatis.apache.org
         
         
            

 
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org