Description: Basically this tool uses a JDBC driver or a JNDI pool connection to connect to a LDAP server using SQL commands. this is only JDBC -> LDAP, not LDAP -> JDBC. This is a working example in order to run it execute the following commands on command line: javac -cp .:* Main.java java -cp .:* Main The example extract the mail field from LDAP using a SQL query. Main.java import com.octetstring.jdbcLdap.jndi.*; import com.octetstring.jdbcLdap.sql.*; import com.octetstring.jdbcLdap.sql.statements.*; import java.sql.*; public class Main { public static void main(String[] parametro) { System.out.println("Hola Mundo Java"); String ldapConnectString = "jdbc:ldap://idp-ldap.sso.appsedudemo.com:389/dc=idp-ldap,dc=sso,dc=appsedudemo,dc=com?SEARCH_SCOPE:=subTreeScope"; java.sql.Connection con; try { DriverManager.registerDriver(new JdbcLdapDriver()); con = DriverManager.getConnection(ldapConnectString,"cn=admin,dc=idp-ldap,dc=sso,dc=appsedudemo,dc=com","egdpassword"); String field = "mail"; String stmt = "SELECT " + field + " FROM subTreeScope;dc=idp-ldap,dc=sso,dc=appsedudemo,dc=com WHERE uid = 'demo'"; PreparedStatement pstmt = con.prepareStatement(stmt); ResultSet rs = pstmt.executeQuery(stmt); while(rs.next()) { System.out.println(field + "=" + rs.getString(field)); } System.out.println("OK"); } catch ( SQLException e ) { System.out.println(e.getMessage()); } catch ( Exception e ) { System.out.println(e.getMessage()); } } } |
Home > SSO Single Sign-On >