On Thursday 11 August 2005 15:46, [EMAIL PROTECTED] wrote: > 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.
Hi Bob, I'm not exactly sure if it is relevant for your case but is it possible that you do not have a primary key defined ? Also maybe you should ask on [email protected] and ask to be CC:ed as you may not see all replies unless you subscribe to that list by sending an email to [EMAIL PROTECTED] and reply to the confirmation request email. Please reply to [email protected] only -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
