jomali wrote: > > Do you have primary keys defined in your database? If not, define an > autoincrement id field in each table and see what happens. > > John >
I have tried it and I can reproduce the problem like this: 1. I create a new database called "empty" 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 WITHPRIME( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY, SOMETHING VARCHAR ) COMMIT and SHUTDOWN COMPACT 3. I open OOBase, use the "connect to existing Database". URL: jdbc:hsqldb:file:[ABSOLUTE PATH TO MY FILE] Driver: org.hsqldb.jdbcDriver User: SA no password required Now I can view the (empty) database, but not add rows to my table. I can again create a new table with base but not add rows to it. What am I doing wrong? Sebastian -- View this message in context: http://old.nabble.com/Base-on-HSQLDB-writing-permission-tp26706194p26758025.html Sent from the openoffice - dba users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
