|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Can't create table in Derby database | ||
|---|---|---|---|
| Product: | Base | Reporter: | greenrd2004 <greenrd> |
| Component: | code | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | OOo 2.1 | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Linux, all | ||
| Issue Type: | DEFECT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
Hi I can reproduce this. confirm, set target and reassign to the right developer Bye Marc @msc: Could you please verify, if this still occurs in SRC680m225? I can create tables here. Installed Derby 10.3.1.4 under XP as a network server SRC680_m233 JRE 1.6.0_03 Using JDBC connection and default settings: Can create tables, but can not set the PK for the table via the GUI. Adding data to tables via SQL window worked as expected. Further comments added to dba dev mailing list. Changed target to OOo 3.x Please take a look, if the still exists and what the correct target should be. |
I created a new Derby database (using Derby version 10.2.2.0), tried to create a table in Design View, and it wouldn't save the table - said there was a syntax error: Encountered "," on line 1, char 40 (i.e. the first comma below). This was the offending statement, according to the derby.log file: CREATE TABLE "APP"."Tags" ("Id" VARCHAR,"Name" VARCHAR,"Desc" VARCHAR) I am using Sun JDK 1.6.