>Can't u have the userId or somefield like that in the rdbms field as the
>foreign key.
>
>that way to get to the jobs pertaining to a user, u can look up the rdbms
>AND for user information u can use LDAP queries using standard
>ldapctxFactory implementations, etc. a stateless session bean can delegate
>these 2 queries (if u please) from one parent method.
Thanks for the answer.
This solution means replicating LDAP info in the RDBMS, if only the user id.
Is this what people out there are doing? Or is it nobody is using
LDAP with workflow apps etc ?
Javier
>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.
===========================================================================
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".