Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!indetech!rec From: rec@indetech.com (Rick Cobb) Newsgroups: comp.databases Subject: Re: C++ Interface to SQL Message-ID: <1991Jan27.210419.21218@indetech.com> Date: 27 Jan 91 21:04:19 GMT References: <1991Jan24.034312.20923@infonode.ingr.com> Reply-To: rec@indetech.UUCP (Rick Cobb) Distribution: comp.databases Organization: Independence Technologies, Inc. Fremont, CA Lines: 52 I've tried to reply by mail, but keep getting "tensmekl... User unknown" Apologies for the blatant commercialism.... In article <1991Jan24.034312.20923@infonode.ingr.com> you write: >Has anybody come up with either a C++ base object for manipulating Oracle >tables or a good C data/method hiding module source set. One of the problems >with dealing with Pro*C and C++ is that each set thinks that it's the only >preprocessor to Old C. Has anyone come up with a good set of makefile rules >for dealing with this combination? > >Thanks for the help. > > >-- >Kermit Tensmeyer | Intergraph Corporation >UUCP: ...uunet!ingr!tensmekl | One Madison Industrial Park >INTERNET: tensmekl@ingr.com | Mail Stop LR23A2 >AT&T: (205)730-8127 | Huntsville, AL 35807-4201 Yes, we have a way to do this. Since we're an OLTP shop, we use a class generator rather than a base class. The generator provides a class for your table that supports insert/update/delete/etc., allows you to set up multiple where clauses, provides an iterator across the return set for queries, etc. It is possible to use it to provide "lazy joins", where foreign key relationships aren't computed until you ask for that particular instance variable. In addition, other optimizations and runtime checks are performed: o special methods are required to set primary key fields. o updates which won't change any values aren't sent to the database o assignments to uninitialized or unselected tuples are caught. o etc. The mapping between C++ types and PRO*C types for the instance variables is managed by a kind of class called a "mapper", which can be used to handle translations like Oracle date/time to UNIX date/time, etc. We provide an extensive library of mappers with the product. We currently support it for PRO*C for Oracle 6.0.{26,27,30} on a variety of Unix machines. We sell this as one of the components of our "iTRAN" transaction processing application development suite; it's called "iDBIO" ("dbiogen" internally). For more details, call Bob Fultz at 415 438 2027; his netaddress is bfultz@indetech.com -- ____*_ Rick Cobb rcobb@indetech.com, \ / / Independence Technologies {sun,pacbell,sharkey}!indetech!rcobb \/ / 42705 Lawrence Place FAX: (US) 415 438 2034 \/ Fremont, CA 94538 Phone: (US) 415 438 2004