Highlighted
Absent Member.
Absent Member.
699 views

JDBC (MSSQL 2008 R2) and PK GUID association


I'm trying to make a sync to a MSSQL 2008 R2 Database by the JDBC
driver.
The PK in database has datatype uniqueIdentifier which does not allow
Nulls, and should be filled with the object guid from the user in the
Vault.
How does this association process works? Should I do schema-mapping, or
is this functionality in the driver?

Now I see in the following in de log:
Cannot insert the value NULL into column 'xxx'

column xxx is my PK an so this message is clear for me, but how can I
fill this with the object GUID.


--
gschouten32
------------------------------------------------------------------------
gschouten32's Profile: https://forums.netiq.com/member.php?userid=2546
View this thread: https://forums.netiq.com/showthread.php?t=46714

Labels (1)
0 Likes
17 Replies
Highlighted
Knowledge Partner
Knowledge Partner

Re: JDBC (MSSQL 2008 R2) and PK GUID association

On 2/5/2013 10:34 AM, gschouten32 wrote:
>
> I'm trying to make a sync to a MSSQL 2008 R2 Database by the JDBC
> driver.
> The PK in database has datatype uniqueIdentifier which does not allow
> Nulls, and should be filled with the object guid from the user in the
> Vault.
> How does this association process works? Should I do schema-mapping, or
> is this functionality in the driver?
>
> Now I see in the following in de log:
> Cannot insert the value NULL into column 'xxx'
>
> column xxx is my PK an so this message is clear for me, but how can I
> fill this with the object GUID.


So there is config setting in the driver config about how you set the
Primary key value. Things like next value in sequence. You would need
to use the GUID. Side note, GUID is often a binary format and you want
the LibAJC (in IDM 361 driver, and in a common package in IDM4) to use
the es:guid2association() to convert to a more stringy format.

I would have to go look and see, since i forget offhand how much control
you have over the Primary Key. Worst case, just add an <association>
node with the value you want in your <add> event.


0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association


I used es:guid2association() so that works fine now.
But now have some problems with the child table. That table has also a
PK which has to be filled manually.
So the relationship with the PK from the parent table is mapped to
foreign key on the child table.
In an event to the child table, the PK off the child table is filled,
but still the error >Cannot insert the value NULL into colum 'childtable
pk'


--
gschouten32
------------------------------------------------------------------------
gschouten32's Profile: https://forums.netiq.com/member.php?userid=2546
View this thread: https://forums.netiq.com/showthread.php?t=46714

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association

On 2/11/2013 9:34 AM, gschouten32 wrote:
>
> I used es:guid2association() so that works fine now.
> But now have some problems with the child table. That table has also a
> PK which has to be filled manually.
> So the relationship with the PK from the parent table is mapped to
> foreign key on the child table.
> In an event to the child table, the PK off the child table is filled,
> but still the error >Cannot insert the value NULL into colum 'childtable
> pk'
>
>

This is a tricky thing. Despite begging and pleading the developers decided that if a table has a
primary key it is a parent table and not a child table. This is eluded to in the docs here:
https://www.netiq.com/documentation/idm402drivers/jdbc/data/bvttvxu.html

The work around for this is to change the schema sync mode.
In the driver configuration switch to using the Table\View Names method of the database scoping.
The tag name is 'sync-tables' and its use is documented here:
https://www.netiq.com/documentation/idm402drivers/jdbc/data/b1pu3ie.html#b1pu3kx

Then specify only the parent tables and not the child tables in the comma delimited list.

Dorked up I know. It was argued ad nauseam in bug 668324 if you want a long read. Nevertheless
they decided to address it with documentation updated instead. Although it looks like they have
since been watered down.
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association


Thanks for your reply. I'm going to check the docs and test the
suggested solution.


--
gschouten32
------------------------------------------------------------------------
gschouten32's Profile: https://forums.netiq.com/member.php?userid=2546
View this thread: https://forums.netiq.com/showthread.php?t=46714

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association


Ok, I've that part working now. Now I've got a following question about
filling this child table.

Schema mapping:

vaultattribute1 -> childtable1.sqlcolumn1
vaultattribute2 -> childtable1.sqlcolumn2
and so on.
So I've got multiple rows in this childtable.

