Return-Path: X-Original-To: apmail-directory-dev-archive@www.apache.org Delivered-To: apmail-directory-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 12471CBEA for ; Thu, 3 May 2012 15:20:07 +0000 (UTC) Received: (qmail 27071 invoked by uid 500); 3 May 2012 15:20:06 -0000 Delivered-To: apmail-directory-dev-archive@directory.apache.org Received: (qmail 27036 invoked by uid 500); 3 May 2012 15:20:06 -0000 Mailing-List: contact dev-help@directory.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Apache Directory Developers List" Delivered-To: mailing list dev@directory.apache.org Received: (qmail 27028 invoked by uid 99); 3 May 2012 15:20:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 May 2012 15:20:06 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of juan04sm@gmail.com designates 209.85.212.50 as permitted sender) Received: from [209.85.212.50] (HELO mail-vb0-f50.google.com) (209.85.212.50) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 May 2012 15:19:58 +0000 Received: by vbnl22 with SMTP id l22so1904935vbn.37 for ; Thu, 03 May 2012 08:19:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=173xrt35uqWSb1Nu12+LXZ00n+xBvU9eT1L0fxZh2F0=; b=GKGYikyZHzpz+JaEW1kk0pOQTeO+yjaWtYCSBUDr6Vgu13oacGi0yw+Q8EINgRWzHE oHqV3PNHneo/XYdsYRyadheWjEk6D3syHTO1AvGnyDWmpmRko5+XOWmY1p2S55uarxso OAvyVd5b4sS50mHtCEyYcfJZ2jPa61h0UrpM3c4VqtOvPEeuAQCofqToLY6B83Gzhlo2 8kt/jZPi/DM/uZBwwDuigxKNtQL/wKYO9clUydo5FoKs1xBeIShXLTKTX2CT6TL8PBYz MlKyy1+ls83ae7RjFKB2yyv+7FD+FHTs0+IzylVxDZqegMI1JjgGNYchQFkCNngiUt1r IBpg== MIME-Version: 1.0 Received: by 10.220.230.67 with SMTP id jl3mr1517249vcb.50.1336058377735; Thu, 03 May 2012 08:19:37 -0700 (PDT) Received: by 10.220.108.78 with HTTP; Thu, 3 May 2012 08:19:37 -0700 (PDT) Date: Thu, 3 May 2012 12:19:37 -0300 Message-ID: Subject: [ApacheDS] Trigger in ApacheDS From: Juan Pablo Sotelo To: dev@directory.apache.org Content-Type: multipart/alternative; boundary=14dae9cdc6bb010ff804bf2355fa --14dae9cdc6bb010ff804bf2355fa Content-Type: text/plain; charset=ISO-8859-1 Hello everybody, sorry for the insistent question, but I want to know if this feature is real (I am talking about triggers), if this feature is currently working on the latest version of apacheDS (I read in a forum that is not, need confirmation)?. And if you can, give me some advices about how to syncrhonize the apacheDS with a DB?? I really want to use ApacheDS on my company but I need to solve this "problem". I hope you give me a hand. Thanks OLD Question - unanswered --------------------------------- Hello everyone, I need to know about triggers and SPs in ApacheDS in order to implement this features at work. I need them in order to create a trigger in order to synchronize a table that we have in an Oracle DB. I already created a trigger in the other way (Oracle to ldap) But I need two ways. After reading all the documentation that I found on internet I still have doubts about this features. 1- It is a posibility to write an interceptor in order to intercept the add call (or DELETE OR MODIFY) and trigger an action in java? 2- In order to add/install our new interceptor: a- Build the interceptor and generate a new jar. b- Copy the jar file to APACHEDS_INSTALLDIR/lib/ext c- ADd the interceptor to the server.xml file in APACHEDS_INSTALLDIR/conf/, fin the xml elements which list the interceptors. The easiest way to add a custom interceptor is to add a Spring bean (namespace "s"). You may set configuration properties to the interceptros as well, if it supports some. ... 3- In the documentation (ApacheDS Advanced User Guide v1.5.8-SNAPSHOT) I read information about triggers and store procedures. The information is incomplete, and I didnt understand well how to implement the triggers. In one part of the trigger section I found this: AFTER ADD CALL "Logger.logAddOperation" ($entry,$attributes,$operationPrincipal); or AFTER Delete CALL =93com.example.ldap.util.sp.BackupTools:backupDeletedEntr= y=94 ( $ldapContext =93ou=3Dbackup,ou=3Dsystem=94, $name, $deletedEntry ); a- Where I should add the line in order to create the trigger? DO I have to add that line in one attribute? Which one and how? b- Do I have to follow same steps like to build an interceptor in order to build the trigger? c- Same with SPs? 4- Can you provide me a full detail document about triggeres or SPs (maybe an example or tutorial with the implementation). Perhaps new documentation. I know that there is a new version of APacheDS, but I couldnt find documentation for this version. In fact the documentation in the Apache page is not complete. So this is why I came to you guys:) 5- While searching I found this two messages in ( http://mail-archives.apache.org/mod_mbox/directory-users/201202.mbox/%3CCAD=wPi+HseKESYBhfJim1crHdsOxOv= 3DPQzJ9eHO8h2VwYcLe33w@mail.gmail.com%3E ) a- " You also write that stored procedures are currently highly experimental. Does it mean that the code is partly there, but is not used? Are stored procedures not implemented, yet, or is there another api that I can use? Thanks" b- "SPs were in fact working a while back but heavy refactoring and changes in the server broke the code. Before going forward on this feature we're trying to erect a MVCC layer to handle internal local transactions properly to maintain consistency and isolation across the changes induced by the action of a SP. Furthermore we're redesigning the server to leverage OSGi for plugability and this is will obviously impact how SPs are deployed. These changes will take some time but it will be operational in a more robust, easy to use and dependable wail." After reading this I have this doubt "SPs and Triggers are currently working or supported? or is going to be a feature in the next versions? What about ApacheDS 1.57 (this is the version that I am using.)??" 6- Do you know a better way to synchronize LDAP with an Orable DB in ApacheDS?. 7- I know you told me that I should use persistent search to get the notifications, but as my point of view this will be an external solution, am I wrong? Thanks in advance for your time OLD Question - unanswered --------------------------------- --14dae9cdc6bb010ff804bf2355fa Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello everybody,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 sorry for the insistent question, but I want to= know if this feature is real (I am talking about triggers), if this featur= e is currently working on the latest version of apacheDS (I read in a forum= that is not, need confirmation)?. And if you can, give me some advices abo= ut how to syncrhonize the apacheDS with a DB??

