• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Can you query the LDAP Schema?

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is it possible to use the attributes of the LDAP schema in queries in conjunction with sql queries?
For instance if I had a person node in LDAP with the following attributes: uid, uidnumber, uidpassword, firstName and lastname, and I wanted to query a table in oracle using the uidnumber attribute in the where clause?
In sql I qould write this as follows:
SELECT * FROM tableA
WHERE uidNumber IN
(SELECT Number from tablePerson)
Is it possible to do such a thing with LDAP?
 
Author
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Not being relational, LDAP doesn't have the concept of subselects. If the subselect contained multiple UID values that you wanted to retrieve, you would in fact have had to do multiple searches to retrieve all of the matches that would have been retrieved via the statement above.
While this may seem like a limitation, it really comes down to this functionality being outside the scope of what LDAP is suposed to provide.
Clayton
 
reply
    Bookmark Topic Watch Topic
  • New Topic