GNU Ada 95 Database Developement Environment - (GNADE)

Version 0.9i

Editor M.Erdmann

4.4.2001

Content

This release provides a thin binding to the ODBC interfaces, an embedded SQL translator which processes Ada 95 sources with embedded SQL, some basic documentation and some sample code demonstrating the basic functionality of the package. This release supports the first time MySQL database for Linux and Windows.

This release is targeted for the operating systems Linux, Solaris and Windows NT/2000 Systems.

The software and documentation of this release is contained in the following files:

File Size in Bytes Contents
gnade-src-0.9i.tar.gz 235762 Complete GNADE distribution GNU compressed tar file
gnade-src-0.0i.zip 406511 Complete GNADE distribution as ZIP file.

Restrictions

The configure script is known to fail on Solaris 8 and other operating system.

Copyright, License and Authors

The GNU Public License (GPL) applies with the following extension to all software components in this release

As a special exception, if other files instantiate generics from GNADE Ada units, or you link GNADE Ada units or libraries with other files to produce an executable, these units or libraries do not by itself cause the resulting executable to be covered by the GNU General Public License. This exception does not however invalidate any other reasons why the executable file might be covered by the GNU Public License.

The documentation has been put under the Free GNU Documentation License.

These are the authors and copyright holders of the GNADE software:

Jürgen Pfeifer juergen.pfeifer@gmx.net>
Michael Erdmann Michael.Erdmann@snafu.de412931
Sune Falck sunef@hem.passagen.se

Contact

Bug Reports http://sourcefore.net/projects/gnade M.Erdmann
GNADE Discussions http://cert.uni-stuttgart.de/mailman/listinfo/gnade-dev Florian Weimer
Project Page http://gnade.sourceforge.net/

http://sourcefore.net/projects/gnade

M.Erdmann
Dev. Coordination Michael.Erdmann@snafu.de M.Erdmann

Fixed Problems

Bug Ref. Version

Short Description

Comments
411143 0.9g configure does not fail. The configure.in script has been updated and aborts if the library check failes or one of the GNAT components is missing
412931 0.9h Ada compiler not found On FreeBSD and Solaris the ada compiler is not found even it is there. The configuration procedure assumes the name of the compiler based on the build OS name.
412885 0.9h Distribution not instalable on Solaris A prebuild version of the configure script was missing. If the target system does not support autoconf, the files in ./autoconf should never touched.
412884 0.9h HTML Documentation files where missing The prebuild version of the documentation was missing. The make dist traget has been changed.
413658 0.9i MyODBC 2.50.36 failes with 0.9h The offending SQL primitive has been removed.
413660 0.9i Long_String looks not nice Patch from Sune Falck has been inserted

Known Problems

Bug Ref. Short Description Comments
411141 Missing ";" for "EXEC SQL DECLARE DB01 D This problem may be bypassed by putting a semicolon

in the source code.

The documentation is only distributed as HTML format, because the pdf files generated by docbook are faulty.

Installation

The installation of this software requires the following components:

Component Version Origin
gzip GNU
unzip GNU
zip
tar
autoconf*1 2-13-9 GNU
make 3.79.1 GNU
gnat 1.13p ALT distribution
gawk GNU

Note 1:

autconf is only required on Linux/Unix Systems for windows a special set of makefiles is provided.

Installation on Linux/Unix

In order to install the GNADE release perform the following steps:

$ gunzip -c gnade-src-linux-gnu-<version>.tar.gz | tar xvf -
$ cd gnade-src-linux-gnu-<version>
$ ./configure <dbname>

Depending on the installation of the data base you have specified in the configure script command, you have to execute the following step either by using a DBA account our you may use your own user account.

$ su ..dba..
$ make createuser

After the creation of the data base user, the final build may be done by:

$ make

If this installation procedure failes you may use the Makefile under ./win32. This makefile is known to work at least on Solaris well if the correct driver manager is installed (see section other components).

Installation on Windows NT

For window users a zip file is provided. In order to install perform the following steps:

> unzip gnade-src-linux-gnu-<version>.zip
> cd gnade-src-linux-gnu-<version>/win32
> make 
                                   
The issue regarding the installation of a data base user has to be dony by hand. 
The windows makefile  uses the make.conf file which is prebuild by the ./configure script. Any configuration
change has to be done there. Please refere to the README file in ./win32.

Other components

The following Driver Manager are known to work with the release:

Component Description Version Operating System Comments
iODBC ODBC Driver Manager 3.50 Solaris 8 www.iodbc.org
unixODC ODBC Driver Manager 1.8.12-2 Linux www.unixodbc.org


The following data base products are known to work with this release:
Component Description Version Operating System Distribution/Source of the release
Postgres Postgres Database 3.50 Linux RedHat 7.0
Lunix SuSe 7.0
Windows NT
MySQL MySQL Database

MyODBC

3.23.22

2.50.36-1

Linux www.mysql.com
MySQL Database

MyODBC

3.23.35a

2.50.36

Windows 2000 www.mysql.com

Contributions

Special regards to the following persons which have contributed to the project:

Florian Weimer Florian.Weimer@RUS.Uni-Stuttgart.DE
François Fabien. fr.fabien@infonie.fr
Pascal Obry p.obry@wanadoo.fr