Problems with Grid Editor and DB2 since version 8.0.6

Florian, In 8.0.6 column names are displayed first by any column alias and secondly if no alias is used, the column name. Note that this depends on what database and driver being used. Ex: select col1 as 'Name', col2 as 'Address' from tab The names listed in DbVisualizer will be: Name Address So if you want to present the real column names instead of aliases, simply remove the alias from the column list in your select statement. This will also enable the table data editing. (We will look into a fix for the next maintenance version so that even if you use column aliases, editing support will be enabled). Regards Roger

Florian, Can you please post or email screenshot(s) with the names visible? It is difficult to determine what is going on based on the scrambled names. Regards Roger support@dbvis.com

Florian, I suspect there a LABELs assigned to each of the columns in the table you are selecting from. If this is the case I also assume you are using version 4+ of the JDBC driver. There is a change in the DB2 version 4+ driver that handles column names and labels differently compared to older versions. This in combination with the minor change we introduced in DbVisualizer 8.0.6 gives the effect you have reported. A simple workaround is that you set the following driver property for the actual database connection: useJDBC4ColumnNameAndLabelSemantics = 2 The driver property is set by first selecting the database connection in DbVisualizer and then click the "Properties" tab. Now select the "Driver Properties" category in the list and either locate the above property and set the value or insert the parameter and set the value. Press Apply, re-connect and verify that it works. Let me know the progress. Regards Roger

Florian, What version of the JDBC driver are you using? It is listed in the Connection message when connected (Connection tab). Right-click, select Copy and then paste in a reply. Regards Roger

Thanks So then you are not using a 4+ version of the driver as my previous post was about. Please try upgrade the JDBC driver to version 4 and give the suggestion another try. You find the DB2 drivers here: http://www-01.ibm.com/software/data/db2/ad/java.html Regards Roger Ps. We will look into a fix in the next version of DbVisualizer so that you can toggle between showing column names or aliases in the result set grid.

Florian, Just to inform you that this is now fixed in the new 8.0.7 version. The special driver property is not needed. Regards Roger