OpenOffice fails to open odbc table with compound primary key

Bug #123307 reported by Bob Kline
2
Affects Status Importance Assigned to Milestone
openoffice.org (Ubuntu)
Fix Released
Undecided
Unassigned

Bug Description

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?

Bob Kline (bkline)
description: updated
Revision history for this message
Chris Cheney (ccheney) wrote :

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

Thanks,

Chris Cheney

Changed in openoffice.org:
assignee: nobody → ccheney
status: New → Incomplete
Revision history for this message
Bob Kline (bkline) wrote :

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.

Revision history for this message
Bob Kline (bkline) wrote :

The bug is still present on Ubuntu 7.10 OpenOffice 2.3.0.

Revision history for this message
Chris Cheney (ccheney) wrote :

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

Revision history for this message
Bob Kline (bkline) wrote :

I'm afraid not.

Revision history for this message
Bob Kline (bkline) wrote :

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)
Changed in openoffice.org:
assignee: ccheney → nobody
status: Incomplete → New
Revision history for this message
Chris Cheney (ccheney) wrote :

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

Thanks,

Chris Cheney

Changed in openoffice.org:
status: New → Incomplete
Revision history for this message
Bob Kline (bkline) wrote :

No, it appears that the problem has been resolved.

Chris Cheney (ccheney)
Changed in openoffice.org:
status: Incomplete → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.