Highlighted
simeonof Frequent Contributor.
Frequent Contributor.
457 views

JDBC Driver - One IDV Class - Two DB Tables synchronization


We have a rather strange situation with IDM JDBC driver for Informix,
which prevents us for successfully synchronizing few IDV User Class
attributes to a table (let's call it T2), which is something like a
child table of another table (let's call it T1).

So, to give you a brief overview - in the Informix DB, there are two
tables - T1 and T2. Both tables contain columns that we need to
synchronize to the User class in IDV. T1 has a PrimaryKey column - let's
call it USRID. T2 also has a PrimaryKey column - it is also called
USRID. T2 has also a ForeignKey column USERNUMBER, which is related to
the PrimaryKey of T1. T2 has also another ForeignKey column which is
related to the PrimaryKey of a third table. T2 has other columns as well
that we're interested in.

Now, we've added the necessary attributes to the User class, made the
necessary schema mapping, added the attributes to the filter, etc. And
the result is that we can sync T1 table's attributes successfully, but
we're unable to sync T2 table's attributes. The message in the trace
is:

Unable to modify object. Table 'T2' is not a proper child of table
'T1'.

Well, since the T2 table has its own PrimaryKey, and many columns, we
suspect that the JDBC driver interprets it as a Parent Table, not a
Child, and therefore it gives the error message. Could anybody please
advise if this is the problem, and suggest a workaround (or solution).
We only need the Subscriber channel.

Cheers,
Milko


--
Simeonof
------------------------------------------------------------------------
Simeonof's Profile: https://forums.netiq.com/member.php?userid=1985
View this thread: https://forums.netiq.com/showthread.php?t=57299

Labels (1)
5 Replies
AutomaticReply Absent Member.
Absent Member.

Re: JDBC Driver - One IDV Class - Two DB Tables synchronization

Simeonof,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

These forums are peer-to-peer, best effort, volunteer run and that if your issue
is urgent or not getting a response, you might try one of the following options:

- Visit https://www.microfocus.com/support-and-services and search the knowledgebase and/or check
all the other self support options and support programs available.
- Open a service request: https://www.microfocus.com/support
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.microfocus.com)
- You might consider hiring a local partner to assist you.
https://www.partnernetprogram.com/partnerfinder/find.html

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.microfocus.com/faq.php

Sometimes this automatic posting will alert someone that can respond.

If this is a reply to a duplicate posting or otherwise posted in error, please
ignore and accept our apologies and rest assured we will issue a stern reprimand
to our posting bot.

Good luck!

Your Micro Focus Forums Team
http://forums.microfocus.com



0 Likes
Knowledge Partner
Knowledge Partner

Re: JDBC Driver - One IDV Class - Two DB Tables synchronizat

What I usually do is create a view in the database with the joined tables.
That way you only read from one place.
0 Likes
Santiago Valued Contributor.
Valued Contributor.

Re: JDBC Driver - One IDV Class - Two DB Tables synchronization

Hello

I have the same problem

Can you please tell me how you solved the problem?

Thank you
0 Likes
Knowledge Partner
Knowledge Partner

Re: JDBC Driver - One IDV Class - Two DB Tables synchronization

Have you tried Joakim's suggestion of a view combining the tables you want to use?

 

0 Likes
Santiago Valued Contributor.
Valued Contributor.

Re: JDBC Driver - One IDV Class - Two DB Tables synchronization

Hello

I managed to solve this problem. I realized that the secondary table cannot be included in the controller configuration, also (I mention this even if it may be obvious) is needed a relationship between tables with primary and foreign keys. In the mapping table I have the following configuration:

 

<?xml version="1.0" encoding="UTF-8"?><attr-name-map>
	<class-name>
		<app-name>IDM.TABLE1</app-name>
		<nds-name>User</nds-name>
	</class-name>
	<attr-name class-name="User">
		<app-name>IDENTIFICATIONNUMBER</app-name>
		<nds-name>CN</nds-name>
	</attr-name>
	<attr-name class-name="User">
		<app-name>LASTNAME</app-name>
		<nds-name>Surname</nds-name>
	</attr-name>
	<attr-name class-name="User">
		<app-name>MAIL</app-name>
		<nds-name>Internet EMail Address</nds-name>
	</attr-name>
	<attr-name class-name="User">
		<app-name>TABLE2.IDGROUP</app-name>
		<nds-name>Group Membership</nds-name>
	</attr-name>
</attr-name-map>

 

 

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.