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 X-Google-Attributes: gid103376,public From: jerry@jvdsys.nextjk.stuyts.nl (Jerry van Dijk) Subject: Re: Question: Ada and databases, what do other use? Date: 1998/07/13 Message-ID: #1/1 X-Deja-AN: 371263911 References: <6obpk0$8ev@drn.newsguy.com> Organization: * JerryWare *, Leiden, Holland Newsgroups: comp.lang.ada Date: 1998-07-13T00:00:00+00:00 List-Id: nabbasi@earthlink.net wrote: : What tools/API's/packages are there for using Ada to access Databases such : as Oracle or Sybase, using SQL and ODBC? If you check the PAL you will find several solutions, none of which I personally liked. If your system supports OBDC, why not use that ? At least on Win32 the binding is standard. : 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. I've used a Q&D interface to JDBC connecting to MSql on Linux, this worked quite nicely. Perhaps we should do a Ada version of the java.sql package. Does anyone know if this interface is copyrighted ? You might try this yourself using one of the Java to Ada converters floating around. : 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 Mmmm, only two years back I tried to use Pro-Ada, but it was horrible, and the Oracle support people didn't have a clue. I hope this situation has been improved. : I guess what I am asking is what are people experience in using : Ada with databases? A lot of do-it-yourself work. However, once you have your packages, you can get _real_ reuse. : Is Ada used much in this field? Too little, of course. But it is used, as Oracle's Pro-Ada shows. For Sybase, binding to SQLLib is rather easy. ODBC isn't difficult either. The PAL offers several more generic solutions. : Should I just forget the idea of using Ada in the area? No, it just takes a little more work to get all the components all lined up, that's all. : 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. IMHO: Yes, this situation reminds me of 'Hands Rule'. Hand being a US judge who formulated a simple rule to determine what the punishment for a crime should be. He reasoned that a potentional criminal weigths the possible benifits from a crime against the potential punishment and the percieved change of getting caught. The operative word here is 'percieved'. As long as manufacturers percieve that no-one is using Ada, they are not going to support it. Users percieve that Ada is not being used since no-one is supporting it. The question for many years has been (and actual again with the dropping of the mandate and the disappearence of the AJPO) how to solve this catch-22 situation. It used to be that the defense industry provided enough benifit to outweight the percieved lack of other interest, hence the heavy emphasis on embedded and real-time work. With this benifit going, we will need need to work on the 'percieved' part again to regain a healthy balance. So, let your (Ada) vendors know you need Ada support. (Ahh, sorry, sometimes my judicial mind gets the better of me, I'm not accusing Ada vendors and users of being potentional criminals :-) Jerry. -- -- Jerry van Dijk | email: jdijk@acm.org -- Leiden, Holland | member Team-Ada -- Ada & Win32: http://stad.dsl.nl/~jvandyk