Issue 76096 - PostgreSQL SDBC native driver not available for 64bit
Summary: PostgreSQL SDBC native driver not available for 64bit
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.4
Hardware: PC (x86_64) Linux, all
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-04-04 17:10 UTC by pcav
Modified: 2014-03-10 14:34 UTC (History)
8 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description pcav 2007-04-04 17:10:29 UTC
Apparently the SDBC  postgresql-sdbc-0.7.4.zip does not work on 64-bit machines.
The same installation works on 32-bits.

On the 32bit PC under Tools>Package management I see in the zip:
DataAccess.xcu
postgresql-sdbc-impl.uno.so
postgresql-sdbc.uno.so

on the 64 bit, I only see DataAccess.xcu

All the best.
pc
Comment 1 kendy 2007-04-05 12:15:57 UTC
.uno.so are binary files - supposedly 32bit when they work on 32bit OOo.  No 
surprise that they don't work with 64bit OOo; you would need their 64bit 
versions.

Where comes the postgresql-sdbc-0.7.4.zip from?  To ping the originators to 
provide even the 64bit version...
Comment 2 pcav 2007-04-05 12:59:29 UTC
The 64bit version does not appear to be available from the web site. In any
case, this would not solve the problem in our setting, as users share 64 and 32
bit machines with the same home; given that the drive has to be installed in the
home for each user, they will not be able to use the driver smoothly across
machines.
Comment 3 Frank Schönheit 2007-04-10 07:11:56 UTC
Extensions can also be installed in the shared installation of OOo, and since
you need to have a 32 and a 64 bit version of OOo, you could install both
versions of the extension once.
I am not sure how to do this shared installation, try to invoke "unopkg" on the
command line, it is said to have some respective switch (I never tried, though).
Otherwise, I suggest asking in users@openoffice.org.
Comment 4 Frank Schönheit 2007-04-10 07:13:00 UTC
closing issue
Comment 5 pcav 2007-04-10 09:40:43 UTC
Sorry, I do not understand the rationale behind closing this issue:
1. the driver provided on the http://dba.openoffice.org/drivers/postgresql/ site
does not work on 64bit machines
2. the proposed solution (recompiling OOo+PG) is just unfeasible for the average
OOo user
3. the unpkg approach does not work for me
4. I do not see the reason why sending the request to users instead of the ad
hoc database list.
I am therefore reopening the issue.
pc
Comment 6 Frank Schönheit 2007-04-10 09:54:09 UTC
In my opinion, what you have is a request for enhancement to the extension
author: to provide a 64 bit version as well. Note that this would require the
author to have a 64 bit build environment, which I somehow doubt ...

Note that this does not depend on the unopkg thing at all. I was just saying
that once you have two extension versions (32 and 64 bit), you could install
them in the respective OOo installation (since you have two OOo versions, it
seems). This would still allow your users to work with either of those versions,
always having the same home.
Comment 7 joergbudi 2007-04-11 20:02:03 UTC
Hi,

I think, some things are getting mixed up here. 

@pcav (as issue writer): 
1) Please state, if you have installed the 32bit or the 64 bit version of
openoffice (check with the unix command 

file /path/to/ooo/program/soffice.bin

) on your 64 bit system. You should not use the 64 bit version atm, as it is
broken ( see
http://wiki.services.openoffice.org/wiki/Porting_to_x86-64_%28AMD64%2C_EM64T%29
, the first sentence tells "It is of no use for non-developers").

2) I think, you use the 32 bit version of openoffice, that comes with your
distribution. If you do so, please download the openoffice.org version from
openoffice.org, install it separately and test the driver with it. This runs on
my 64bit suse system. If it does not run, you'll have my support in hunting down
why it does not run.

3) Assuming that the above test is successful for you, the problem remains, that
 the driver does not run with the openoffice coming with your distribution. This