Now, when a ADD event occur, the row a inserted separately in multiple
rows and not in one row.
In the log, I see this multiple inserts:

INSERT INTO dbo.childtable1(GUID, sqlcolumn1) VALUES (?, ?)

and later

INSERT INTO dbo.childtable1(GUID, sqlcolumn2) VALUES (?, ?)

But I want on a ADD event, one row with these multiple columns filled,
like:

INSERT INTO dbo.childtable1(GUID, sqlcolumn1, sqlcolumn2) VALUES (?, ?,
?)

How can I achieve that?


--
gschouten32
------------------------------------------------------------------------
gschouten32's Profile: https://forums.netiq.com/member.php?userid=2546
View this thread: https://forums.netiq.com/showthread.php?t=46714

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association

I'm going to need more info to tell you why the driver is doing that. Specifics as to the parent
table and the child table in question including their keys is a must. The driver reads the metadata
and generates the queries based upon it so it could be the underlying structure.

Then we need to see the XDS events that are generating the SQL. So please post the trace of what
you are describing and we can dig further.

On 2/19/2013 7:34 AM, gschouten32 wrote:
>
> Ok, I've that part working now. Now I've got a following question about
> filling this child table.
>
> Schema mapping:
>
> vaultattribute1 -> childtable1.sqlcolumn1
> vaultattribute2 -> childtable1.sqlcolumn2
> and so on.
> So I've got multiple rows in this childtable.
>
> Now, when a ADD event occur, the row a inserted separately in multiple
> rows and not in one row.
> In the log, I see this multiple inserts:
>
> INSERT INTO dbo.childtable1(GUID, sqlcolumn1) VALUES (?, ?)
>
> and later
>
> INSERT INTO dbo.childtable1(GUID, sqlcolumn2) VALUES (?, ?)
>
> But I want on a ADD event, one row with these multiple columns filled,
> like:
>
> INSERT INTO dbo.childtable1(GUID, sqlcolumn1, sqlcolumn2) VALUES (?, ?,
> ?)
>
> How can I achieve that?
>
>


0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association


Ensure the primary key column name is named like "PK_GUID" or something
like that ... PK_ should be the prefix. See if that works


--
vivekbm
------------------------------------------------------------------------
vivekbm's Profile: https://forums.netiq.com/member.php?userid=528
View this thread: https://forums.netiq.com/showthread.php?t=46714

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association


Also ensure the child table's PK column's name is something like FK_....


--
vivekbm
------------------------------------------------------------------------
vivekbm's Profile: https://forums.netiq.com/member.php?userid=528
View this thread: https://forums.netiq.com/showthread.php?t=46714

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association


Here's the log from a sync/add event:

