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
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Database providers: GNOME Data Access 5 manual</title>
<meta name="generator" content="DocBook XSL Stylesheets V1.79.1">
<link rel="home" href="index.html" title="GNOME Data Access 5 manual">
<link rel="up" href="libgda-packaging.html" title="Packaging Libgda">
<link rel="prev" href="ch50s04.html" title="Tools">
<link rel="next" href="ch50s06.html" title="Development files">
<meta name="generator" content="GTK-Doc V1.32 (XML mode)">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<table class="navigation" id="top" width="100%" summary="Navigation header" cellpadding="2" cellspacing="5"><tr valign="middle">
<td width="100%" align="left" class="shortcuts"></td>
<td><a accesskey="h" href="index.html"><img src="home.png" width="16" height="16" border="0" alt="Home"></a></td>
<td><a accesskey="u" href="libgda-packaging.html"><img src="up.png" width="16" height="16" border="0" alt="Up"></a></td>
<td><a accesskey="p" href="ch50s04.html"><img src="left.png" width="16" height="16" border="0" alt="Prev"></a></td>
<td><a accesskey="n" href="ch50s06.html"><img src="right.png" width="16" height="16" border="0" alt="Next"></a></td>
</tr></table>
<div class="sect1">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="id-1.10.2.7"></a>Database providers</h2></div></div></div>
<p>
Each database provider is composed of a shared library (loaded at runtime) and some configuration files,
which are prefixed with the provider name. Also note that each provider comes with a PKG-CONFIG .pc file
which allows one to check if a provider is installed (it does not, like most of the .pc files, define
any CFLAGS or LIBS), and it's wise to include them in each provider's component.
</p>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.10.2.7.3"></a>'Generic' provider</h3></div></div></div>
<p>
Most of the providers are 'generic' as they have the same files structure, here for example
the PostgreSQL provider's file are:
</p>
<pre class="programlisting">
.
|-- lib
| |-- libgda-5.0
| | `-- providers
| | `-- libgda-postgres.so
| `-- pkgconfig
| `-- libgda-postgres-5.0.pc
`-- share
`-- libgda-5.0
|-- postgres_specs_add_column.xml
|-- postgres_specs_create_db.xml
|-- postgres_specs_create_index.xml
|-- postgres_specs_create_table.xml
|-- postgres_specs_create_view.xml
|-- postgres_specs_drop_column.xml
|-- postgres_specs_drop_db.xml
|-- postgres_specs_drop_index.xml
|-- postgres_specs_drop_table.xml
|-- postgres_specs_drop_view.xml
|-- postgres_specs_dsn.xml
`-- postgres_specs_rename_table.xml
</pre>
<p>
</p>
<p>
This kind of component should be made dependent on the database's library which is used,
such as LibPQ for PostgreSQL, and also on <span class="application">Libgda</span>'s runtime component.
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.10.2.7.4"></a>The SQLite provider</h3></div></div></div>
<p>
The SQLite provider uses the same files layout as the 'generic' provider, but there is no need to
add a dependency on SQLite itself.
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.10.2.7.5"></a>The JDBC provider</h3></div></div></div>
<p>
The JDBC provider allows one to access database through its JDBC driver, using the Java Native Interface
(JNI), and a Java virtual machine runtime. The files to include in this component are:
</p>
<pre class="programlisting">
.
|-- lib
| |-- libgda-5.0
| | `-- providers
| | |-- gdaprovider-5.0.jar
| | `-- libgda-jdbc.so
| `-- pkgconfig
| `-- libgda-jdbc-5.0.pc
`-- share
`-- libgda-5.0
|-- jdbc_specs_create_table.xml
`-- jdbc_specs_dsn.xml
</pre>
<p>
</p>
<p>
This component should be made dependent on the Java virtual machine.
</p>
</div>
</div>
<div class="footer">
<hr>Generated by GTK-Doc V1.32</div>
</body>
</html>
|
