Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: OT ? for people who know other databases besides Oracle
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
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 ?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: stephane_paquette_at_yahoo.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seley, Linda INET: LSeley_at_IQNavigator.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Sun INET: mikeny31_at_speakeasy.org 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 Fri Feb 02 2001 - 22:27:49 CST