Hello,

I have a jdbc driver which populates datas from identity vault to my
database.
Unusually and provisionally, I need to populate datas from identity vault
into database from a "modify" event of the identity vault.
But if I do this, nothing is created in my database.
System just tries to modify something with does not exist (see "UPDATE
VIEW_CVUTIL2 SET ...." in logs bellows).
But I would like an "INSERT ..." instead of an "UPDATE ..."

So I would like to transform (provisionally) my "modify" operation into an
"add" operation.
Does anybody knows if it is possible and how to do this ?
If no, how can I deal with it ?

I give you part of my transformation rule which is called and logs.
Thank you for your help,

Christine



code of rule :
<description>Creation d un agent</description>
<conditions>
<and>
<if-operation disabled="true" mode="case" op="equal">add</if-operation>
<if-operation op="equal">modify</if-operation>
</and>
</conditions>
<actions>
<do-add-dest-attr-value class-name="AlphaPerson" name="preferredName">
<arg-value type="string">
<token-upper-case>
<token-substring length="6">
<token-op-attr name="Surname"/>
</token-substring>
</token-upper-case>
<token-substring length="2">
<token-op-attr name="etdnai"/>
</token-substring>
<token-upper-case>
<token-substring length="2">
<token-op-attr name="Given Name"/>
</token-substring>
</token-upper-case>
</arg-value>
</do-add-dest-attr-value>
<do-add-dest-attr-value class-name="AlphaPerson" name="UID">
<arg-value>
<token-text xml:space="preserve">MATXXXXXXXXX</token-text>
</arg-value>
</do-add-dest-attr-value>

...

logs :

[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST:Filtering out
notification-only attributes.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST:Fixing up
association references.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST:Applying schema
mapping policies to output.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST:Applying policy:
%+C%14CMapping%-C.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'sjstat' to 'UTI_UTST'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'preferredName' to 'PK_UTI_UTCD'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'UID' to 'UTI_UTMT'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'Password Required' to 'UTI_CHPW'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'Password Expiration Time' to 'UTI_DAPW'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'sjstat' to 'UTI_UTST'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'loginActivationTime' to 'UTI_DBDA'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'Login Expiration Time' to 'UTI_FNDA'.
[10/05/07 06:05:55.859]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
attr-name 'userPassword' to 'UTI_MOPA'.
[10/05/07 06:05:55.875]:C:/Partage/Logs/AF_NC_Uti2.log ST: Mapping
class-name 'AlphaPerson' to 'VIEW_CVUTIL2'.
[10/05/07 06:05:55.875]:C:/Partage/Logs/AF_NC_Uti2.log ST:No output
transformation policies.
[10/05/07 06:05:55.875]:C:/Partage/Logs/AF_NC_Uti2.log ST:Submitting
document to subscriber shim:
[10/05/07 06:05:55.875]:C:/Partage/Logs/AF_NC_Uti2.log ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.0.20070315 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify class-name="VIEW_CVUTIL2"
event-id="PK_MATRIC=000159,table=VIEW_POP3"
qualified-src-dn="O=alphaOU=agentuniqueID=000159"
src-dn="ANNUFEDalphaagent\000159" src-entry-id="36710"
timestamp="1191557155#36">
<association state="associated">PK_UTI_UTCD=PLA
NA03RO,table=VIEW_CVUTIL2</association>
<modify-attr attr-name="UTI_UTST">
<remove-value>
<value timestamp="1191508872#62" type="string">00</value>
</remove-value>
<add-value>
<value timestamp="1191557155#22" type="string">00X</value>
</add-value>
</modify-attr>
<modify-attr attr-name="PK_UTI_UTCD">
<add-value>
<value type="string"/>
</add-value>
</modify-attr>
<modify-attr attr-name="UTI_UTMT">
<add-value>
<value>MATXXXXXXXXX</value>
</add-value>
</modify-attr>
<modify-attr attr-name="UTI_CHPW">
<add-value>
<value>0</value>
</add-value>
</modify-attr>
<modify-attr attr-name="UTI_DAPW">
<remove-all-values/>
<add-value>
<value>32503593600</value>
</add-value>
</modify-attr>
<modify-attr attr-name="UTI_UTST">
<add-value>
<value>N</value>
</add-value>
</modify-attr>
<modify-attr attr-name="UTI_DBDA">
<add-value>
<value type="time">1191557155</value>
</add-value>
</modify-attr>
<modify-attr attr-name="UTI_FNDA">
<remove-all-values/>
<add-value>
<value>32503593600</value>
</add-value>
</modify-attr>
<modify-attr attr-name="UTI_MOPA">
<remove-all-values/>
<add-value>
<value>PSC61</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
[10/05/07 06:05:55.890]:C:/Partage/Logs/AF_NC_Uti2.log ST:Connecting to
database...
[10/05/07 06:05:55.890]:C:/Partage/Logs/AF_NC_Uti2.log ST:BEGIN Open
connection.
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST:END Open
connection.
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST:Connected to
database.
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST:BEGIN Execute
connection initialization statements.
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST:END Execute
connection initialization statements.
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST:Retrieving
database metadata
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST:BEGIN Get
database properties.
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: Database name:
Oracle
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: Database
version: Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: JDBC driver
name: Oracle JDBC driver
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: JDBC driver
version: 8.1.7.1.0
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: JDBC driver
major version: 8
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: JDBC driver
minor version: 1
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: Case
sensitive: false
[10/05/07 06:05:55.953]:C:/Partage/Logs/AF_NC_Uti2.log ST: Stored case:
upper
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Association
case: upper
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Username:
'ADMSOCLE'
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supported
table types: ["SYNONYM", "TABLE"]
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supported view
types: ["SYNONYM", "VIEW"]
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
views: true
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Maximum number
of columns in select statement: unknown/unlimited
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Maximum number
of connections: unknown/unlimited
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Maximum number
of open statements: unknown/unlimited
[10/05/07 06:05:55.968]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
transactions: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
multiple transactions over multiple connections: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports mixed
DML And DDL transactions: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports only
DML transactions: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: DDL statement
in transaction forces commit: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: DDL statement
ignored in transactions: false
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
schema qualifiers in DML statements: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
schema qualifiers in procedure calls: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports batch
updates: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
retrieval of auto-generated keys: false (metadata unavailable)
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
limited outer joins: true
[10/05/07 06:05:55.984]:C:/Partage/Logs/AF_NC_Uti2.log ST: Supports
column aliasing: true
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Searching for
database descriptor file matching the runtime database.
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Loading
database descriptor file '_oracle.xml'.
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Applying
imports to driver descriptor '_oracle_jdbc.xml'.
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Applying
import '_oracle.xml'.
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'reuse-statements' Value: true
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'left-outer-join-operator' Value: '(+)'
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'add-default-values-on-view-insert' Value: false
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'current-timestamp-stmt' Value: 'SELECT (SYSDATE) FROM
SYS.DUAL'
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'include-table-filter' Value: '.*'
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'exclude-table-filter' Value: 'BIN$.{22}==$0'
[10/05/07 06:05:56.000]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'function-return-method' Value: 'dynamic'
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'use-manual-transactions' Value: true
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'minimal-metadata' Value: false
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'handle-stmt-results' Value: 'single'
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'transaction-isolation-level' Value: 'read committed'
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'use-single-connection' Value: false
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'time-translator-class' Value: 'public
com.novell.nds.dirxml.driver.jdbc.db.DBTimestamp(j ava.lang.String,java.lang.String,java.lang.String, java.lang.String)'
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'supports-schemas-in-metadata-retrieval' Value: true
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'lock-generator-class' Value: 'class
com.novell.nds.dirxml.driver.jdbc.db.lock.OraLockG enerator'
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST: Parameter:
'connection-properties' Value: ''
[10/05/07 06:05:56.015]:C:/Partage/Logs/AF_NC_Uti2.log ST:END Get
database properties.
[10/05/07 06:05:56.031]:C:/Partage/Logs/AF_NC_Uti2.log ST:BEGIN Get table
metadata.
[10/05/07 06:05:56.031]:C:/Partage/Logs/AF_NC_Uti2.log ST: Searching for
table/view 'VIEW_CVUTIL2' using type filter ["SYNONYM", "TABLE"].
[10/05/07 06:05:56.031]:C:/Partage/Logs/AF_NC_Uti2.log ST: No match.
[10/05/07 06:05:56.031]:C:/Partage/Logs/AF_NC_Uti2.log ST: Searching for
table/view 'VIEW_CVUTIL2' using type filter ["SYNONYM", "VIEW"].
[10/05/07 06:05:56.031]:C:/Partage/Logs/AF_NC_Uti2.log ST: Match found.
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST: Number of
table/view definitions cached from schema: 1
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST: Number of
syncable classes in schema: 1
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST: Cached
tables/views:
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST: VIEW_CVUTIL2
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST:END Get table
metadata.
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST:Retrieved
database metadata.
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST:BEGIN Set
transaction isolation level.
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST:END Set
transaction isolation level.
[10/05/07 06:05:56.125]:C:/Partage/Logs/AF_NC_Uti2.log ST:BEGIN
Transaction
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: UPDATE
VIEW_CVUTIL2 SET SV_UTI_UTST = ?, SV_UTI_UTMT = ?, SV_UTI_MOPA = ?,
SV_UTI_DAPW = ?, SV_UTI_CHPW = ?, SV_UTI_FNDA = ?, SV_UTI_DBDA = ?,
PK_UTI_UTCD = ? WHERE PK_UTI_UTCD = ?
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
1, field 'SV_UTI_UTST', length: 1, value = 'N'
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
2, field 'SV_UTI_UTMT', length: 12, value = 'MATXXXXXXXXX'
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
3, field 'SV_UTI_MOPA', length: 5, value = 'PSC61'
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
4, field 'SV_UTI_DAPW', value = 2999-12-31 01:00:00.0
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
5, field 'SV_UTI_CHPW', length: 1, value = '0'
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
6, field 'SV_UTI_FNDA', value = 2999-12-31 01:00:00.0
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
7, field 'SV_UTI_DBDA', value = 2007-10-05 06:05:55.0
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
8, field 'PK_UTI_UTCD', value = null
[10/05/07 06:05:56.140]:C:/Partage/Logs/AF_NC_Uti2.log ST: IN @ index
9, field 'PK_UTI_UTCD', length: 10, value = 'PLA NA03RO'
[10/05/07 06:05:56.171]:C:/Partage/Logs/AF_NC_Uti2.log ST: COMMIT
[10/05/07 06:05:56.171]:C:/Partage/Logs/AF_NC_Uti2.log ST:END
Transaction
[10/05/07 06:05:56.171]:C:/Partage/Logs/AF_NC_Uti2.log
ST:SubscriptionShim.execute() returned:
[10/05/07 06:05:56.171]:C:/Partage/Logs/AF_NC_Uti2.log ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070301_0610" instance="Noyau_CV_Uti2"
version="3.5.0">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="warning">Unable to determine whether retrieval of
auto-generated keys is supported. Defaulting to false.</status>
<status event-id="PK_MATRIC=000159,table=VIEW_POP3" level="success"/>
</output>
</nds>
[10/05/07 06:05:56.171]:C:/Partage/Logs/AF_NC_Uti2.log ST:No input
transformation policies.
[10/05/07 06:05:56.171]:C:/Partage/Logs/AF_NC_Uti2.log ST:Applying schema
mapping policies to input.
[10/05/07 06:05:56.187]:C:/Partage/Logs/AF_NC_Uti2.log ST:Applying policy:
%+C%14CMapping%-C.
[10/05/07 06:05:56.187]:C:/Partage/Logs/AF_NC_Uti2.log ST:Resolving
association references.
[10/05/07 06:05:56.187]:C:/Partage/Logs/AF_NC_Uti2.log ST:Processing
returned document.
[10/05/07 06:05:56.187]:C:/Partage/Logs/AF_NC_Uti2.log ST:Processing
operation <status> for .
[10/05/07 06:05:56.187]:C:/Partage/Logs/AF_NC_Uti2.log ST:
DirXML Log Event -------------------
Driver: ANNUFEDalphasystemEnsemble PiloteNoyau_CV_Uti2
Channel: Subscriber
Object: ANNUFEDalphaagent\000159
Status: Warning
Message: Unable to determine whether retrieval of auto-generated
keys is supported. Defaulting to false.
[10/05/07 06:05:56.187]:C:/Partage/Logs/AF_NC_Uti2.log ST:Processing
operation <status> for .
[10/05/07 06:05:56.187]:C:/Partage/Logs/AF_NC_Uti2.log ST:
DirXML Log Event -------------------
Driver: ANNUFEDalphasystemEnsemble PiloteNoyau_CV_Uti2
Channel: Subscriber
Object: ANNUFEDalphaagent\000159
Status: Success
[10/05/07 06:05:56.203]:C:/Partage/Logs/AF_NC_Uti2.log ST:End transaction.