is the fault of the gcc project, which does not hold up binary compatibilty
between different versions of gcc, address your issue there.
You can also try to approach your distributor to make him add the postgresql
driver to its distribution.

4) The problem will vanish on the long run, when the driver gets integrated into
OOo code base. This will happen someday, but there is no due date.

Bye,

Joerg
Comment 8 pcav 2007-04-12 09:19:13 UTC
Thanks for following this up.
# file /usr/lib/openoffice/program/soffice.bin
/usr/lib/openoffice/program/soffice.bin: ELF 64-bit LSB executable, AMD x86-64,
version 1 (SYSV), for GNU/Linux 2.6.0, dynamically linked (uses shared libs),
for GNU/Linux 2.6.0, stripped
I'm investigatin this with the Debian devs. I still do not understand why the
driver is not included in OOo code base: it is pretty stable for us, very
useful, and I cannot immagine it causing harms to non-pg users.
Alternatively, the driver may be packaged in my distro, which could solve part
of the problem (see http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=346475).
Using the same home with 32 and 64 bits, however, may still be an issue.
Comment 9 pcav 2007-04-13 08:05:19 UTC
So OOo does build on 64bit (at least for Debian); does the pg driver compile?
Has someone tried yet? The older version (0.6.x) did not, according to Debian
developers.
Comment 10 rene 2007-06-04 10:35:53 UTC
pcav: 0.7.4 seems to build fine in a OOo2 env (barring some needed patches for
newer gccs) on my ppc box (didn't yet try x86_64).
I'll probably add the extension to the 2.3 Debian packages of OOo. (maybe as a
extra package, maybe in -base, didn't decide yet finally)
Comment 12 rene 2009-01-12 12:44:05 UTC
This bug looks like INVALID. It says that the "PostgreSQL SDBC native driver on
64-bit does not work", but it does work - it just is not available in binary form
for anything else than i386. (While that would work, see
http://packages.debian.org/experimental/openoffice.org-sdbc-postgresql.

Now, of course there could be a wish to jbu to also provide a 64bit package as
OpenOffice.org now als has 64bit packages, but...
I'll change the title to reflect that.
Comment 13 rene 2009-01-12 12:44:20 UTC
This bug looks like INVALID. It says that the "PostgreSQL SDBC native driver on
64-bit does not work", but it does work - it just is not available in binary form
for anything else than i386. (While that would work, see
http://packages.debian.org/experimental/openoffice.org-sdbc-postgresql.

Now, of course there could be a wish to jbu to also provide a 64bit package as
OpenOffice.org now als has 64bit packages, but...
I'll change the title to reflect that.
Comment 14 rene 2009-01-12 12:44:45 UTC
oops
Comment 15 Paul Kerry 2012-10-22 11:37:58 UTC
Fast forward a few years: given that lots of people must be using 64bit nowadays instead of 32bit, will there be a release of a SDBC native driver for 64bit linux?

postgresql-sdbc-0.7.6b.zip downloaded from
http://www.openoffice.org/dba/drivers/postgresql/index.html
works for me under 32bit linux but not 64bit.


Many thanks
Paul.
Comment 16 Paul Kerry 2012-10-22 11:40:07 UTC
Fast forward a few years to 2012: given that lots of people must be using 64bit nowadays instead of 32bit, will there be a release of a SDBC native driver for 64bit linux?

postgresql-sdbc-0.7.6b.zip downloaded from
http://www.openoffice.org/dba/drivers/postgresql/index.html
works for me under apache openoffice 3.4.1 32bit linux but not 64bit linux.


Many thanks
Paul.
Comment 17 Rob Weir 2013-07-30 02:35:32 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.
Comment 18 oooforum (fr) 2014-03-10 14:34:19 UTC
Very annoying for those running with AOO x64 under Linux.
And the next buid under MacOS will be full x64.

Maybe that will be better to warn users who access to this webpage:
http://www.openoffice.org/dba/drivers/postgresql/

But that will be better too to build this driver on 64-bits
;-)