[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: JDBC-JNDI bridge
- To: Erlend Hamnaberg <hamnis@start.no>
- Subject: Re: JDBC-JNDI bridge
- From: Marc Boorshtein <mboorshtein@gmail.com>
- Date: Sun, 17 Jul 2005 22:48:04 -0400
- Cc: openldap-software@OpenLDAP.org
- Content-disposition: inline
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=eAiFcA6ijakYbSZNPECkGIfllahwmMCbIP/pqIT83IumOKPvcNgdNe5zFDDmEw+Tnrw3jeKPSfbf9Xsal54dGLnIwevZx8oxab+sK/RTDkN73xwwm3Oto0NuFokTeDPRQeREM+Q2mL/956m1C/V19fRJfpP/4C1Q6LWmNFSskqM=
- In-reply-to: <42DA60A3.5050905@start.no>
- References: <42DA60A3.5050905@start.no>
The JDBC-LDAP Bridge is a simple JDBC driver to translate from SQL to
LDAP calls. While in many RDBMS servers you can perform sub selects,
the bridge does not support this funcitonality. You will need to run
multiple searches.
Marc
On 7/17/05, Erlend Hamnaberg <hamnis@start.no> wrote:
> 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?
>