[3594] in comp.os.os2.announce archive

home help back first fref pref prev next nref lref last post

FREEWARE: ORexx/SQL Object Framework

daemon@ATHENA.MIT.EDU (John Blumel)
Sun Nov 23 14:17:47 1997

To: os2ann.DISCUSS@bloom-picayune.MIT.EDU
Date: 23 Nov 1997 13:05:00 -0400
From: jblumel@acm.org (John Blumel)
Reply-To: jblumel@acm.org

Reply-to:     jblumel@acm.org
[Followups directed to comp.os.os2.programmer.tools]
---------------------------------------------------------------------
Version 1.0 of the ORexx/SQL Object Framework is available for download
from:

    http://www.tmc.tulane.edu/jblumel/orexxsql.zip

The following excerpt from the framework's ReadMe file explains what the
framework is.
_____________________________________________________________________________
                          ORexx/SQL Object Framework
                       Copyright (C) 1997, John Blumel.
                      ----------------------------------

+ What is the ORexx/SQL Object Framework?

The ORexx/SQL Object Framework is a set of ORexx classes which encapsulate
Mark Hessling's Rexx/SQL interface to SQL databases available from:
    http://www.lightlink.com/hessling/

The Rexx/SQL interface provides cross platform (OS/2, UNIX, Win 95/NT), RDBMS
independent (too many to list here, see the web page) access to SQL databases
through a loadable external rexx library. The ORexx/SQL Object Framework
extends this functionality by providing an extensible Object Oriented
interface to Rexx/SQL. The Framework further simplifies SQL database access
by managing database connections and queries for the programmer and through
its built in error handling facilities.

The framework can be used in two ways, either as an OO wrapper for the
Rexx/SQL interface or as a Streams based interface to a SQL database. Either
of these interfaces can be used as the basis for more complex, reusable,
application specific classes.

When used as wrapper classes, you create connection, table and result table
objects as needed and use the methods provided by these objects to query and
update database tables. This gives you access to the entire functionality of
the Rexx/SQL interface.

When using the Streams interface, you create SQLStream objects which create
and manage other SQL objects as needed. SQLStream objects allow you to access
a database using an interface similar to that which standard Stream objects
provide.

In addition to providing an OO interface to Rexx/SQL, the classes have built
in exception handling which can be customized or overridden. Using the
Framework's exception handling eliminates the need for inline error checking
and allows the programmer to write code which is easier to read and maintain.

--
John Blumel
jblumel@acm.org
_____________________________________________________________________
| NOTE: Please send submissions by EMAIL os2_ann_req@bix.com
| Correspondence to the COOA Moderator: lfirrantello@bix.com .
| Please see: http://www.bix.com/pub/os2ann/pindex.htm for posting guidelines

home help back first fref pref prev next nref lref last post