To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80342 Issue #|80342 Summary|Cannot open non-empty tables from H2 database over JDB |C Component|Database access Version|680m224 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|jspitz
------- Additional comments from [EMAIL PROTECTED] Sat Aug 4 11:20:20 +0000 2007 ------- OOo 680m224 Czech (from the official server) + Windows XP Czech I create an OOo database which connects to an existing H2 database using JDBC. Now I create a simple table (of course with a primary index) and name it "Non_empty_table". Now I open it and the data grid appears. Next I fill in a new record and try to save it. I get a message: "Column H2.SA.Non_empty_table not found [42S22-56]" When I close the data grid, OOo complains about key violation in an unique or primary index. However, the record is actually saved to the database. From now I am not able to open the table grid and always receive the above mentioned error message. I can import a big table from another database using copy & paste without problems but can't then to open it. Very strange is that I can use the table using queries. Creating a query SELECT * FROM SA."Non_empty_table" I can do with the table whatever I like. Of course this might be an issue of the H2 database but I do not know how to decide it. To reproduce this issue unpack the included ZIP to some directory. Add the file h2.jar to your java classes. Then open h2.odb and in the JDBC settings of the database change the connection string so that it points to the directory where you unpacked the ZIP. The ODB file contains: tables: "Empty_table" - it can be opened in the grid view "Non_empty_table" - the same table but with one record - cannot be opened "Intermediate_flows" - big table imported from a Postgres database query: "intermed" defined as SELECT * FROM SA."Intermediate_flows" - it works The version of H2 database is "Version 1.0 / 2007-08-02" --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
