mysql+ibatis

2009-04-02 Thread David McReynolds
Would it be beneficial to use the EXTERNAL transaction management given that only two or three out of a hundred mysql tables in our schema actually support transactions? I'm thinking yes, but I am not sure "how" beneficial it would be. -- dlm

Re: [resultMap] related objects

2009-04-02 Thread Ingmar Lötzsch
> I get exception: > --- Check the company.company-result. > --- The error happened while setting a property on the result object. > --- Cause: com.ibatis.sqlmap.client.SqlMapException: Error instantiating > collection property for mapping 'address'. Cause: > java.lang.ClassCastException: Th

Re: [resultMap] related objects

2009-04-02 Thread mikkapl
Richard Yee wrote: > > Should your resultmap be address-result instead of company.address- > result? > Then I get: --- Check the company.company-result. --- The error happened while setting a property on the result object. --- Cause: com.ibatis.sqlmap.client.SqlMapException: There is no

Re: [resultMap] related objects

2009-04-02 Thread Richard Yee
Should your resultmap be address-result instead of company.address- result? Richard Sent from my iPhone On Apr 2, 2009, at 6:25 AM, mikkapl wrote: Ingmar Lötzsch wrote: You don't need a custom TypeHandler. But perhaps you have to provide more information. I get exception: --- Chec

Re: [resultMap] related objects

2009-04-02 Thread mikkapl
Ingmar Lötzsch wrote: > >> You don't need a custom TypeHandler. But perhaps you have to provide > more information. > I get exception: --- Check the company.company-result. --- The error happened while setting a property on the result object. --- Cause: com.ibatis.sqlmap.client.SqlMapExce

Re: [resultMap] related objects

2009-04-02 Thread Ingmar Lötzsch
> Do I have to use TypeHandler? But how? You don't need a custom TypeHandler. But perhaps you have to provide more information. What are the column names of the tables "companies" and "adresses"? Your first message shows that they are different from the class properties. Which packages contain

Re: [resultMap] related objects

2009-04-02 Thread Brandon Goodin
What is the exception? Brandon On Thu, Apr 2, 2009 at 6:38 AM, mikkapl wrote: > > > yeah, I made mistake... I didn't paste it just type. But It doesn't work > even if it will be matched. > It doesn't work at all. > Do I have to use TypeHandler? But how? > > > > This example can't work, because

Re: [resultMap] related objects

2009-04-02 Thread mikkapl
yeah, I made mistake... I didn't paste it just type. But It doesn't work even if it will be matched. It doesn't work at all. Do I have to use TypeHandler? But how? > This example can't work, because > resultMap="address-result" > > does not match > > http://www.nabble.com/-resultMap--related-

Re: [resultMap] related objects

2009-04-02 Thread Ingmar Lötzsch
> ...and there is a problem with resultMap: You should explane the problem. What exceptions? What table structures? > something like that doesn't work: > > > > > > > > > > > This example can't work, because resultMap="address-result" does not match

[resultMap] related objects

2009-04-02 Thread mikkapl
hello, I want to get Object related to another object like this (I bolded important things): Company { Integer id; String name; Address address; } Address { Integer addressId; String street; } SQL: SELECT c.*, a.* FROM companies c, addresses a WHERE a.address_id = c.address_id; ...and there i