Your problem is not ibatis. Your problem is how BeanUtils within
Struts translates an empty request parameter into an Integer property
on your bean. I would handle this issue on the Struts layer. You can
handle it either in your action form with a setter that receives a
string and sets the value into your bean or you can write a custom
Converter for BeanUtils. I recommend that you post this question to
the Struts list.
Brandon
On 5/6/05, Lieven De Keyzer <lieven_dekeyzer@hotmail.com> wrote:
> >The only way to make that "clean" is to push the translation effort
> >into your ActionForm and nest your real beans in the ActionForm. you
> >would then have a String value that you convert and set into your
> >nested bean. The other option is to write a different BeanUtils
> >Converter implementation for numerics and register it
> >(http://jakarta.apache.org/commons/beanutils/api/org/apache/commons/beanutils/ConvertUtils.html#register(org.apache.commons.beanutils.Converter,%20java.lang.Class).
>
> I like this second approach because I presume that in this case, all INTEGER
> columns will be set to NULL if no value is provided. I just don't see why an
> empty INTEGER column should be 0.
> But how would I approach this problem? First rewrite the Jakarata commons
> converter, and then recompile the iBatis classes with these commons classes?
>
> >
> >I would personally avoid cluttering up your domain bean with faux
> >setters and getters.
> >
> >Brandon
> >
> >On 5/2/05, Darek Dober <[EMAIL PROTECTED]> wrote:
> >> Hi, I hava a table 'users' with column dept_id (id of department in
> >>departments
> >>table) This column is optional. That means the operator doesn't have to
> >>assign
> >>inserted user to any department. If I have bean: public class UserBean
> >>{ Integer departmentId; .... } struts will make automatic
> >>conversion of type. So departmentId will be set
> >>to 0, if I don't set any of department. That's a cheat, because, I don't
> >>want to to have a department with id equals to 0, it should be NULL. On
> >>the other hand, when I implement departmentId as String, struts act
> >>correctly. But while inserting record to the database, I get an error sth
> >>like this: database column dept_id is type of bigint, inserted value is
> >>type of
> >varchar.
> >> I have the solution: departmentId is type of String, but for ibatis I
> >>have
> >>the other metod getDepartmentIdAsInteger which return Integer or null if
> >>value is empty. It works, but i don't like this. Is there any cleaner
> >>solution for this. I looked into jpetstore, but there
> >>were columns of type varchar. Rest of them was mendatory. I cannot use
> >>columns of type varchar as foreign keys. Usage: .... VALUES(
> >> #departmentId:INTEGER#,
> >>.... doesn't help if departmentId is String Any ideas? Darek
>
>
|