Issue 23405 - Cannot add or modify records with JDBC to MySQL
Summary: Cannot add or modify records with JDBC to MySQL
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-12-10 13:38 UTC by kurti
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 kurti 2003-12-10 13:38:34 UTC 
I have MySQL 3.23.44-Max and MySQL Connector/J 3.0.8 JDBC driver.

I can connect to the database and see all records, but I cannot edit or add new
records (the '*' is disabled).

We tried the same about a year ago with the same effects. We tried the ODBC
driver which allowed us to add records to the database.

MySQL access works fine with 'mysql' command line tool and all our Java
applications using the same credentials.
Comment 1 Frank Schönheit 2003-12-10 14:52:34 UTC 
correcting sub component and default owner
Comment 2 marc.neumann 2003-12-11 09:02:05 UTC 
Hi kurti,

Have you read

http://dba.openoffice.org/FAQ/FAQ.html#dataupdate
http://dba.openoffice.org/FAQ/specific.html#mysql

Does it work now?

Bye Marc
Comment 3 marc.neumann 2003-12-12 13:29:19 UTC 
add keyword needmoreinfo
Comment 4 kurti 2003-12-12 13:54:17 UTC 
Sorry, my fault. The table lacks a primary key.

Thanks for pointing me to the docs.
Comment 5 marc.neumann 2003-12-17 12:24:32 UTC 
close the issue.
Comment 6 hans_werner67 2004-02-02 12:20:23 UTC 
change subcomponent to 'none'