[Date Prev][Date Next] [Chronological] [Thread] [Top]

JDBC-JNDI bridge


structure of ldap database:
- ou=people
   - uid=hamnis
- ou=roles
   - roleID=20
      -memberID = multivalue
- ou=groups
   - cn=developer

I am trying to write a server which retrives the user information from our ldap database.
The database is modeled after a SQL database we had earlier.

1. "SELECT employeeNumber FROM ou=people" gets all the users.
2. "SELECT memberID FROM ou=roles" gets all the roles

However I have run into a problem:

i want to base the selection in 1 on 2.

Is there any way to accomplish this in JNDI/JDBC or do I need to use several statements?