If anyone could help me with this I would be great.

I am trying to build out a new JDBC driver that will on delete of a
User Account in eDirectory it will perform an insert query of the
UID,GivenName, Surname, WorkforceID. To a database table here is my XML
Code when it performs the attributes are empty.

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE policy PUBLIC
"policy-builder-dtd" "C:\Program Files
(x86)\Novell\Designer\eclipse\plugins\com.novell.i dm.policybuilder_3.0.1.200907230249\DTD\dirxmlscri pt3.6.dtd"><policy>
<rule>
<description>User Deletion</description>
<conditions>
<and>
<if-operation mode="case" op="equal">delete</if-operation>
<if-class-name mode="nocase" op="equal">User</if-class-name>
<if-attr mode="nocase" name="workforceID" op="not-equal"/>
<if-src-dn disabled="true"
op="in-container">slu\Guests\Guest</if-src-dn>
</and>
</conditions>
<actions>
<do-set-local-variable name="passwd" scope="driver">
<arg-string>
<token-text xml:space="preserve">Id</token-text>
<token-substring length="6" start="3">
<token-attr name="workforceID"/>
</token-substring>
</arg-string>
</do-set-local-variable>
<do-append-xml-element expression="/nds/input"
name="jdbc:statement"/>
<do-append-xml-element expression="/nds/input/jdbc:statement"
name="jdbc:sql"/>
<do-append-xml-text
expression="/nds/input/jdbc:statement/jdbc:sql[1]">
<arg-string>
<token-text xml:space="preserve">INSERT INTO dbo.ExpiredUsers
</token-text>
<token-text
xml:space="preserve">(WORKFORCEID,UID,GIVENNAME,SU RNAME,PASSWD)
VALUES ('</token-text>
<token-attr name="workforceID"/>
<token-text xml:space="preserve">', '</token-text>
<token-attr name="uid"/>
<token-text xml:space="preserve">', '</token-text>
<token-attr name="givenname"/>
<token-text xml:space="preserve">', '</token-text>
<token-attr name="surname"/>
<token-text xml:space="preserve">', '</token-text>
<token-local-variable name="passwd"/>
<token-text xml:space="preserve">')</token-text>
</arg-string>
</do-append-xml-text>
</actions>
</rule>
</policy>

Please Help.


--
sguilfor
------------------------------------------------------------------------
sguilfor's Profile: http://forums.novell.com/member.php?userid=47833
View this thread: http://forums.novell.com/showthread.php?t=421665