Highlighted
Absent Member.
Absent Member.

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


Hi Will, thanks for your great support.
I did the schema refresh action. In the schema mapping, I can browse to
the childtable (account) with the columns. So thats fine.

Here is the log from starting the driver a do a sync.
The log is too big the post, so I placed it external:
http://tinyurl.com/b6onhnj


--
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/21/2013 3:54 AM, gschouten32 wrote:
>
> Hi Will, thanks for your great support.
> I did the schema refresh action. In the schema mapping, I can browse to
> the childtable (account) with the columns. So thats fine.
>
> Here is the log from starting the driver a do a sync.
> The log is too big the post, so I placed it external:
> http://tinyurl.com/b6onhnj
>
>

crap. I think I remember the deal now.
Let me confirm against the docs and I'll let you know.
0 Likes
Highlighted
Absent Member.
Absent Member.

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

OK, first my apologies for not picking up on this from the outset.
Not having the database in front of me it didn't click when I was visualizing it.

This is just not going to work the way you want it to with that table structure. A child table can
contain only a single attribute that is sync'd to that table. A child table is used to represent a
multivalued attribute in eDirectory. One child table for EACH multivalued attribute. Here is the
doc that references child tables:
https://www.netiq.com/documentation/idm402drivers/jdbc/data/b87s0aj.html#b87s0aw
It's not pointed out clearly in my opinion as it doesn't clarify that until the VERY last sentence
in that section.

Also in your trace there actually is a warning about it:
<status level="warning">Child table 'Account' should have 1 syncable column(s) instead of 5.</status>

So where do you go from here? You have two options:
1. If the table structure is one that you have built and changing it is possible, split that table
into two tables. Since the data in those columns is related to each other this is a potentially
complicated table structure to build however as you will need constraints between the child tables
then to tie it all together.

2. Switch to the "direct" method and use a view (this is what I would suggest) You will create a
view following the column naming convention here:
https://www.netiq.com/documentation/idm402drivers/jdbc/data/b87s0b4.html#b87s0bc
Then you will need to create an instead of trigger on the view to do the actual insert in the
underlying tables. Don't worry, it's not as hard as it sounds.

Let me know how you want to go, take a stab at it, and we'll work through the details then.

On 2/21/2013 3:54 AM, gschouten32 wrote:
>
> Hi Will, thanks for your great support.
> I did the schema refresh action. In the schema mapping, I can browse to
> the childtable (account) with the columns. So thats fine.
>
> Here is the log from starting the driver a do a sync.
> The log is too big the post, so I placed it external:
> http://tinyurl.com/b6onhnj
>
>


0 Likes
Highlighted
Absent Member.
Absent Member.

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


Ok, now it's clear for me how indirect mode in combination with tables
is working. So indeed, that's not the way to go.
I configured a new driver in direct mode and created a SQL-view. Now I
am at the point to create the triggers inside this view. That looks a
little bit difficult for a non-database administrator.
Tomorrow I let your know about this trigggers.

Thanks again!


--
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 created a insert trigger for the view (with two tables):
http://tinyurl.com/by8aveg

Is this correct code for the insert? It's working fine.


--
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/26/2013 10:04 AM, gschouten32 wrote:
>
> I created a insert trigger for the view (with two tables):
> http://tinyurl.com/by8aveg
>
> Is this correct code for the insert? It's working fine.
>
>

You are definitely on the right track. That is the correct approach and as you said if it is
working then that really tells you 🙂
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.