[dba-users] Using base with Apache Derby

[Bob.Coss]

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;[EMAIL PROTECTED] -[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