RE: Object-Oriented Tools

[Johnston, Tim]

Title: RE: Object-Oriented Tools

You could also code your own data access layer from within the application...  That way all database access is done through this limited set of code...  Which is nice if you ever need to do things like change the schema, fix a bug or migrate to a new DBMS...

 

Tim

-----Original Message-----
From: Aponte, Tony [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Object-Oriented Tools

We used it many moons ago with version 7.32.  It turned out to be more complicated to administer and code than we ever anticipated so it was put to pasture.  You're right in that many of the OO functionality is included in the newer versions,  and what's not can be provided with Java in the database.  We acquired it as a means to keep the database access code agnostic of the DBMS used but it suffered from (self-inflicted) poor implementation.  Eventually, the conclusion was reached that the cost of this agnosticism was ridiculous and the whole Persistence layer was eliminated from the application.  The client connections go straight to the database via Net8.  One additional side-effect was that we can use all of the Oracle security features available where as before the application handled the user account privileges in the Persistence layer.  This gave us visibility over who/what/where/how data was being manipulated.

HTH
Tony Aponte

-----Original Message-----
From: Carle, William T (Bill), NLCIO [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Object-Oriented Tools

Hi,

    We use a product called Persistence that takes C++ code and makes the
Oracle (or any relational) database look like an object-oriented database.
Does anyone else use these sorts of tools? I'm not an object-oriented guru
by any means so forgive me if I sound a bit vague. Isn't Oracle capable of
doing the same thing? What is the best tool for this?

Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), NLCIO
  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).