I really want to use ApacheDS on my company but I need to solve this &q= uot;problem". I hope you give me a hand.

Thanks

OLD Question - unanswered ---------------------------------

Hello everyone, I need to know about triggers and SPs in ApacheDS in order = to implement this features at work. I need them in order to create a trigge= r in order to synchronize a table that we have in an Oracle DB. I already c= reated a trigger in the other way (Oracle to ldap) But I need two ways.

After reading all the documentation that I found on internet I still ha= ve doubts about this features.

1- It is a posibility to write an int= erceptor in order to intercept the add call (or DELETE OR MODIFY) and trigg= er an action in java?
2- In order to add/install our new interceptor:
=A0=A0=A0 a- Build the i= nterceptor and generate a new jar.
=A0=A0=A0 b- Copy the jar file to APA= CHEDS_INSTALLDIR/lib/ext
=A0=A0=A0 c- ADd the interceptor to the server.= xml file in
APACHEDS_INSTALLDIR/conf/, fin the xml elements which list the interceptors= . The easiest way to add a custom interceptor=A0 is to add a Spring bean (n= amespace "s"). You may set configuration properties to the interc= eptros as well, if it supports some.
=A0=A0=A0 <interceptors>
=A0=A0=A0 <normalizationInterceptor/&g= t;
=A0=A0=A0 <s:bean
class=3D3D"org.apache.directory.samples.= interceptor.pwdhash.PasswordHashInter=3D
ceptor">
=A0=A0=A0 &= lt;s:property name=3D3D"hashAlgorithm" value=3D3D"MD5" = />
=A0=A0=A0 </s:bean>
=A0=A0=A0 <authenticationInterceptor/>=A0=A0=A0 <referralInterceptor/>
=A0=A0=A0 <aciAuthorizationI= nterceptor/>
=A0=A0=A0 <defaultAuthorizationInterceptor/>
= =A0=A0=A0 <exceptionInterceptor/>
=A0=A0=A0 <operationalAttributeInterceptor/>
=A0=A0=A0 ...
=A0= =A0=A0 </interceptors>

3- In the documentation (ApacheDS Advan= ced User Guide v1.5.8-SNAPSHOT) I read information about triggers and store= procedures. The information is incomplete, and I didnt understand well how= to implement the triggers. In one part of the trigger section I found this= :

AFTER ADD CALL "Logger.logAddOperation"
($entry,$attribute= s,$operationPrincipal);

or

AFTER Delete CALL =3D93com.example= .ldap.util.sp.BackupTools:backupDeletedEntr=3D
y=3D94
( $ldapContext = =3D93ou=3D3Dbackup,ou=3D3Dsystem=3D94, $name, $deletedEntry );

=A0=A0=A0 a- Where I should add the line in order to create the trigger= ? DO I
have to add that line in one attribute? Which one and how?
=A0= =A0=A0 b- Do I have to follow same steps like to build an interceptor in or= der
to build the trigger?
=A0=A0=A0 c- Same with SPs?
4- Can you provide me a full detail document= about triggeres or SPs (maybe an example or tutorial with the implementati= on). Perhaps new documentation. I know that there is a new version of APach= eDS, but I couldnt find documentation for this version. In fact the documen= tation in the Apache page is not complete. So this is why I came to you guy= s:)

5- While searching I found this two messages in ( http:= //mail-archives.apache.org/mod_mbox/directory-users/201202.mbox/%3CCAD=3D wPi+HseKESYBhfJim1crHdsOxOv=3D3DPQzJ9eHO8h2VwYcLe33w@mail.gmail.com%3E )
=A0=A0=A0 a- " You also write that stored procedures are currently hig= hly experimental.=A0 Does it mean that the code is partly there, but is not= used? Are stored=A0 procedures not implemented, yet, or is there another a= pi that I can use? Thanks"
=A0=A0=A0 b- "SPs were in fact working a while back but heavy refactor= ing and changes in=A0 the server broke the code. Before going forward on th= is feature we're=A0 trying to erect a MVCC layer to handle internal loc= al transactions properly=A0 to maintain consistency and isolation across th= e changes induced by the=A0 action of a SP. Furthermore we're redesigni= ng the server to leverage OSGi=A0 for plugability and this is will obviousl= y impact how SPs are deployed.=A0 These changes will take some time but it = will be operational in a more robust, easy to use and dependable wail."= ;

=A0 After reading this I have this doubt "SPs and Triggers are cur= rently working or supported? or is going to be a feature in the next versio= ns? What about ApacheDS 1.57 (this is the version that I am using.)??"=

6- Do you know a better way to synchronize LDAP with an Orable DB in Ap= acheDS?.

7- I know you told me that I should use persistent search t= o get the notifications, but as my point of view this will be an external s= olution, am I wrong?

Thanks in advance for your time

OLD Question - unanswered ------= ---------------------------
--14dae9cdc6bb010ff804bf2355fa--