OpenOffice fails to open odbc table with compound primary key

[Bob Kline]

Binary package hint: openoffice.org-base

I just installed the latest Ubuntu on a system which used to have SuSE 10.1 on it, and which was able to use OpenOffice to connect to all of my business database tables. The database server is MySQL 5.0.32. I can open all of my tables except one, and when I try to open that table, I get the error message: "The data content could not be loaded ... [unixODBC][Driver Manager]Invalid cursor state." Sometimes (but not every time) OO.org crashes after the error dialog is dismissed. The table has a primary key (compound, with three columns). The bug I found which was closest to this bug does not appear to be the same problem, as the filer of that bug says that his problem goes away when he switches from the 64-bit version to the 32-bit version, and I'm running 32-bit versions of everything on this machine. I've been using these tables for almost a decade now, and the structure hasn't changed since the tables were created. This worked fine under SuSE (and still does on another machine I just upgraded to SuSE 10.2), and it worked fine before that when the client machine was running Fedora.

To reproduce:

* Install the latest Ubuntu i386 release (Feisty)
* Add mysql, unixodbc and libmyodbc packages
* Create a mysql database
* Create the following table:

CREATE TABLE ubuntu_repro
          (a DATE NOT NULL,
           b DECIMAL(8, 2) NOT NULL,
           c VARCHAR(50) NOT NULL,
CONSTRAINT repro_pk PRIMARY KEY (a, b, c));

* Create a DSN in odbc.ini for connecting to the database
* Open OO.o base
* Connect to the database via ODBC
* Try to open the table

Relevant version numbers:
openoffice.org-base 2.2.0-1ubuntu3
libmyodbc 3.51.11-6
unixodbc 2.2.11-13

Any other version number (or any other information) needed?

[Chris Cheney (ccheney)]

Do you still have this same problem on Ubuntu 7.10 OpenOffice 2.3.0?

Thanks,

Chris Cheney

[Bob Kline (bkline)]

Haven't been able to schedule the upgrade yet (downloaded it the first day of release but this time of year gets too hectic). Thanks for the nudge -- I'll try to fit it in during the next week and let you know.

[Bob Kline (bkline)]

The bug is still present on Ubuntu 7.10 OpenOffice 2.3.0.

[Chris Cheney (ccheney)]

If you switch your JRE to sun-java6-jre does it help to resolve the problem?

[Bob Kline (bkline)]

I'm afraid not.

[Bob Kline (bkline)]

Just out of curiosity, I notice that this issue is marked with a status of "Incomplete"; can you tell me what information you still need from me?

[Chris Cheney (ccheney)]

Do you still have this problem with openoffice.org 1:2.4.1-1ubuntu2 in Ubuntu 8.04?

Thanks,

Chris Cheney

[Bob Kline (bkline)]

No, it appears that the problem has been resolved.