GNU Ada 95 Database Development Environment - (GNADE)
Version 1.1.1
Editor M.Erdmann
20.5.2001
This is the first source code release of the GNADE project for production releases with the following features:
The release is intended for building with the GNU Ada Translator on the platforms Linux, Solaris and Windows NT/2000.
The GNADE code and the documentation in HTML, PDF and postscript format is delivered in the following files:
File | Size in Bytes | Contents |
gnade-src-1.1.1.tar.gz | 461738 | Complete GNADE distribution GNU compressed tar file |
gnade-src-1.1.1.zip | 643597 | Complete GNADE distribution as ZIP file. |
gnade-1.1.1.exe | 948254 | Windows NT setup contains only the binaries and the libraries of the GNADE project. |
RPM files are available via the Ada Linux Team for SuSe and Redhat Linux
Even the GNADE project except for the native data base bindings is expected to work with all ODBC compliant data base products. The following products are known to work with GNADE assuming, that you are using the correct driver manager (see section "Other Components").
Component | Description | Version | OS | Distribution/Source of the release | ||||
Postgres | PostgreSQL Database | 7.0.3 |
|
www.postgresql.org | ||||
Mimer | Mimer SQL RDBMS | 8.2 |
|
www.mimer.com | ||||
MySQL | MySQL Database MyODBC |
3.23.22
2.50.36-1 |
Linux | www.mysql.com | ||||
3.23.35a
2.50.36 |
Windows 2000 | www.mysql.com |
The GNADE project installation procedure provides for theses product test data bases. If your data base is not listed below, the GNADE project will be very likely usable but the test data base has to be installed manually.
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.
The authors and copyright holders of the GNADE project are:
Jürgen Pfeifer | juergen.pfeifer@gmx.net> |
Michael Erdmann | Michael.Erdmann@snafu.de |
Sune Falck | sunef@hem.passagen.se |
Bug Reports | http://sourcefore.net/projects/gnade | M.Erdmann |
GNADE Discussions | http://cert.uni-stuttgart.de/mailman/listinfo/gnade-dev
gnade-dev@cert.uni-stuttgart.de |
Florian Weimer |
Project Page | http://gnade.sourceforge.net/
http://sourcefore.net/projects/gnade |
M.Erdmann |
Dev. Coordination | Michael.Erdmann@snafu.de | M.Erdmann |
Bug Ref. | Fixed with Version | Short Description | Comments |
411143 | 0.9g | configure does not fail. | The configure.in script has been updated and aborts if the library check fails 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 installable on Solaris | A prebuilt 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 prebuilt version of the documentation was missing. The make dist target has been changed. |
413658 | 0.9i | MyODBC 2.50.36 fails 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 |
413687 | 0.9j | test sample generates exception | Change in esql_support. Pointer not initialized. |
414349 | 0.9k | cp fails on Solaris | Depending on the OS, different options are used for the cp command. |
414350 | 0.9k | Install not found on Solaris | The autoconf specific fallback procedures are used which means the install-sh script will be used in case of problems. |
414351 | 0.9k | configure terminates on Solaris with error | The -e parameter for the test command is not supported by Solaris. The parameter -f seems to be more commonly supported. |
413687 | 0.9k | test sample generates exception | A patch has been received from Mr. Obry solving the problem in esql_support.adb. |
414526 | 0.9k | configure - make directories executed | ./configure checks the result of autoconf/configure |
414583 | 0.9k | Wrong error message for errors in sql qu | Patch from S. Falck added. |
415224 | 0.9m | V0.9l windows example are not build | GNUmakefile from S. Falck added |
416018 | 0.9m | Misstyped online help | esql updated. |
421587 | 0.9o | ObjectAda Unrestricted_Access not supported. | Unrestricted access is not used any more. |
425280 | 1.1.1 | Name of esql not changed every where | GNUmakefile updated |
425409 | 1.1.1 | sql_standard prefix not handled correct | gesql updated |
425410 | 1.1.1 | whenever sqlwarning faulty | gesql updated |
425510 | 1.1.1 | gpl.sgml missing in distribution | MANIFEST updated |
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. |
421586 | ODBC does not compile with ObjectAda |
This is a problem with the Object Ada compiler which has to be fixed there. |
425279 | GNUmake on Windows 95 does not work | S. Falck is looking for a work around |
435712 | Wrong debug code generated | Do not use -debugcode flag. The bug will be corrected asap. |
The installation of this software requires the following components:
Component | Version | Origin |
gzip | 1.2.4 | GNU |
unzip | 5.42 | Infozip |
zip | 2.2 | Infozip |
tar | - | GNU or native |
autoconf*1 | 2-13-9 | GNU |
make | 3.79.1 | GNU |
gnat | 3.13p | ALT distribution |
gawk | 3.0.3 | GNU |
The autoconf utility is only required on Linux/Unix Systems if the configuration scripts have to be changed. For window systems a special set of makefiles in the directory ./win32 is provided which are not using the autoconf facility.
$ gunzip -c gnade-src-linux-gnu-<version>.tar.gz | tar xvf -
$ cd gnade-src-linux-gnu-<version>
$ ./configure <dbname>
As dbname the following values are allowed.
If the value is omitted, all subsequent steps regarding the data base installation may be skipped.
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 database and the database user has been configured, the ODBC interface has to be configured. The directory ./samples/sample_db contains sample files for the unixODBC driver manager. The files odbc.ini.sample odbcinst.ini.sample have to be copied to /etc/odbc.ini and /etc/ odbcinst.ini.sample.
After the creation of the data base user, the final build may be done by:
$ make
Test code is located under ./samples. In order to test the functionality of the ODBC interface use the examples in ./odbc or ./esql.
If this installation procedure fails 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).
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 done by hand. The windows makefile uses the make.conf file which is prebuilt by the ./configure script. Any configuration change has to be done there. Please refer to the README file in ./win32.
The following Driver Manager are known to work with the release:
Component | Description | Version | Operating System | Comments |
unixODC | ODBC Driver Manager | 1.8.12-2 | Linux | www.unixodbc.org |
2.0.5 | Solaris 8 | www.unixodbc.org |
The iODBC 3.04 implementation on Solaris seems to have a problem with the handling of cursor states. It should not be used.
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 |