Yes! Using hibernate :D
-----Mensagem original-----
De: Sasha Borodin [mailto:[EMAIL PROTECTED]
Enviada em: sexta-feira, 22 de abril de 2005 16:43
Para: ibatis-user-java@incubator.apache.org
Assunto: Re: Mapping of one object to several tables?
Can you even do an INSERT that involves multiple tables?
-Sasha
> From: Brandon Goodin <[EMAIL PROTECTED]>
> Reply-To: <ibatis-user-java@incubator.apache.org>
> Date: Fri, 22 Apr 2005 13:39:30 -0600
> To: <ibatis-user-java@incubator.apache.org>
> Subject: Re: Mapping of one object to several tables?
>
> If you are trying to prevent duplicate inserts you would need to
> perform a select on the database to make sure it doesn't exist first.
>
> Brandon
>
> On 4/22/05, toto titi <[EMAIL PROTECTED]> wrote:
>> Hello,
>>
>> I am new to iBatis/SQL and don't really know if the following is
>> possible or not.. Also, I am not sure where to ask this question as I
>> don't know if it relates more to iBatis or SQL... so please bear with
>> me.
>>
>> Let's say I want to save the following object:
>> class person {
>> String name;
>> String country;
>> }
>>
>> In order to save space in my db I will save the
>> country in a table of its own and refer to each record
>> from the name table by an id:
>>
>> personTable
>> -----------
>> id
>> name
>> countryId
>>
>> countryTable
>> ------------
>> id
>> country
>>
>> Now, I know that for a select statement I can just do
>> a join to get my object back:
>> SELECT name, country from personTable, countryTable
>> where countryId=countryTable.id;
>>
>> My question is, how do I insert a new person in these
>> two tables with only one query? Taking into account
>> that the country for the new person object might
>> already have been inserted..
>>
>> Thanks for any help!
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Tired of spam? Yahoo! Mail has the best spam protection around
>> http://mail.yahoo.com
>>
