Ada95 in business (database) software

Ada95 in business (database) software

[Mark Wallace]

Is anyone using Ada95 for database-oriented business applications?  Does
either of the principal commercial compilers (Aonix, GNAT) have a decent
(i.e., better than ODBC) interface to Oracle?  My team is evaluating
Ada95 and Eiffel for a new development effort, and we are having a hard
time identifying any sort of track record for Ada95 in this category
(business/database) of application.  All the Ada95 "buzz" seems to be
related to device drivers and embedded controller software.

We're willing to swim upstream with regard to non-mainstream languages,
because we care deeply about software quality.  However, we have neither
the expertise nor the funding to (re)create low-level code such as
database interface modules.

TIA,

Mark

P.S.  If you want to reply directly, use my <first_name>.<last_name> to
the left of the at-sign.

Re: Ada95 in business (database) software

[Adrian Knoth]

Mark Wallace <no.spam@verizon.net> wrote:

> Is anyone using Ada95 for database-oriented business applications?  

Me, but not to that extend you might want to do.

> either of the principal commercial compilers (Aonix, GNAT) have a decent
> (i.e., better than ODBC) interface to Oracle?  

Did you take a look at gnade.sf.net?


-- 
mail: adi@thur.de  	http://adi.thur.de	PGP: v2-key via keyserver

Lieber 'ne Latte in der Hose als ein Brett vorm Kopf.

Re: Ada95 in business (database) software

[Preben Randhol]

Mark Wallace wrote:
> 
> We're willing to swim upstream with regard to non-mainstream languages,
> because we care deeply about software quality.  However, we have neither
> the expertise nor the funding to (re)create low-level code such as
> database interface modules.

You can have a look at GNADE => http://gnade.sourceforge.net/

-- 
Preben Randhol ---------------- http://www.pvv.org/~randhol/ --
"Violence is the last refuge of the incompetent", Isaac Asimov

Re: Ada95 in business (database) software

[Poul-Erik Andreasen]

On Sun, 09 Feb 2003 05:58:31 GMT
Mark Wallace <no.spam@verizon.net> wrote:

> Is anyone using Ada95 for database-oriented business applications?  Does
> either of the principal commercial compilers (Aonix, GNAT) have a decent
> (i.e., better than ODBC) interface to Oracle?  My team is evaluating
> Ada95 and Eiffel for a new development effort, and we are having a hard
> time identifying any sort of track record for Ada95 in this category
> (business/database) of application.  All the Ada95 "buzz" seems to be
> related to device drivers and embedded controller software.
> 
> We're willing to swim upstream with regard to non-mainstream languages,
> because we care deeply about software quality.  However, we have neither
> the expertise nor the funding to (re)create low-level code such as
> database interface modules.

I don't know if anyone are using this but you kan have a look:

http://www.redrocketconsortium.com/zbc/

 

-- 
Poul-Erik Andreasen

Re: Ada95 in business (database) software

[Dmitriy Anisimkov]

"Mark Wallace" <no.spam@verizon.net> wrote in message
news:3E45EE04.280EC800@verizon.net...
> Is anyone using Ada95 for database-oriented business applications?  Does
> either of the principal commercial compilers (Aonix, GNAT) have a decent
> (i.e., better than ODBC) interface to Oracle?


Mark,

You could take a look to the Ada 95 to the (Oracle Call Interface).
http://vagul.tripod.com/adaoci.html
It is also including to the GNADE.
http://gnade.sourceforge.net/

I'm intensively using it in the business application development.
I know some other russian developers using it too.
Frankly, there is no good documentation. But there is a good example showing
the main functionality,
and you can ask me directly.

Re: Ada95 in business (database) software

[Peter Amey]

Mark Wallace wrote:
> 
> Is anyone using Ada95 for database-oriented business applications?  Does
> either of the principal commercial compilers (Aonix, GNAT) have a decent
> (i.e., better than ODBC) interface to Oracle?  My team is evaluating
> Ada95 and Eiffel for a new development effort, and we are having a hard
> time identifying any sort of track record for Ada95 in this category
> (business/database) of application.  All the Ada95 "buzz" seems to be
> related to device drivers and embedded controller software.
> 
> We're willing to swim upstream with regard to non-mainstream languages,
> because we care deeply about software quality.  However, we have neither
> the expertise nor the funding to (re)create low-level code such as
> database interface modules.
> 

A significant chunk of a secure system we developed in SPARK and Ada 95
involved SQL links to a database.  See "Correctness by Construction -
Developing a Commercial Secure System" in IEEE Software Jan/Feb 2002
pp18-25.  (Also in PDF on www.sparkada.com under publications).  ISTR we
wrote the binding ourselves but that it wasn't hard.

Peter

Re: Ada95 in business (database) software

[Mark Wallace]

Peter Amey wrote:
> 
> Mark Wallace wrote:
> >
> > Is anyone using Ada95 for database-oriented business applications?  Does
> > either of the principal commercial compilers (Aonix, GNAT) have a decent
> > (i.e., better than ODBC) interface to Oracle?  My team is evaluating
> > Ada95 and Eiffel for a new development effort, and we are having a hard
> > time identifying any sort of track record for Ada95 in this category
> > (business/database) of application.  All the Ada95 "buzz" seems to be
> > related to device drivers and embedded controller software.
> >
> > We're willing to swim upstream with regard to non-mainstream languages,
> > because we care deeply about software quality.  However, we have neither
> > the expertise nor the funding to (re)create low-level code such as
> > database interface modules.
> >
> 
> A significant chunk of a secure system we developed in SPARK and Ada 95
> involved SQL links to a database.  See "Correctness by Construction -
> Developing a Commercial Secure System" in IEEE Software Jan/Feb 2002
> pp18-25.  (Also in PDF on www.sparkada.com under publications).  ISTR we
> wrote the binding ourselves but that it wasn't hard.
> 
> Peter

