From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.3 required=5.0 tests=BAYES_00,INVALID_MSGID
	autolearn=no autolearn_force=no version=3.4.4
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 103376,efcaa9d9abd780dc,start
X-Google-Attributes: gid103376,public
From: nabbasi@earthlink.net
Subject: Question: Ada and databases, what do other use?
Date: 1998/07/12
Message-ID: <6obpk0$8ev@drn.newsguy.com>#1/1
X-Deja-AN: 370875837
Organization: Newsguy News Service [http://www.newsguy.com]
Newsgroups: comp.lang.ada
Date: 1998-07-12T00:00:00+00:00
List-Id: <comp.lang.ada>


hi,

I'd like to learn from others who use Ada for Database access.

What tools/API's/packages are there for using Ada to access Databases such
as Oracle or Sybase, using SQL and ODBC? I was hoping maybe I can
find something for Ada similar to the solutions avaliable for Java
such as the "JDBC" API that comes with Java JDK, and thefree
ODBC drivers from Oracle for use with Java. 

Now, I am using the JDBC API (java.sql package) that comes with JDK 
and using the Oracle Java driver that one can download free 
from Oracle webpage. 

I would really like to use Ada instead of Java to write my
client application, (I just can;t stand java string manipulation
routines, and lack of control over parameter passing mechanism, etc..
but that is another story).
 
I can use the Ada pro-compiler that Oracle provides, to compile
Ada program with SQL in it, but not sure how to use GNAT with all of
this, (this is on Solaris) and also I prefer to use ODBC type connection 
to the database so that my client application is portable. Also, I want
my application to run without changes on NT and Unix systems.

I guess what I am asking is what are people  experience in using
Ada with databases? Is Ada used much in this field? Should I just
forget the idea of using Ada in the area? I've allready got my
Java application connection to oracle up using only few lines
of code thanks for Oracle documentations and the free driver they
provide and the sql package that comes with Java, I just think that
Ada (if the tools are there) will be a better langauge to use.

I wish Ada had all the support from the industry that Java has. I think
Ada is simply ignored by software providers, which makes it hard to use
it to do usefull things with it, even though the basic language itself is
great.

thanks,
Nasser