Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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...
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Tim
<FONT face=Tahoma
size=2>-----Original Message-----From: Aponte, Tony
[mailto:AponteT_at_hsn.net]Sent: Thursday, October 25, 2001 2:29
PMTo: Multiple recipients of list ORACLE-LSubject: 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 [<A
href="">mailto:wcarle_at_att.com] <FONT
size=2>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. <FONT
size=2>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 <FONT
size=2>Database Administrator 816-995-3922
wcarle_at_att.com
![]() |
![]() |