Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:3rd Party Java and Oracle Triggers
ED,
I'll agree with you, not knowing exactly what that app is doing could create all kinds of havoc. Also, if the database as laid down by the vendor does not have RI inside the DB doing so may cause the application to cease functioning. That is because (like PeopleSoft for instance) they enforce the RI inside the application and may populate the child records before the parents. This will cause your RI triggers to fail. What may be a better idea is to replicate the desired tables from the third party db into your Oracle financials DB and then do whatever populating of the Oracle financials is required.
Dick Goulet
____________________Reply Separator____________________ Author: Ed Maurer <EMaurer_at_acquirex.com> Date: 8/6/2001 10:05 AM
In the course of customizing one of our 3rd party apps that uses Entity Beans to do multiple inserts to some tables, It has been decided we'd use triggers on the tables to do some RI logic and insert essentially duplicate data into another database - Oracle Financials interface, to be exact,
I've been opposed to this methodology, on the grounds that nobody here can tell me exactly how this app is behaving in the first place. I've heard that some beans do stupid (sic) things like insert a row, then update each column in the course of a single transactional insert, thus requiring both insert and update triggers; performance could be nightmarish, assuming we don't hit 4091 errors even trying to write the code.
Unfortunately, without some hard facts, I'm going to have a hard time convincing anyone this is bad practice. And without tools to see exactly how the object(s) behaving, I won't be able to prove it on our development platforms either.
Anyone have any experience here, or ideas for tools (besides packet capture) that can assist ?
TIA Ed Maurer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2479.6" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><SPAN class=718244416-06082001><FONT size=1>In the course of customizing
one of our 3rd party apps that uses</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Entity Beans to do multiple
inserts to some tables, It has been </FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>decided we'd use triggers on
the tables to do some RI logic and</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>insert essentially duplicate
data into another database - Oracle</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Financials interface, to be
exact,</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>I've been opposed to this
methodology, on the grounds that</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>nobody here can tell me exactly
how this app is behaving </FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>in the first place. I've heard
that some beans do stupid (sic) things like</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>insert a row, then update each
column in the course of a single</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>transactional insert, thus
requiring both insert and update triggers;</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>performance could be
nightmarish, assuming we don't hit 4091</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>errors even trying to write the
code.</FONT></SPAN></DIV>
development platforms either.</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Anyone have any experience
here, or ideas for tools </FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>(besides </FONT></SPAN><SPAN
class=718244416-06082001> <FONT size=1>packet capture) that can assist
?</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>TIA</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Ed
Maurer</FONT></SPAN></DIV></BODY></HTML>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Aug 06 2001 - 12:16:56 CDT
![]() |
![]() |