Issue 55029 - Tables on HSQLDB server allways readonly
Summary: Tables on HSQLDB server allways readonly
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-09-24 13:54 UTC by drewjensen.inbox
Modified: 2015-03-06 14:46 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
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

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 
to the connection line. This ensures that the primary key can be found.

Best regards,

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…