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
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>For JDBC: 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="provider-notes.html" title="Provider's notes">
<link rel="prev" href="provider_notes_ldap.html" title="For LDAP">
<link rel="next" href="limitations.html" title="Limitations">
<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="provider-notes.html"><img src="up.png" width="16" height="16" border="0" alt="Up"></a></td>
<td><a accesskey="p" href="provider_notes_ldap.html"><img src="left.png" width="16" height="16" border="0" alt="Prev"></a></td>
<td><a accesskey="n" href="limitations.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="provider_notes_jdbc"></a>For JDBC</h2></div></div></div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.11.8.2"></a>How it works</h3></div></div></div>
<p>
JDBC (Java Database Connectivity) is a Java-based technology to access databases, not unlike ODBC.
The JDBC provider runs a Java Virtual Machine in which the installed JDBC drivers are loaded. Connections
are established and used through the JDBC driver, making an extensive use of the JNI (Java Native Interface)
technology.
</p>
<p>
Any JDBC driver can be used, though only some of them have actually been tested. Some specializations
have been made to adapt to some corner cases in the way some JDBC drivers are written or some specificities
of some database engines.
</p>
<p>
Note that the JDBC drivers are not provided by Libgda and must be obtained and installed separately.
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.11.8.3"></a>JDBC drivers' location</h3></div></div></div>
<p>
JDBC drivers (".jar" files) are searched for in the following locations:
</p>
<div class="orderedlist"><ol class="orderedlist" type="1">
<li class="listitem"><p>in each directory or JAR file in the <code class="envar">CLASSPATH</code> environment variable
(if set)</p></li>
<li class="listitem"><p>in the <code class="filename">$HOME/.local/share/libgda/config</code> directory (or
<code class="filename">$HOME/.libgda</code> if if exists and
<code class="filename">$HOME/.local/share/libgda/config</code> does not)</p></li>
</ol></div>
<p>
</p>
</div>
<div class="sect2">
<div class="titlepage"><div><div><h3 class="title">
<a name="id-1.2.11.8.4"></a>Connection parameters</h3></div></div></div>
<p>
To connect to a database, the expected connection parameters are the ones required by the JDBC driver being
used, which varies from driver to driver (for more information, refer to each driver's documentation). Thus
expects only one argument named "URL" which it passes (without any modification) to the JDBC driver.
</p>
<p>
However, for some widely used servers (such as SqlServer), Libgda also accepts some parameters like
for other database providers (like DB_NAME, HOST, ...). In this case one can either provide these parameters
or provide the URL parameter (like for any JDBC provider) to specify a connection to open.
</p>
</div>
</div>
<div class="footer">
<hr>Generated by GTK-Doc V1.32</div>
</body>
</html>
|
