To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107689 Issue #|107689 Summary|OOBase unable to write to external HSQLDB Component|Database access Version|OOO310m19 Platform|PC URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|monky42
------- Additional comments from monk...@openoffice.org Tue Dec 15 11:56:27 +0000 2009 ------- When I connect OOBase to a HSQLDB Base is unable to add rows or edit data. But it is able to view and create tables. Here is how I can reproduce it: 1. I create a new database called "emptyDB" with the hsqldb utility "Manager" (using hsqldb version 1.8.0), username "sa", no password. 2. I run those commands on the new database: CREATE TABLE MYTABLE ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY, SOMETHING VARCHAR ) COMMIT SHUTDOWN COMPACT 3. I open OOBase, use the "connect to existing Database". URL: jdbc:hsqldb:file:[ABSOLUTE PATH TO MY FILE]/emptyDB Driver: org.hsqldb.jdbcDriver User: SA no password required Now I can view the (empty) database, but not add rows to my table. The HSQLDB driver has successfully been added to OO's Java settings (viewing the DB works). I don't think this is an access authorization issue since I use the db administrator account to connect. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org