<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - Older odb with JDBC driver postgres connection does not work anymore"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144035">bug 144035</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTOURBUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - Older odb with JDBC driver postgres connection does not work anymore"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144035#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - Older odb with JDBC driver postgres connection does not work anymore"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144035">bug 144035</a>
from <span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span></b>
<pre>@Herman : thanks !
I see various packages for the JDBC driver linked here, depending on the
processor architecture you need, e.g. for x86_64 :
<a href="https://madb.mageia.org/package/show/name/postgresql-jdbc/application/0/arch/x86_64/source/1">https://madb.mageia.org/package/show/name/postgresql-jdbc/application/0/arch/x86_64/source/1</a>
After installation of the correct package, you will probably also have to :
(1) point LO to the directory in which the postgresql JDBC JARs can be found -
this is done via the Advanced menu entry under Tools > Options > Classpath >
Add Jar
for example, in my setup, I have the following (for an older postgres JDBC
connector on macOS) :
/Users/alex/JavaDB/postgresql-8.4-702.jdbc3.jar
If the connection still won't work with a single jar, then you will have to
point LO to the folder containing the various postgresql JARs.
(2) fill in the driver name yourself in the connection configuration dialog
from within LibreOffice once the ODB file has been loaded.
org.postgresql.Driver
The connection string is something like :
jdbc:postgresql://ipaddressofserver:5432/mydbname
or
jdbc:postgresql://ipaddressofserver port=5432 dbname=mydbname
I seem to recall that the string suggestions in the connection setup dialog
provided by LO are incorrect (there is already a bug report for this, but I
don't think it has been corrected yet).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>