> I have a need to perform table joins in order to retrieve necessary information from a system support 3,000 web-based users using an Oracle 9i database. > > Can a single EJB support more than one database table?
yep. You can choose between BMP (EJB1.1 or 2.0) and write the SQL yourself, using CMP2 (EJB2.0) and let the container handle it using CMR, or just use SBs and do the JDBC work yourself, but gain the benefits of the containers transaction management and pooling. > Can an EJB support database views? a tendative 'yes' - although this would typically make your 'bean' read-only. Again - when you say 'support' what exactly do you mean? Do entity beans support views? I would suggest that most containers would allow you to have an entity bean represent a "view of the view". Of course using SLSB you could do the JDBC work yourself, and therefore have complete control. > Should I even be considering the use of EJBs? I would think so. 3000 users isn't _that_ many... the real question is how many concurrent users. If you have 3000 users that each log on once a week at spread out intervals, then you probably wont be generating that much load anyway... imho. cheers dim =========================================================================== 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".
