Be aware that transactions(update,insert,delete) on an Oracle's view are not always possible. Your insert successed because your view is simple.
After creating your view, you can check if it's updatable via the Oracle's catalogue table : all_updatable_columns select * from all_updatable_columns where table_name='cmpaddressbookview' José. -----Original Message----- From: Saminathan Seerangan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 5:58 AM To: [EMAIL PROTECTED] Subject: Re: Is it possible to create entity bean against DB View? Hi Jaydeep, Even with CMP it is possible i guess. Actually this is what i did... 1) created cmpaddressbook table in oracle DB 2) deployed cmpaddressbookbean 3)started application 4) Inserted one record using cmpaddressbookbean (java client)- works fine 5) renamed cmpaddressbook to cmpaddressbooktab; 6)create view cmpaddressbook as select * form cmpaddressbooktab; 7) Inserted one record using cmpaddressbookbean (java client)- works fine 8)stoped appserver(Websphere 5.0) 9)started appserver 10) Inserted one record using cmpaddressbookbean (java client)- works fine Thanks Sami Jaydeep Nargund <[EMAIL PROTECTED] OTMAIL.COM> To Sent by: A [EMAIL PROTECTED] mailing list for cc Enterprise JavaBeans Subject development Re: Is it possible to create entity <[EMAIL PROTECTED] bean against DB View? A.SUN.COM> 07/01/2003 09:52 PM Please respond to Jaydeep Nargund <[EMAIL PROTECTED] OTMAIL.COM> Hi, Yes, If you are using BMP you can create an entity bean for the view. All you need to implement is the ejbLoad method. Regards, Jaydeep Nargund >-----Original Message----- >From: Saravana [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 01, 2003 5:27 AM >To: [EMAIL PROTECTED] >Subject: Re: Is it possible to create entity bean against DB View? > >hi , > >No, as per my knowledge it is not possible to create an Entity Bean >with a DB View. > >Thanks > >----- Original Message ----- >From: "Saminathan Seerangan" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, July 01, 2003 3:36 PM >Subject: Is it possible to create entity bean against DB View? > > > > Hi All, > > > > Is it possible to create entity bean against DB View? > > > > Thanks in advance > > Sami > > > > >======================================================================= >==== > > 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". > > >The information transmitted is intended only for the person or entity >to which it is addressed and may contain confidential, proprietary, >and/or privileged material. Any review, retransmission, dissemination >or other use >of, or taking of any action in reliance upon this information by >persons or >entities other than the intended recipient is prohibited. If you >received this email in error, please contact the sender and delete the >material from >all computers. > >======================================================================= >==== >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". > _________________________________________________________________ Reconnect with old pals. Relive the happy times. http://www.batchmates.com/msn.asp With just one click. =========================================================================== 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". **** DISCLAIMER **** "This e-mail and any attachment thereto may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by other persons than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone or by e-mail and delete the material from any computer". Thank you for your cooperation. For further information about Proximus mobile phone services please see our website at http://www.proximus.be or refer to any Proximus agent. ==========================================================================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".
