Apache OpenOffice (AOO) Bugzilla – Issue 17126
refresh of Database Explorer
Last modified: 2006-05-31 14:29:06 UTC
I think, if I close a Database-Connection in the explorer or collapse the Tables from a Database, than OOo should refresh the infos from the Database. So what I mean is: I have two connections to a MySQL-Database. one as root, another as user. If I create as user a table, named Table1, than I see this table as root only if I disconnect from MySQL and connect again. I think this should be done by simply clicking on the Tables-Tree in the DB-Explorer. And next is that MySQL stores the Table as table1, not Table1 as OOo means. Here I have to re-connect too to see the right names of the tables
The 'problem' is the connection pooling under TOOLS/OPTIONS/DATASOURCES/. Please deactivate the connection pooling. Then the database info should be renewed when you reconnect. The second part with the wrong name I can't reproduce. I have used MySQL via the MySQL driver via ODBC. Which connection type do you use? And which version?
I have deactivated the connection pooling, and as you say, you have to reconnect to get the right values. I think this should be shown by a simple close and reopen the tree-view of the tables. BTW: have you tried to select only few tables via the administration-dialog? Here it is the same. If I click on Apply I think the view should be re-read from driver. I use MySQL 4.0.13 mwith J/Connector3.0.8stable over JDBC on Windows. So I think this is not worksforme
set target
The connection pooling mechanism has to be rethink, maybe it should disabled by default and can be enabled if the user want to have a performance advantage. Or a kind of 'refresh from database' entry in the context menu of the tables container is also a good idea. However , this is the first part, the second part 'MySQL stores the Table as table1, not Table1 as OOo means' I can still not reproduce.
> Or a kind of 'refresh from database' entry in the context menu of the > tables container is also a good idea. you're referring to issue 16690 here :) Hermann, please submit a second issue for the second part of your report (the case of the table name). "One problem -> one issue" makes dealing with issues much easier. Thanks :) *** This issue has been marked as a duplicate of 16690 ***
closing duplicate
Hi Frank, for me this is the same. Because if I reconnect OOo to the Database, OOo shows the right Name table1. And I cannot create an Tablename TaBlE1 in MySQL, but this is another Bug. I have to show how to do this with MySQL, then I come back :-)
I found that on Windows MySQL handles Tablenames case-insensitive, so this is normal on windows, but then OOo should look how the Table is named after it is created.
well, normally the driver should tell OOo about the case sensivity of identifiers such as table names. So either the driver is lying, or OOo is not respecting the driver information. In any way, I still think this is a separate bug (something like "wrong identifier case when creating tables in MySQL"), because only a dedicated bug will ensure that it's investigated and fixed, if possible.
change subcomponent to 'none'