Thanks!
-----Original Message-----
From: Brandon Goodin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 13, 2005 11:20 AM
To: [email protected]
Subject: Re: SQL Map Configuration with Many tables and Domain classes
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 <[EMAIL PROTECTED]> 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