DirXML: [02/20/13 16:27:39.72]: TRACE: Acquired lock on connection
'dedicated0'.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Transaction
DirXML: [02/20/13 16:27:39.72]: TRACE: Old auto commit: true
DirXML: [02/20/13 16:27:39.72]: TRACE: New auto commit: false
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Handle ADD.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Interpret event.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Interpret event.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Get primary key value(s)
from event.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Get primary key value(s)
from event.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row into parent
table 'dbo.employee'.
DirXML: [02/20/13 16:27:39.72]: TRACE: Not locking.
DirXML: [02/20/13 16:27:39.72]: TRACE: INSERT INTO
dbo.employee(IdM_GUID, BSN, Initials, FirstName, BirthName, Lastname,
Prefix, PartnerName, PartnerPrefix) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Instantiate prepared
statement.
DirXML: [02/20/13 16:27:39.72]: TRACE: Allocating statement from
connection ConnectionID:94.
DirXML: [02/20/13 16:27:39.72]: TRACE: Allocated statement
SQLServerPreparedStatement:6519.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Instantiate prepared
statement.
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 1, field
'IdM_GUID', length: 36, value = 'B32A20FF-56E0-a047-A6D2-88644A74FACA'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 2, field 'BSN',
length: 8, value = '0000001'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 3, field
'Initials', length: 2, value = 'X'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 4, field
'FirstName', length: 7, value = 'yyyy'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 5, field
'BirthName', length: 8, value = 'xxxx'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 6, field
'Lastname', length: 8, value = 'xxxxx'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 7, field
'Prefix', value = null
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 8, field
'PartnerName', value = null
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 9, field
'PartnerPrefix', value = null
DirXML: [02/20/13 16:27:39.72]: TRACE: Closed statement
SQLServerPreparedStatement:6519.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row into parent
table 'dbo.employee'.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row(s) into child
table 'dbo.Account'.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row.
DirXML: [02/20/13 16:27:39.72]: TRACE: Not locking.
DirXML: [02/20/13 16:27:39.72]: TRACE: INSERT INTO
dbo.Account(IdM_GUID, EmailAddress) VALUES (?, ?)
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Instantiate prepared
statement.
DirXML: [02/20/13 16:27:39.72]: TRACE: Allocating statement from
connection ConnectionID:94.
DirXML: [02/20/13 16:27:39.72]: TRACE: Allocated statement
SQLServerPreparedStatement:6520.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Instantiate prepared
statement.
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 1, field
'IdM_GUID', length: 36, value = 'B32A20FF-56E0-a047-A6D2-88644A74FACA'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 2, field
'EmailAddress', length: 23, value = 'email@domain.com'
DirXML: [02/20/13 16:27:39.72]: TRACE: Closed statement
SQLServerPreparedStatement:6520.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row(s) into child
table 'dbo.Account'.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row(s) into child
table 'dbo.Account'.
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row.
DirXML: [02/20/13 16:27:39.72]: TRACE: Not locking.
DirXML: [02/20/13 16:27:39.72]: TRACE: INSERT INTO
dbo.Account(IdM_GUID, AccountName) VALUES (?, ?)
DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Instantiate prepared
statement.
DirXML: [02/20/13 16:27:39.72]: TRACE: Allocating statement from
connection ConnectionID:94.
DirXML: [02/20/13 16:27:39.72]: TRACE: Allocated statement
SQLServerPreparedStatement:6521.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Instantiate prepared
statement.
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 1, field
'IdM_GUID', length: 36, value = 'B32A20FF-56E0-a047-A6D2-88644A74FACA'
DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 2, field
'AccountName', length: 9, value = 'account1'
DirXML: [02/20/13 16:27:39.72]: TRACE: Closed statement
SQLServerPreparedStatement:6521.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row(s) into child
table 'dbo.Account'.
DirXML: [02/20/13 16:27:39.72]: TRACE: END Handle ADD.
DirXML: [02/20/13 16:27:39.73]: TRACE: COMMIT
DirXML: [02/20/13 16:27:39.73]: TRACE: END Transaction
DirXML: [02/20/13 16:27:39.73]: TRACE: Released connection lock.
DirXML: [02/20/13 16:27:39.73]: TRACE: Number of statements allocated
on connection 'dedicated0': 0.
DirXML: [02/20/13 16:27:39.73]: TRACE: Remote Loader:
SubscriptionShim.execute() returned:
DirXML: [02/20/13 16:27:39.73]: TRACE: <nds dtdversion="2.0"
ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">

dbo.employee is the parent table
dbo.account is the childtable.
Synchronization filter: include by table/view name
Table or view names: dbo.employee


--
gschouten32
------------------------------------------------------------------------
gschouten32's Profile: https://forums.netiq.com/member.php?userid=2546
View this thread: https://forums.netiq.com/showthread.php?t=46714

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association


additional config:

dbo.employee is the parent table
dbo.account is the childtable.
Synchronization filter: include by table/view name
Table or view names: dbo.employee

DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'sync-filter'
Value: 'list'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'sync-schema'
Value: 'dbo'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'sync-tables'
Value: [dbo.employee]
DirXML: [02/20/13 16:37:44.35]: TRACE: Driver is schema-aware.
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'force-username-case' Value: null
DirXML: [02/20/13 16:37:44.35]: TRACE: The current Database Name :
MSSQL
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'server'
Value:
'jdbc:sqlserver://131.224.130.85:1433;databaseName=IdentityMgtStoreVWS_TEST;integratedSecurity=false'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'user'
Value: 'idm'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'connection-properties' Value: ''
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'reuse-statements'
Value: [descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'use-manual-transactions' Value: [descriptor or
metadata-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'transaction-isolation-level' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'use-single-connection' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'max-conn-retry'
Value: -1
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'preserve-sql-whitespace' Value: false
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'minimal-metadata'
Value: [descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'handle-stmt-results' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Instantiating connection tester
from jdbc driver descriptor file '_ms_sqlserver_2005_jdbc.xml'.
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'connection-tester-class' Value:
'com.novell.nds.dirxml.driver.jdbc.util.connect.JDBCConnectionTester'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'enable-refs'
Value: true
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'enable-meta-identifiers' Value: true
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'left-outer-join-operator' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'include-table-filter' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'exclude-table-filter' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'function-return-method' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'state-dir'
Value: '.'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'supports-schemas-in-metadata-retrieval' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter:
'column-position-comparator' Value:
'com.novell.nds.dirxml.driver.jdbc.util.config.comp.StringByteComparator'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'time-syntax'
Value: '1'
DirXML: [02/20/13 16:37:44.35]: TRACE: Parameter: 'enable-locking'
Value: false
DirXML: [02/20/13 16:37:44.36]: TRACE: Remote Loader: DriverShim.init()
returned:
DirXML: [02/20/13 16:37:44.36]: TRACE: <nds dtdversion="2.0"
ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">

<subscriber-options>
<disable display-name="Disable subscriber?">_</disable>
<ignore10 display-name="Show primary key
parameters?">show</ignore10>
<key-gen-method display-name="Generation/retrieval method
(table-global):">_</key-gen-method>
<key-gen-timing display-name="Retrieval timing
(table-global):">_</key-gen-timing>
<key-gen display-name="Method and timing (table-local):"></key-gen>
<disable-locking display-name="Disable statement-level
locking?">0</disable-locking>
<check-update-count display-name="Check update
counts?">_</check-update-count>
<add-default-values-on-view-insert display-name="Add default values
on view insert?">_</add-default-values-on-view-insert>
</subscriber-options
</init-params>
</input>
</nds>
DirXML: [02/20/13 16:37:44.36]: TRACE: Parameter: 'disable'
Value: false
DirXML: [02/20/13 16:37:44.36]: TRACE: Parameter: 'key-gen'
Value: null
DirXML: [02/20/13 16:37:44.36]: TRACE: Parameter: 'key-gen-timing'
Value: 'before'
DirXML: [02/20/13 16:37:44.36]: TRACE: Parameter: 'key-gen-method'
Value: 'subscription event (default)'
DirXML: [02/20/13 16:37:44.36]: TRACE: Parameter: 'check-update-count'
Value: true
DirXML: [02/20/13 16:37:44.36]: TRACE: Parameter:
'add-default-values-on-view-insert' Value:
[descriptor-dependent]
DirXML: [02/20/13 16:37:44.36]: TRACE: Parameter: 'disable-locking'
Value: false
DirXML: [02/20/13 16:37:44.36]: TRACE: Remote Loader:
SubscriptionShim.init() returned:
DirXML: [02/20/13 16:37:44.36]: TRACE: <nds dtdversion="2.0"
ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">


--
gschouten32
------------------------------------------------------------------------
gschouten32's Profile: https://forums.netiq.com/member.php?userid=2546
View this thread: https://forums.netiq.com/showthread.php?t=46714

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: JDBC (MSSQL 2008 R2) and PK GUID association

I need the XDS doc from right before this so I can see what event is being translated into this.

Something also to try, remove the two child table attributes from the schema mapping policy. Save.
Then do a schema refresh in designer. Then add them back to the schema map as the detected values
from the schema refresh using the drop downs in the schema mappings. If they don't show up in the
drop down then we know we need to back up a step.

On 2/20/2013 10:14 AM, gschouten32 wrote:
>
> Here's the log from a sync/add event:
>
> DirXML: [02/20/13 16:27:39.72]: TRACE: Acquired lock on connection
> 'dedicated0'.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Transaction
> DirXML: [02/20/13 16:27:39.72]: TRACE: Old auto commit: true
> DirXML: [02/20/13 16:27:39.72]: TRACE: New auto commit: false
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Handle ADD.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Interpret event.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Interpret event.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Get primary key value(s)
> from event.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Get primary key value(s)
> from event.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row into parent
> table 'dbo.employee'.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Not locking.
> DirXML: [02/20/13 16:27:39.72]: TRACE: INSERT INTO
> dbo.employee(IdM_GUID, BSN, Initials, FirstName, BirthName, Lastname,
> Prefix, PartnerName, PartnerPrefix) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Instantiate prepared
> statement.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Allocating statement from
> connection ConnectionID:94.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Allocated statement
> SQLServerPreparedStatement:6519.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Instantiate prepared
> statement.
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 1, field
> 'IdM_GUID', length: 36, value = 'B32A20FF-56E0-a047-A6D2-88644A74FACA'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 2, field 'BSN',
> length: 8, value = '0000001'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 3, field
> 'Initials', length: 2, value = 'X'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 4, field
> 'FirstName', length: 7, value = 'yyyy'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 5, field
> 'BirthName', length: 8, value = 'xxxx'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 6, field
> 'Lastname', length: 8, value = 'xxxxx'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 7, field
> 'Prefix', value = null
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 8, field
> 'PartnerName', value = null
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 9, field
> 'PartnerPrefix', value = null
> DirXML: [02/20/13 16:27:39.72]: TRACE: Closed statement
> SQLServerPreparedStatement:6519.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row into parent
> table 'dbo.employee'.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row(s) into child
> table 'dbo.Account'.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Not locking.
> DirXML: [02/20/13 16:27:39.72]: TRACE: INSERT INTO
> dbo.Account(IdM_GUID, EmailAddress) VALUES (?, ?)
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Instantiate prepared
> statement.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Allocating statement from
> connection ConnectionID:94.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Allocated statement
> SQLServerPreparedStatement:6520.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Instantiate prepared
> statement.
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 1, field
> 'IdM_GUID', length: 36, value = 'B32A20FF-56E0-a047-A6D2-88644A74FACA'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 2, field
> 'EmailAddress', length: 23, value = 'email@domain.com'
> DirXML: [02/20/13 16:27:39.72]: TRACE: Closed statement
> SQLServerPreparedStatement:6520.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row(s) into child
> table 'dbo.Account'.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row(s) into child
> table 'dbo.Account'.
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Insert row.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Not locking.
> DirXML: [02/20/13 16:27:39.72]: TRACE: INSERT INTO
> dbo.Account(IdM_GUID, AccountName) VALUES (?, ?)
> DirXML: [02/20/13 16:27:39.72]: TRACE: BEGIN Instantiate prepared
> statement.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Allocating statement from
> connection ConnectionID:94.
> DirXML: [02/20/13 16:27:39.72]: TRACE: Allocated statement
> SQLServerPreparedStatement:6521.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Instantiate prepared
> statement.
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 1, field
> 'IdM_GUID', length: 36, value = 'B32A20FF-56E0-a047-A6D2-88644A74FACA'
> DirXML: [02/20/13 16:27:39.72]: TRACE: IN @ index 2, field
> 'AccountName', length: 9, value = 'account1'
> DirXML: [02/20/13 16:27:39.72]: TRACE: Closed statement
> SQLServerPreparedStatement:6521.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Insert row(s) into child
> table 'dbo.Account'.
> DirXML: [02/20/13 16:27:39.72]: TRACE: END Handle ADD.
> DirXML: [02/20/13 16:27:39.73]: TRACE: COMMIT
> DirXML: [02/20/13 16:27:39.73]: TRACE: END Transaction
> DirXML: [02/20/13 16:27:39.73]: TRACE: Released connection lock.
> DirXML: [02/20/13 16:27:39.73]: TRACE: Number of statements allocated
> on connection 'dedicated0': 0.
> DirXML: [02/20/13 16:27:39.73]: TRACE: Remote Loader:
> SubscriptionShim.execute() returned:
> DirXML: [02/20/13 16:27:39.73]: TRACE: <nds dtdversion="2.0"
> ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
>
> dbo.employee is the parent table
> dbo.account is the childtable.
> Synchronization filter: include by table/view name
> Table or view names: dbo.employee
>
>


0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.