Re: Base on HSQLDB writing permission

On Tue, Dec 8, 2009 at 9:33 AM, ProMiller <[email protected]> wrote:

> Hello everyone,
> I have connected Base to an existing HSQLDB. I managed to get this
> connection working in so far as I can see the tables and contents but I
> cannot add or modify data to/in the tables. I can create new tables but I
> cannot add data to those newly created tables.
>
> I checked user permissions and tried using an admin account to connect to
> the database but the problem stays the same.
>
> In a OO wiki (http://www.ooowiki.de/HsqlDb - sorry it's in german) I found
> this information:
> "After following the steps in this guide your data is available again.
> Though gaining permission rights or copying a table into another database
> does not always work."
>
> "does not always work"???
>
> Any help with this issue is appretiated.
> Does OOBase not really support using a external HSQLDB?
> What other external databses are then FULLY supported?
> Is it a write permission issue?
>
> Thanks,
> Sebastian
>
>
Do you have primary keys defined in your database? If not, define an
autoincrement id field in each table and see what happens.

John