https://bugs.documentfoundation.org/show_bug.cgi?id=146673
--- Comment #2 from Alex Thurgood <[email protected]> --- I created a test DB prior to setting up the LO JDBC connection and added a few records to via the browser connection (as illustrated in the documentation provided with the driver JAR download package). I then shutdown the H2 instance (otherwise you get an error when trying to set up the connection from within the ODB file). Once I'd configured the ODB file, I could connect to the H2 instance, but it would only show the INFORMATION_SCHEMA in the UI, not any of the PUBLIC schema tables or information contained therein. With the Query editor in SQL mode, it is possible to query all the results of the table by specifically naming the table in the query. Obviously, you can't use the UI to select a table for the query as none of the PUBLIC schema tables are displayed. -- You are receiving this mail because: You are the assignee for the bug.
