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

Re: Octetstring JDBC-LDAP Bridge



Using viennasql, i was just able to use the bridge against active
directory.  I used the following config:

Driver: com.octetstring.jdbcLdap.sql.JdbcLdapDriver
URL:
jdbc:ldap://adhost:389/cn=Users,dc=domain,dc=com?SEARCH_SCOPE:=subTreeScope

user: cn=UserFirst UserLast initials.,cn=Users,dc-domain,dc=com

password: mypassword

the query "SELECT * FROM" worksed jsut fine.



On Mon, 2003-07-14 at 11:07, Yen-Pin Wang wrote:
> Hi everyone:
> Does anybody have experience using this bridge?
> I checked the mailling list archive and it seems that everyone had the same problem.
> 
> Class.forName("com.octetstring.jdbcLdap.sql.JdbcLdapDriver");
> String sourceURL="jdbc:ldap://DSII.NET/DC=DSII?SEARCH_SCOPE:=subTreeScope";;
> java.sql.Connection con;
> con =DriverManager.getConnection(sourceURL,"CN=admin","password");
> stmt=con.createStatement();      
> rs = stmt.executeQuery("SELECT CN FROM DC=DSII");
>       		while(rs.next())
>       		{
>       			System.out.println(rs.getString("CN"));
>       		}								  
> javax.naming.PartialResultException: [LDAP: error code 10 - 0000202B: RefErr: DS
> ID-031006A4, data 0, 1 access points
>         ref 1: 'dsii.dsii'
> ]; remaining name 'DC=DSII'
> at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2699)
> at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2616)
> at com.sun.jndi.ldap.LdapCtx.c_lookup(LdapCtx.java:931)
> at com.sun.jndi.toolkit.ctx.ComponentContext.p_lookup(ComponentContext.j
> ava:522)
> ..................
> 
> I tried to use other baseDn like DC=DSII,DC=NET but the problem still there.
> 
> 
> 
> 
-- 
Marc Boorshtein, Software Engineer
Octet String Inc.
Phone: +1-847-466-1884
Email: marc.boorshtein@octetstring.com