Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Anonymous_User Absent Member.
Absent Member.
143 views

JDBC Oracle Driver: Syncing to views


Hello people,

I'm working on a JDBC Oracle driver for a client, that syncs to views
and I have an instead of trigger for inserting the fields into the
production table.
I'd like to know since what version of IDM and Oracle this functionality
is officially supported.

Thanks in advance


--
mmarchese
------------------------------------------------------------------------
mmarchese's Profile: https://forums.netiq.com/member.php?userid=1311
View this thread: https://forums.netiq.com/showthread.php?t=46320

Labels (1)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: JDBC Oracle Driver: Syncing to views


Not sure what you mean by officially supported. I've been setting up
configurations like you describe for years. In this configuration it
would be considered a triggerless direct link. NetIQ supports it up
until you leave the driver through the shim, then it's up to Oracle to
support the functions of the view and instead-of triggers.


--
pcook
------------------------------------------------------------------------
pcook's Profile: https://forums.netiq.com/member.php?userid=429
View this thread: https://forums.netiq.com/showthread.php?t=46320

0 Likes
wcscis Absent Member.
Absent Member.

Re: JDBC Oracle Driver: Syncing to views

On 12/4/2012 6:34 AM, mmarchese wrote:
>
> Hello people,
>
> I'm working on a JDBC Oracle driver for a client, that syncs to views
> and I have an instead of trigger for inserting the fields into the
> production table.
> I'd like to know since what version of IDM and Oracle this functionality
> is officially supported.
>
> Thanks in advance
>
>

It predates version 2 at least but given that 3.6.1 is the oldest under pseudo support and that real
support is only versions 4+ I would guess it depends on your definition of support.

Instead of triggers have been in Oracle for more than a decade so you shouldn't have any issue there
either.
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.