Need help to configure driver from DBeaver

zoesolutions / openldap-jdbcldap

The JDBC-LDAP Bridge Driver (JDBC-LDAP) enable you to create Java applications that can access information held in directories. The driver should appeal to Java developers who prefer to use SQL and JDBC.

https://www.openldap.org/jdbcldap/

Other

1 stars 3 forks source link

Need help to configure driver from DBeaver #2

Open chprome opened 3 years ago

chprome commented 3 years ago

Hello,

I'd like to use this JDBC driver in DBeaver (https://dbeaver.io/) I can't manage to make it work, when testing a connection DBeaver hangs forever and I must to kill it.

My guess is that the URL connection string is not valid.

Could you please tell me what should be the format of the connection string?

Regards Christophe

AydinChavez commented 3 years ago

Hello,

had the same issue and got a working connection with following connection string (source: https://openldap-software.0penldap.narkive.com/ebykv4wS/regarding-octet-string-jdbc-ldap-bridge):

jdbc:ldap://localhost:10389

(had to increase max heap sizein my dbvisualiser to get it working, otherwise I got an OutOfMemory).

Some sample sql can be found here (didn't them try out yet): https://community.smartbear.com/t5/SoapUI-Open-Source/JDBC-Request-for-Ldap-Server-failing/td-p/13720

elbosso commented 3 years ago

hi, if you still need help, i just forked this and shoveled out a whole lot of dirt and crap and NullPointerExceptions. Now, not only the SQL queries work (even with memberOf!) but also the advertised functionality to define subtrees as actual tables. Fork is at https://github.com/elbosso/openldap-jdbcldap