1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
|
GNat Ada Database Environment (GNADE)
====================================
Introduction
============
The GNADE projects provides tools and support packages in
order to allow easy access to different data base systems
using Ada 95 (specially the GNU Ada 95 compiler).
The integration of SQL into Ada 95 is supported by an
embedded SQL translator which generates code working on
top of the GNADE ODBC bindings.
The GNADE ODBC bindings are a thin Ada 95 binding to
ODBC.
The projects provides additionaly native bindings
to PostgreSQL and MySQL.
Liecense/Authors
================
Generaly speeking is GNADE an open source project. For details
please refere to the ./COPYING and the ./AUTHORS file in this
directory.
Platforms
==========
This software is known to operate on:
- Linux SuSe and Redhat distribution
- Windows NT
- Solaris
Installation
============
The installation process is done in three steps:
Step 1 - Installation of the development environment.
Building all libraries and executables of the
GNADE environment.
Step 2 - Verification of the functionality
Step 3 - Installation of the GNADE products globally.
Step 1 - Installation of the GNADE environment
After obtaining and unpacking the distribution into a
directory, perform the following step to create the
GNADE environment:
cd ./gnade
./configure [-debug] [-assert] <database_type>
Currently the database_type = postgres, mysql and
mimer (for MimerSQL) are supported.
All testprograms do require a small sample database. In
order to use the database you have to create a user for
your data base. Because this step has often to be done using
a different user id and it is only done once you have
to perform the following steps manualy:
[ su db-adminstrator ]
make createuser
[ exit ]
After installing the data base user you may run the
global makefile by simply entering:
make
This will produce the libraries for the ODBC binding,
the esql translator and a sample data base which is used
by the examples under ./samples.
The following directories will be created:
autoconf - This directory contains all
autoconf specific files.
bin-linux-gnu-i486 - All binaries
lib-linux-gnu-i486 - All libraries
contrib - Contributed code
dbi - All data base interfaces (ODBC,MySQL
and PostgreSQL.
doc - Toplevel directory for documentation and
release notes.
esql - Source directory of the esql translator.
samples - Top Level directory of all examples
support - Contains support packages
var - The place, where the data base space
will be put (see MimerSQL)
win32 - Windows NT/2000 specific Makefiles
Step 2 - Verification of the functionality
Make process of the GNADE environment includes the
installation of a sample data base. The directory
./samples/smaple_db contains the installation procedure
and the odbc.ini sample file.
The ./samples directory contains several samples
which may be used to verify the correct operation
of the GNADE environment. If all examples do work
proceed with step 3.
Step 3 - Global installation of GNADE
In order to install the GNADE environment globally on your
system execute as root the following command:
make install
This will install the GNADE libraries and the esql translator
in your system.
/usr/local/lib/ada - All library components
/usr/bin - Executable to esql.
You may change these paths by modifying the line shown
below
LIBINSTALL=/usr/local/lib/ada
BININSTALL=/usr/bin
in the file ./make.conf.in before starting step 1.
Documentation
=============
Documentation is only in html format available. It is located
in the directory ./doc/html.
The docbook sources of the documentation are locoated under
./doc/build. If docbook is installed then you may build
the documentation by the command:
make documentation
Test
====
The esql translator may be tested by changing into the
directory ./samples/esql. The files with the extension
adq do contain Ada with embedded SQL code. The Makefile
builds the following executables:
./test_db - A test file which shows some of the
GNADE esql features.
./nobel_co - Reporting system for the nobel company
PLEASE FEEL FREE TO CONTRIBUTE TO THE PROJECT BY TESTING
AGAINST LEGACY CODE. PLEASE PROVIDE ME THE RESULTS OF YOUR
TESTS THAT I AM ABLE TO ADOPT THE ESQL TRANSLATOR TO YOUR
REQUIREMENTS.
Contact
=======
If you find an error or you need support, please
use the facilities at:
http://sourceforge.net/projects/gnade
All official distributions will be stored here as well.
In case you port the software to a different platform,
please keep me informed either by sending me a mail
Michael.Erdmann@snafu.de
or use the facilities at:
http://sourceforeg.net/projects/gnade
A mailing list for GNADE related discussion has been
established. In order do subscribe to the list goto:
http://cert.uni-stuttgart.de/mailman/listinfo/gnade-dev
|
