Issue 19219 - mysql data source displayed readonly
Summary: mysql data source displayed readonly
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC
Hardware: PC Windows XP
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-07 21:37 UTC by errorist
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description errorist 2003-09-07 21:37:47 UTC 
Using com.mysql.jdbc.Driver (mysql-connector-java-3.0.8-stable-bin.jar) to
access a mysql database, OpenOffice will display all tables readonly. The
toolbar button for toggling between readonly/editable is disabled aswell.

Pure SQL-Updates/Inserts on the tables from OpenOffice work.
Comment 1 marc.neumann 2003-09-11 12:01:54 UTC 
hi errorist,

this is a problem of the jdbc driver, because it doesn't return the
table privileges correctly.

Please use the nativ mysql driver with this jdbc driver. Then you have
write access to the tables.

If it still doesn't work, please feel free to reopen this issue.


Bye Marc
Comment 2 marc.neumann 2003-09-11 12:03:20 UTC 
please see also
http://dba.openoffice.org/FAQ/FAQ.html#dataupdate
close this issue.
Comment 3 hans_werner67 2004-02-02 12:13:23 UTC 
change subcomponent to 'none'