Hi all, I am building a project in Weblogic 7.0 with Oracle8i as the backend. The client side is VC++. The client shall be sending huge amounts of data, and the data shall be like 1 to many, many to many records, which shall take time if i insert through CMP, because the data shall be sent one by one to the create method of the home interface, which shall in turn insert into the database. For inserting what i was thinking, couldn't data be inserted in one shot (something like oracle objects in database) through EJB, rather than having round trips to make everytime to the database, coz the performance should be good. One of the appraoches we are planning to go, is to use Session Facade pattern, along with Value Objects. The client shall call the session bean, which in turn shall call the ValueObject class for setting and getting the values in the EJB.
I was thinking we shall use DTO for only getting the records from the database, and for inserting we can use HashMap (i.e. not use Value Object). What are the advantages of this appraoch? Can i pass HashMap to the ejbCreate method? I know you can pass a Collection object. I tried it, but i am getting deployment error. IF somebody has done it, could they help me out. Will the data be inserted in one shot or still the data will be looped. Third approach is we use stored procedures, but that shall mean putting the logic in the database, which we do not want to do. Could anybody throw some light on my dilemma. TIA, vikram. =========================================================================== 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".
