Linda,
I'd like take a stab at your problem.
Disclaimer first, I started out as an Oracle DBA/Developer
years ago, now I work on front end OO development (Java)
as well. Yes, I went through the somewhat painful experience to
change my mindset from a relational world to an object one,
and now I am at peace with both.
As you have already stated, one of the design goals is to be able to
port your application to other RDBMS in the future, it appears
to me that the obvious choice to put as little business/application
logic into the database as possible. In stead, you should rely
on a much more portable language, like Java, to implement
those logics. Does that make sense?
If so, triggers are out, stored procesdures are definitely out
(unless you want to keep two copies, one in PL/SQL, the other in
Transact SQL). I will just rely on application layer pass in
in-line SQL (ANSI standard) to achieve the maximum
portability.
Now that portability has been achieved, you may ask about
performance. We may have to open another thread
just to deal with this issue alone.
In any case, I am proud of being a Java developer that knows
about db schema and SQL tuning. So, guys, no flames, plz.
Michael
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 3:32 PM
If you find where it can get set either in init.ora or in another session
(i.e. I'd like to set it against a running Java connection), please let me
know!
Thanks!
Linda
-----Original Message-----
Sent: Wednesday, January 31, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L
Thanks Jared,
I knew it was there somewhere.
Unfortunately the fips flagging is at the session
level only in Oracle 816.
Do you remember if it was at the database level on
early Oracle 7 version ?
--- [EMAIL PROTECTED] a écrit : >
> Look in the Oracle SQL Reference Manual for 'FIPS'.
> It's in the
> index. This will give you the info on maintaining
> compatibility
> with ANSI standard SQL.
>
> Jared
>
> On Tue, 30 Jan 2001, Seley, Linda wrote:
>
> > Our Java users are concerned that there may be a
> possibility that their code
> > may have to work on top of a variety of databases.
> We use Oracle in-house
> > but we, theoretically, may sell our product to
> another company that uses
> > something else besides Oracle. Our product would
> then have to talk with
> > their database. What, then, are the advantages
> and disadvantages of using
> > views, procedures, triggers, etc. What would buy
> us the most portability?
> > What headaches might we just have to deal with
> because there is no way
> > around it?
> >
> > Any insights would be greatly welcomed. Feel free
> to email me privately at
> > [EMAIL PROTECTED]
> >
> > Thanks!
> >
> > Linda
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Seley, Linda
> > INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
=====
Stephane Paquette
DBA Oracle
[EMAIL PROTECTED]
__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seley, Linda
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Sun
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
