Grab the user's uid from the LDAP, then run an SQL query using that uid.
That would also be the best solution if you had the user information in
say Oracle and the job information in Sybase and wanted to join them.
arkin
Javier Borrajo wrote:
>
> Hi, I know this is not 100% EJB, but I think the problem is related.
>
> Suppose the user information is stored in LDAP. Suppose the
> rest of the application data is stored in an RDBMS.
>
> How can I make a query joining user and application data?
>
> Something like "select all jobs asigned to this user"
> where job information is stored in RDBMS and user information
> is stored in LDAP.
>
> Replicating all user data from LDAP into the RDBMS does not
> look like a good solution.
>
> Best regards
>
> Javier Borrajo
> www.tid.es
>
> ===========================================================================
> 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".
--
----------------------------------------------------------------------
Assaf Arkin www.exoffice.com
CTO, Exoffice Technologies, Inc. www.exolab.org
===========================================================================
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".
