Apache OpenOffice Community Forum

Hi,

1)
I am having trouble editing a mySQL table using OpenOffice.org Base (version 2.1). I have no problem with simply viewing it.

2)
I am working on a Windows XP machine.

3)
I had previously created a database "parts" which I can read from and update using Java/JDBC/MySQL i.e.

connection = DriverManager.getConnection("jdbc:mysql://localhost/parts", username, password);

I am using the "com.mysql.jdbc.Driver" class.

4)
Everthing seems fine. Using Java I can select from tables and update them.

5)
I next try connecting to the same database using OpenOffice.org Base. I use the following Datasource URL:

jdbc:mysql://localhost/parts

I use the same username and password.

I use the same driver class as I use for my Java program, namely com.mysql.jdbc.Driver.

I can open the "parts" database, doubleclick a table and can see all the records but it is READ ONLY... I neither edit nor delete records.

6)
I want to edit or delete records. Please can someone tell me what am I doing wrong?

7)
I see that there may be some problems regarding user privileges. One of the FAQs on this site states...

Read/Write access rights can be enabled on a per-data-source basis. For this, the "Info" property of a data source should contain a name-value-pair with
Name: IgnoreDriverPrivileges
Value: TRUE

8)
I have tried installing and running the OpenOffice Basic Macro listed at http://dba.openoffice.org/howto/IgnoreD ... leges.html
but it does not seem to have any effect.

9)
I don't know how to directly set the "Info" property of my data source. For my MySQL administration I use "MySQL Administrator Version 1.2.13" running on a Windows XP machine.

10)
I have tried using MyISAM instead of InnoDB as the Table Editor in "MySQL Administrator" but things remain the same.

11)
I have tried using the following Datasource URL:

jdbc:mysql://localhost/parts?IgnoreDriverPrivileges=true

but...wait for it...that doesn't help either.

12)
I have tried using the following Datasource URL:

jdbc:mysql://localhost/parts?useHostsInPrivileges=false

and that doesn't help either.

Thanks for reading this. Any ideas?

Your OOo version pretty old, install OOo 3.0.0 and try again, lot of bugfixes from that version on Base.

Hi,

Thanks. I have tried that but it doesn't help.

Regards,
Nick

What JDBC version use?
Try latest version from MySQL site.

make sure that the table has a primary key.
I just went through a migration of MS Access db and everything worked fine after some hickups.
On the subform I was able to edit/delete records but on the mainform I couldn't - turned out that during the migration I had some issue with duplicate names for the primary key and subsequently when I edited the table in design mode in Base, it wouldn't show that particular field as being a primary key. Once I solved that, I was able to edit/delete records without any problems.

This was helpful to me: http://user.services.openoffice.org/en/ ... 40&t=11722