Hi René, > I have an issue with OO Base that seems to be familiar. I read some > of the postings in the last weeks here and experienced some of the > same errors. Maybe I can add a few details that help to solve the > issues. I have created a small database with HSQLDB and its Manager > application running HSQLDB in Server mode. It works just fine, when I > connect with the Manager application. I can insert data, modify > tables and so on. Then I tried to use Base to connect to the > database. It works fine as well. I see all the tables and also all > the data in it, but > 1. I cannot modify the table structure (same issue that Kevin James > has)
This is hardly possible in a generic way with JDBC databases, since OOo cannot know the specific SQL dialect to modify a table structure. Since for external HSQL databases, OOo's generic JDBC driver is used, this also applies here. > 2. I cannot insert or modify any data. It seems the whole database is > in read only mode. Try adding a ";default_schema=true" to your JDBC connection string in Edit|Database|Properties. HSQLDB provides schema support since 1.8.0, but OOo Base is not really completely prepared for schema usage. This might have different effects with different databases, for external HSQLDBs, this means (amongst others) the effect you observed. default_schema=true tells HSQLDB to assume the schema "PUBLIC" by default for all queries. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
