Hi all EJB gurus, having several problems with CMP entities with Jboss I ask you for experienced users advices....In fact several entities in my project must contain binary data so I first used a BLOB field in my database but I was unable to make it work correctly (in fact I discovered that only OCI driver is able to handle BLOB fields with Oracle 8.1.7.* So I changed my BLOB fields for LONG RAW ones, storage & reading now work fine but I'm still unable to make my finder methods work!!! (findAll work OK, findBy<Fieldname> too) but all others failed... I decided (after reading several papers on the web & posts from different mailing lists) to use a server side algorithm for keys generation... But I'm unable to make a : SELECT MAX(id) from MyEntity in any EJB-QL all finders methods failing , my key generation can't work... In fact I've read that EJB's CMP entities were unable to retrieve auto-incremented keys (so this task can't be delegated to the database server)... All experience feedback welcomed....I've no more ideas... Cheers Jerome =========================================================================== 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".
