Using base with Apache Derby

Hi all,

 

I have been attempting to get oO working with the newly released Apache
Derby database.  I am able to connect to my database and can view
records, but my tables all appear to be read only.

 

I also was able to create a new table, but could not insert any rows
into it.

 

Does anyone have any suggestions on how I can configure base so that I
can insert records into my derby database tables?

 

-Open Office: 1.9.122

-Derby: 10.1.1 (server mode)

-Connect String: jdbc:derby://localhost:1527/myDB;user=sa;password=#@%$

-[Advanced Properties][Special Settings] Checked: Append table names,
user outer join, replace named parameters, use catalog name, use schema
name, create index with..

- I tried with ignore privileges checked and unchecked with no effect.

- The table I'm attempting to add records too has a primary unique key.

 

Thank you in advance,

 

Bob