I meant iBATIS logging, see http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+g et+SqlMapClient+to+log+SQL+statements for instructions.
You should gracefully handle your SQLExceptions, but for now try printing your "this.error" variable to see if an error occurred. Also, make sure that any RuntimeExceptions don't get swallowed by the code that calls DBAccess.getObjectById(). Niels -----Original Message----- From: hett [mailto:[EMAIL PROTECTED] Sent: woensdag 21 februari 2007 17:41 To: user-java@ibatis.apache.org Subject: RE: TypeHandler UUID Thanks for the quick reply, I just learned java for a few weeks, still trying to get use to eclipse, can you show me how to enable debug logging to see the generate query? here is my dbAccess method using generic: public T getObjectById(String query, UUID id) { T rObject = null; // reset the error this.error = ""; try { rObject = (T)sqlMap.queryForObject(query, id); } catch (SQLException e) { // System.out.println(e); this.error = e.getMessage(); } return rObject; } and here is my testing code: DBAccess<Person> ac = new DBAccess<Person>(); Person p = ac.getObjectById("getPersonById", UUID.fromString("A26A19F6-18C4-4ba0-84BB-6EAD12B4CB8D")); System.out.println(p.getId()); I have tested my DBAccess with a different object using the String type and I got data back, so I don't think it's my DBAccess code is the problem. Niels Beekman-2 wrote: > > Try to enable debug logging and see if you get results when you manually > execute the generated query. getResult() should definitely be called, so > I think it's either a bug in your setParameter() or the query is wrong. > Could you post your calling Java code too? > > Niels > > -----Original Message----- > From: hett [mailto:[EMAIL PROTECTED] > Sent: woensdag 21 februari 2007 15:53 > To: user-java@ibatis.apache.org > Subject: RE: TypeHandler UUID > > > getResult() is not being called at all, but it does went to > setParameter(). > This is what I have in my resultmap > > <sqlMap namespace="Person"> > > <typeAlias alias="person" type="domain.Person"/> > > <resultMap id="get-all" class="person"> > <result property="id" column="person_id" > typeHandler="domain.UUIDTypeHandler"/> > </resultMap> > > <select id="getPersonById" resultMap="get-all" > parameterClass="java.util.UUID"> > SELECT > * > FROM person > WHERE person_id=#value# > </select> > > </sqlMap> > > > Niels Beekman-2 wrote: >> >> Hi, >> >> Is getResult() being called? If not, try adding an explicit >> javaType="java.util.UUID" to the resultmap. >> >> If I may suggest an optimization: replace getter.getObject() == null >> with getter.wasNull(). >> >> Niels >> >> -----Original Message----- >> From: hett [mailto:[EMAIL PROTECTED] >> Sent: woensdag 21 februari 2007 1:15 >> To: user-java@ibatis.apache.org >> Subject: TypeHandler UUID >> >> >> Hi, I am working with a db that doesn't support UUID, so we specify > the >> id >> column in the db as an nvarchar(36). I follow this example >> > http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+u >> > se+a+Custom+Type+Handler+with+complex+property+or+Type+Safe+Enumeration >> and created my TypeHandler. >> >> In my person class, I have the following: >> >> public class Person { >> UUID id; >> //get and set method... >> } >> >> and in UUIDTypeHandler: >> >> public class UUIDTypeHandler implements TypeHandlerCallback{ >> >> public Object getResult(ResultGetter getter) throws SQLException >> { >> String value = getter.getString(); >> if(getter.getObject() == null){ >> return null; >> } >> UUID uuid = UUID.fromString(value); >> return uuid; >> } >> >> public void setParameter(ParameterSetter setter, Object >> parameter) throws >> SQLException { >> if(parameter == null){ >> setter.setNull(Types.VARCHAR); >> }else{ >> UUID uuid = (UUID) parameter; >> //System.out.println(uuid.toString()); >> setter.setString(uuid.toString()); >> } >> } >> >> public Object valueOf(String s) { >> return s; >> } >> } >> >> in the sqlmapconfig I added this: >> <typeHandler javaType="java.util.UUID" >> callback="domain.UUIDTypeHandler"/> >> >> I tried to do a select query, but the result is always null, is there >> something else I am missing? >> -- >> View this message in context: >> http://www.nabble.com/TypeHandler-UUID-tf3264136.html#a9073293 >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >> >> >> > > -- > View this message in context: > http://www.nabble.com/TypeHandler-UUID-tf3264136.html#a9082175 > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > -- View this message in context: http://www.nabble.com/TypeHandler-UUID-tf3264136.html#a9084307 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
