CustomTypeHandler ?

[Kim Goings <ki...@levelfivesolutions.com>]

I have a db schema using the Single Table Inheritence pattern.  (One table,
each row "becomes" a different type.)  

I wrote a CustomTypeHandler and used the getResult method to translate it
into the correct type of object.  That works great.  

However, because I am using a "global" typeHandler definition like: 

<typeHandler javaType="foo.Question" callback="foo.QuestionTypeHandler"/ >
	
the custom type handler's setParameter method also is invoked when the type
is used as the parameter to an insert or update statement.  I'd hoped that I
could just set the object as the parameter and then use dot notation in the
parameter list to grab the fields from the object, but it looks like
setParameter assumes a single, non-complex parameter in the statement.  

eg:  

public void setParameter(ParameterSetter setter, Object parameter) throws
SQLException {
      setter.setObject(parameter);
}

<insert id="insert"
	parameterClass="question" >
	INSERT INTO question (typeId, text, categoryId, sequence)
		VALUES (#question.typeId#, #question.questionText#,
#question.categoryId#, #question.sequence#)
	<selectKey resultClass="int" keyProperty="id">
   		SELECT LAST_INSERT_ID() AS id
 	</selectKey>
</insert>


Am I going about this all wrong?  Should I be using a row handler instead?  

Thanks,
Kim