JDBC-JNDI bridge

[Erlend Hamnaberg <hamnis@start.no>]

hello

structure of ldap database:
dc=underdusken,dc=no
- ou=people
   ---
   - uid=hamnis
      -employeeNumber=23
- 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?