
autocommit off;
prepare p1 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
execute p1 using 'values(''derby.authentication.provider'', ''LDAP'')';

-- there is no such machine as noSuchMachine and so the authentication will fail
execute p1 using 'values(''derby.authentication.server'', ''noSuchMachine:389'')';
execute p1 using 'values(''derby.authentication.ldap.searchBase'', ''o=opensource.apache.com'')';
-- this is the default search filter
execute p1 using 'values(''derby.authentication.ldap.searchFilter'', ''(&(objectClass=inetOrgPerson)(uid=%USERNAME%))'')';
commit;
autocommit on;
--
-- Shutdown the system for database properties to take effect
--
disconnect all;

disconnect all;


show connections;

disconnect all;


