Issue 55029

Summary: Tables on HSQLDB server allways readonly
Product: Base Reporter: drewjensen.inbox
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, jl78
Version: OOO 2.0 Beta2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description drewjensen.inbox 2005-09-24 13:54:47 UTC 
Using OOBase to connect to an instance of a HSQLDB server all existing tables
are treated as read only. If you create a table it will also be read only. If
you try to edit any table, no column information is displayed. If you create a
form and add controls opening the form will show nothing in the controls,
however the navigator will correctly display the number of records in the table.

This problem has been found by two people with slightly different configurations
- WinXP SP2, OO.o 1.9.130 connecting to a server on localhost running hsqldb 1.8.0
and Win2k sp4, OO.o 1.9.125. connecting to a server running hsdqldb 1,8.0.2
Comment 1 marc.neumann 2005-09-26 09:41:36 UTC 
Hi,

I can reproduce this..

I reassign it to the right developer.

Bye Marc
Comment 2 ocke.janssen 2005-09-27 12:53:45 UTC 
The problem here is that hsqldb now supports schemta where we have some problems
in our code. The changes are too risky at this moment. We'll fix at in the next
version OOo3.0. A workaround is to append 
;default_schema=true
to the connection line. This ensures that the primary key can be found.

Best regards,

Ocke
Comment 3 ocke.janssen 2006-07-03 13:10:09 UTC 
Change target.
Comment 4 ocke.janssen 2006-07-31 08:05:09 UTC 
Set target to OOo later. The workaround works for now.
Comment 5 audionuma 2006-08-26 15:02:25 UTC 
it seems there's the same issue with an hsqldb database in standalone mode, 
connected thru jdbc (hsqldb 1.8.0 / OOo 2.0.3 fr / Win XP Home SP2).
Didn't test the workaround yet.
Comment 6 jl26 2015-03-06 14:46:51 UTC 
Tested with AOO 4.1.1 under Windows 8.1 and standalone HSQLDB server with the workaround (url jdbc:hsqldb:hsql://localhost/test_base;default_schema=true)
It is possible to create and save a new table, add ou delete a column to an existing table, *but* existing column remain «read only ». it’s not possible to alter name or type of an existing column except by using Tools SQL…