11 Oct 2006 00:33
Enum typeHandlerCallback
<Christopher.Mathrusse <at> sybase.com>
2006-10-10 22:33:29 GMT
2006-10-10 22:33:29 GMT
I'm attempting to implement a
TypeHandlerCallback to handle an Enum. The Enum is declared within a class but I
can't seem to figure out how to do this correctly. I keep getting an exception
thrown at startup because iBatis cannot seem to load the enum. In the Resources
class, the method classForName(String) keeps throwing an exception based upon
the javaType that I have specified in my config file.
SqlMapConfig Type
Handler declaration:
<typeHandler javaType="com.sybase.cosmos.domain.DocumentStore.State" callback="com.sybase.cosmos.dao.impl.ibatis.extentions.DocStoreStateTypeHandlerCallback"
/>
Enum defined in java class:
public
class DocumentStore extends DomainObject {public static enum State { INITIALIZED, PROCESSING, COMPLETE, ERROR }
The following in Resources.classForName(String), which is using the class loader, cannot locate the enum that I have specified. So how can I tell iBatis to use my TypeHandlerCallback for this enum?
Thanks....
Chris Mathrusse
(925) 236-5553
It's too bad that this query
select PRODUCT.*, CATEGORY.* from PRODUCT, CATEGORY where ...
does not yield column-names like
"PRODUCT.ID", "PRODUCT.DESCRIPTION", "CATEGORY.ID", ...
That's of course a short-coming of jdbc (or rather of SQL itself), not iBatis.
Maarten
On 10/11/06, Clinton Begin <clinton.begin <at> gmail.com> wrote:
> No.
>
> This would be a impossible solution. We can't arbitrairly map two columns
> with the same name, unless you wanted to do it by column number. But that
> is also arbitrary with SELECT *.
>
> I'm afraid you're asking for the impossible. I suggest you use aliases.
>
> Clinton
>
>
> On 10/10/06, Maarten Bosteels <mbosteels.dns <at> gmail.com> wrote:
> > Hello,
> >
> > I found this example in the Developer Guide::
> >
> > <resultMap id="get-product-result" class="com.ibatis.example.Product">
> > <result property="id" column="PRD_ID"/>
> > <result property="description" column="PRD_DESCRIPTION"/>
> > <result property="category" resultMap="get-category-result" />
> > </resultMap>
> >
> > <resultMap id="get-category-result" class=" com.ibatis.example.Category">
> > <result property="id" column="CAT_ID" />
> > <result property="description" column="CAT_DESCRIPTION" />
> > </resultMap>
> >
> > <select id="getProduct" parameterClass="int"
> resultMap="get-product-result">
> > select *
> > from PRODUCT, CATEGORY
> > where PRD_CAT_ID=CAT_ID
> > and PRD_ID = #value#
> > </select>
> >
> > What if the columns in PRODUCT and CATEGORY do not have the PRD_ and CAT_
> > prefixes and share column-names (eg ID) ?
> > It would most probably work to have a column alias for every column
> > but I would like to avoid that and stick with the star in "select *
> > from"
> >
> > I am having a similar problem with RowMapper and Spring's JDBCTemplate
> > and wondered if iBatis has a solution.
> >
> > Thanks, I hope my question is clear.
> >
> > Maarten
> >
>
>
RSS Feed