Javier
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.
am i clear ??
regards
madhu
-----Original Message-----
From: Javier Borrajo [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 21, 2000 3:48 AM
To: [EMAIL PROTECTED]
Subject: LDAP + SQL
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".
===========================================================================
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".
