Re: Multiple database updating - Entity Bean

[Murthy, A (CAP, GEFA, Contractor)]

Srinivas,
I think, it is possible only when you have master-child relationships
between tables and your cascading updates and cascade delete options are
turned on then only you can update update multiple updates or deletes. I
think it is more related to your database options settings.Hope I am
correct. If you get the proper answer let me know. I am also interested in
the same thing.


Thanks & Regards,
Murthy A Suryanarayana
GE Financial Assurance
LTC - OPS2000 Project
------------------------------------------------------------------------
-------------------
Day     : (415) 492 7834
Dial-Com        :  8 *    277 7834
Fax     : (415) 492 7699
mailto  : [EMAIL PROTECTED]



-----Original Message-----
From: Rao, Chintala Srinivasa (CAP, FLEET)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 2:41 PM
To: [EMAIL PROTECTED]
Subject: Re: Multiple database updating - Entity Bean


Hi,

It is Multiple table updating

NOT Multiple database ....

Srinivas

-----Original Message-----
From: Rao, Chintala Srinivasa (CAP, FLEET)
Sent: Thursday, August 03, 2000 3:54 PM
To: [EMAIL PROTECTED]
Cc: Rao, Chintala Srinivasa (CAP, FLEET)
Subject: Multiple database updating - Entity Bean


Hi all,

I have the following situation.

I have a stateful session bean which handle the customer common data
throughout his session.
In that I am implementing setDetails(), getDetails() and modifyDetails()
functions.

setDetails() calls the stateless session bean method to get the result set.

getDetails() function simply returns the result set to Servlet/JSP.

Now, the main question is - in modifyDetails() function -->

        I am planning to use entity bean for my modification function.

        1) I want to pass the query String for updations.
        2) Can I do multiple table updations in one query?
        3) if I pass query string to modifyDetails() function, How I know
about primary keys?
        4) without the knowledge of PKs, how can I identify the proper
entity bean?

Can anybody please suggest me the solution for the third function
(modifyDetails())
Is entity bean is better, or Are there any options for this?
We want database updation immediately, and from next screen onwards the new
values should come to screens.

Thanks in advance,


Thanks & Regards,
Srinivasa Rao Chintala
GE Capital Fleet Services
GECFS Global Application Framework Architecture
3 Capital Drive, Eden Prairie
Minneapolis,  MN   55344
Ph:  952 - 828 - 1476  (Off)
       952 - 942 - 6818  Ext: 1523 (Resi)
       * 672 - 1476  (Dial Comm)

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".