ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: SQL Map Configuration with Many tables and Domain classes
Date Wed, 13 Apr 2005 16:00:54 GMT
As far as i know you should be able to refer to any sqlmap regardless
of whether it is in another xml file and/or namespace. If you can't it
is a bug.

Brandon

On 4/13/05, Nic Werner <werner@sonoma.edu> wrote:
> On  a quick note about namespaces and such: If I have two xml files for
> different tables, can I refer to one of the statements in the other
> file, like if I was calling a statement in a resultMap? Or are they only
> available locally in that file?
> 
> - Nic.
> 
> Brandon Goodin wrote:
> 
> >What you want to do is perfectly acceptable. The namespace is used
> >when you call your sqlmap
> >queryForObject("MyNameSpace.myMappedStatement",myObject). So, the
> >namespace is arbitrary. You can name it whatever you like.
> >
> >Brandon
> >
> >On 4/13/05, Jason Hall <JHall@cihi.ca> wrote:
> >
> >
> >>
> >>
> >>Hi,
> >>
> >>I have about 200 tables and what i've done is group certain child tables in
> >>a logical domain.
> >>Don't want to deal with so many scattered xml files for each table.
> >>
> >>For example:
> >>
> >>If I had parent table PERSON and 3 child tables say PERSON_CHILD1,
> >>PERSON_CHILD2, PERSON_CHILD3
> >>
> >>can I create one sqlmap file say Person.xml
> >>
> >>and then in the file will be ...
> >>
> >><sqlMap namespace="person">
> >>
> >>         <!-- PERSON -->
> >><typeAlias alias="person" type="com.yah.nah.Person" />
> >>
> >><insert id="insertPerson" parameterClass="person" >
> >>
> >>    insert into ......
> >>
> >></insert>
> >>
> >>
> >>         <!-- PERSON_CHILD1 -->
> >><typeAlias alias="personchild1" type="com.yah.nah.PersonChild1" />
> >>
> >><insert id="insertPersonChild1" parameterClass="personchild1" >
> >>
> >>    insert into ......
> >>
> >></insert>
> >>
> >>         <!-- PERSON_CHILD2 -->
> >><typeAlias alias="personchild2" type="com.yah.nah.PersonChild2" />
> >>
> >><insert id="insertPersonChild2" parameterClass="personchild2" >
> >>
> >>    insert into ......
> >>
> >></insert>
> >>
> >>         <!-- PERSON_CHILD3 -->
> >><typeAlias alias="personchild3" type="com.yah.nah.PersonChild3" />
> >>
> >><insert id="insertPersonChild3" parameterClass="personchild3" >
> >>
> >>    insert into ......
> >>
> >></insert>
> >>
> >>
> >></sqlMap>
> >>
> >>
> >>So is this legal to do with using many typeAliases and using  parameterClass
> >>for 3 different domain classes as noted in the example ?
> >>
> >>Also can the namespace be anything other than the actual domain you are
> >>acting on for example if the domain is Person can the namespace be
> >>Personer(just want to know if this is possible)?
> >>
> >>please help.
> >>
> >>Thanks!
> >>
> >>Jason Hall
> >>
> >>
> 
>

Mime
View raw message