Hi,

I've got a very simple driver that is writing a few fields out to an SQL
table on a couple of triggers, its working but i'm getting strange results.
Could someone have a quick look at the code to see if i'm doing something
silly:-

<?xml version="1.0" encoding="UTF-8"?><policy xmlns:jdbc="urn:dirxml:jdbc">
<rule>
<description>Audit Table SQL INSERT - Challenge response
change</description>
<conditions>
<and>
<if-class-name op="equal">User</if-class-name>
<if-op-attr name="pwmResponseSet" op="changing"/>
</and>
</conditions>
<actions>
<do-append-xml-element expression="/nds/input" name="jdbc:statement"/>
<do-set-xml-attr expression="/nds/input/jdbc:statement" name="jdbc:type">
<arg-string>
<token-text xml:space="preserve">update</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement"
name="jdbc:transaction-type">
<arg-string>
<token-text xml:space="preserve">manual</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement"
name="jdbc:transaction-id">
<arg-string>
<token-text xml:space="preserve">1</token-text>
</arg-string>
</do-set-xml-attr>
<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 SSPREvents ( EventDate,
EventUser, EventType, EventHotID) VALUES ( '</token-text>
<token-time format="!SHORT.DATETIME" tz="Europe/London"/>
<token-text xml:space="preserve">' , '</token-text>
<token-attr name="CN"/>
<token-text xml:space="preserve">' , '</token-text>
<token-text xml:space="preserve">Responses updated</token-text>
<token-text xml:space="preserve">' , '</token-text>
<token-attr name="bHOTID"/>
<token-text xml:space="preserve">' )</token-text>
</arg-string>
</do-append-xml-text>
<do-break/>
</actions>
</rule>
<rule>
<description>Audit Table SQL INSERT - Password change</description>
<conditions>
<and>
<if-op-attr name="nspmDistributionPassword" op="changing"/>
</and>
</conditions>
<actions>
<do-append-xml-element expression="/nds/input" name="jdbc:statement"/>
<do-set-xml-attr expression="/nds/input/jdbc:statement" name="jdbc:type">
<arg-string>
<token-text xml:space="preserve">update</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement"
name="jdbc:transaction-type">
<arg-string>
<token-text xml:space="preserve">manual</token-text>
</arg-string>
</do-set-xml-attr>
<do-set-xml-attr expression="/nds/input/jdbc:statement"
name="jdbc:transaction-id">
<arg-string>
<token-text xml:space="preserve">1</token-text>
</arg-string>
</do-set-xml-attr>
<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 SSPREvents ( EventDate,
EventUser, EventType, EventHotID) VALUES ( '</token-text>
<token-time format="!SHORT.DATETIME" tz="Europe/London"/>
<token-text xml:space="preserve">' , '</token-text>
<token-attr name="CN"/>
<token-text xml:space="preserve">' , '</token-text>
<token-text xml:space="preserve">Password updated</token-text>
<token-text xml:space="preserve">' , '</token-text>
<token-attr name="bHOTID"/>
<token-text xml:space="preserve">' )</token-text>
</arg-string>
</do-append-xml-text>
<do-break/>
</actions>
</rule>
</policy>

Cheers,
Matt