I read this article (from your Web site), and, while I found it very
interesting, didn't see any mention of database or SQL.

Mark

Re: Ada95 in business (database) software

[Dmitry A. Kazakov]

On Sun, 09 Feb 2003 05:58:31 GMT, Mark Wallace <no.spam@verizon.net>
wrote:

>Is anyone using Ada95 for database-oriented business applications?  Does
>either of the principal commercial compilers (Aonix, GNAT) have a decent
>(i.e., better than ODBC) interface to Oracle?  My team is evaluating
>Ada95 and Eiffel for a new development effort, and we are having a hard
>time identifying any sort of track record for Ada95 in this category
>(business/database) of application.  All the Ada95 "buzz" seems to be
>related to device drivers and embedded controller software.
>
>We're willing to swim upstream with regard to non-mainstream languages,
>because we care deeply about software quality.  However, we have neither
>the expertise nor the funding to (re)create low-level code such as
>database interface modules.

I am using GNADE (its ODBC binding) with GNAT. GNADE is fine [but ODBC
and its implementations is a real disaster] 

AFAIK, GNADE supports Oracle through native interface .

---
Regards,
Dmitry Kazakov
www.dmitry-kazakov.de

Re: Ada95 in business (database) software

[Wojtek Narczynski]

Mark Wallace <no.spam@verizon.net> wrote in message news:<3E45EE04.280EC800@verizon.net>...
> Is anyone using Ada95 for database-oriented business applications?  Does
> either of the principal commercial compilers (Aonix, GNAT) have a decent
> (i.e., better than ODBC) interface to Oracle? 

Oracle 7 used to have an Ada precompiler PRO*Ada. 

Now there is this SQL*Module beast. 

Looks good, but I haven't tested it yet.

Regards,
Wojtek

Re: Ada95 in business (database) software

[Frank Piron]

Wojtek Narczynski wrote:
> 
> Oracle 7 used to have an Ada precompiler PRO*Ada.
>
> Now there is this SQL*Module beast.
Last year i tried to get some information concerning
SQL*Module, but our ORACLE-Distributor here in Munich
said: "This is Army Stuff and not available for _normal_
       customers!"
I have not enough time and nerves to refuse or confirm
this above Statement - you know that ORACLE is a big
company and you will phone all the day to get a bit of
information.
In our ORACLE-Distribution i found only the Documentation
for modada ( the precompiler ), but not the executable.

Frank

Re: Ada95 in business (database) software

[David Botton]

I have used Oracle via ADO using GNATCOM working with huge (10s of millions
of rows) databases on call center apps very successfully. I've also created
a number of small apps using GWindows and its database components for
rapidly creating database front ends.

David Botton


----- Original Message -----
From: "Mark Wallace" <no.spam@verizon.net>
Newsgroups: comp.lang.ada
To: <comp.lang.ada@ada.eu.org>
Sent: Sunday, February 09, 2003 12:58 AM
Subject: Ada95 in business (database) software


> Is anyone using Ada95 for database-oriented business applications?  Does
> either of the principal commercial compilers (Aonix, GNAT) have a decent
> (i.e., better than ODBC) interface to Oracle?  My team is evaluating
> Ada95 and Eiffel for a new development effort, and we are having a hard
> time identifying any sort of track record for Ada95 in this category
> (business/database) of application.  All the Ada95 "buzz" seems to be
> related to device drivers and embedded controller software.
>
> We're willing to swim upstream with regard to non-mainstream languages,
> because we care deeply about software quality.  However, we have neither
> the expertise nor the funding to (re)create low-level code such as
> database interface modules.
>
> TIA,
>
> Mark
>
> P.S.  If you want to reply directly, use my <first_name>.<last_name> to
> the left of the at-sign.
> _______________________________________________
> comp.lang.ada mailing list
> comp.lang.ada@ada.eu.org
> http://ada.eu.org/mailman/listinfo/comp.lang.ada

Re: Ada95 in business (database) software

[Mark Wallace]

Mark Wallace wrote:
> 
> Is anyone using Ada95 for database-oriented business applications?  Does
> either of the principal commercial compilers (Aonix, GNAT) have a decent
> (i.e., better than ODBC) interface to Oracle?  My team is evaluating
> Ada95 and Eiffel for a new development effort, and we are having a hard
> time identifying any sort of track record for Ada95 in this category
> (business/database) of application.  All the Ada95 "buzz" seems to be
> related to device drivers and embedded controller software.
> 
> We're willing to swim upstream with regard to non-mainstream languages,
> because we care deeply about software quality.  However, we have neither
> the expertise nor the funding to (re)create low-level code such as
> database interface modules.
> 
> TIA,
> 
> Mark
> 
> P.S.  If you want to reply directly, use my <first_name>.<last_name> to
> the left of the at-sign.

Thanks to everyone who replied.

Mark