[Libreoffice-bugs] [Bug 144035] Older odb with JDBC driver postgres connection does not work anymore

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144035

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |NOTOURBUG

--- Comment #5 from Alex Thurgood <iplaw67 at tuta.io> ---
@Herman : thanks !

I see various packages for the JDBC driver linked here, depending on the
processor architecture you need, e.g. for x86_64  :

https://madb.mageia.org/package/show/name/postgresql-jdbc/application/0/arch/x86_64/source/1


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).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210825/67a45122/attachment.htm>