Hi all,

We're having a problem implementing passing an array-type parmeter to a
finder method in CMP, something like:

        public Collection findById( int[] id )
        public Collection findById( Array id )
        public Collection findById( String idListAsCommaSeparatedString )

We would like the generated SQL to look something like:

        select * from MYTABLE where id in ?

We are using Orion 1.5.2, with customised orion-ejb-jar.xml files to specify
the select statements explicitly.

We cannot get it to work. Do we have to move to BMP?
Do we have to move to EJB QL and EJB 2.0? - if so, what are the steps
involved, and what app servers will support this? Orion says it has partial
EJB 2.0 support, but is vague about what exactly it supports.

If anyone has any help it would be greatly appreciated.

Thanks,
Justin Crosbie

===========================================================================
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".

Reply via email to