We do all of our inserts, updates & deletes through stored procedures and
it works great. We found java to be to slow and like the centralized
approach of putting everything in Oracle. At the time we decided this the
notion of eliminating the ND front end as some point in the future and/or
allowing other types of interfaces to our application also drove us to move
as much into Oracle as possible.
Brian
[EMAIL PROTECTED] on 06/04/99 06:07:58 AM
To: [EMAIL PROTECTED]
cc: (bcc: Brian Hurysz/NYISO)
Subject: Re: [ND] Using Stored procedures for transaction management
That's true. But I must admit I really miss Oracle's handy DECODE!
Thx for replying.
JT
(Embedded
image moved Curt Springer <[EMAIL PROTECTED]>
to file: 06/04/99 03:39 AM
pic24330.pcx)
To: [EMAIL PROTECTED]
cc: (bcc: Janet Traub/IS/SSC/THD)
Subject: Re: [ND] Using Stored procedures for transaction management
That route will be more attractive when (and yes, it's coming or here
already, depending on dbms and version) one is able to write stored
procedures in vanilla java and not some bastardized proprietary extension
of SQL.
-- Curt
At 01:40 AM 6/4/99 -0400, [EMAIL PROTECTED] wrote:
>
>
>
>I'm not used to using stored procedures but recently I was looking over
some
>one's ND4 code (for an app that talks to Informix 7) and I noticed that
stored
>procedures were used whenever a series of INSERT/DELETEs needed to be
executed
>as a transaction. That looked like a smart coding technique to me, and I'd
like
>to get other opinions.
>
>Do you recommend using SPs like that? Pros/cons?
>
>Thanks!
>Janet
>
>
>_________________________________________________________________________
>
>For help in using, subscribing, and unsubscribing to the discussion
>forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
>For dire need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
pic24330.pcx
