JDBC driver: sorting columns? - DatabaseMetaData#getColumns()
I am using DBVisualizer via JDBC to work with MonetDB. When exporting tables with DBVisualizers @export function, columns are sorted alphabetically, which causes problems when LOADING the exported csv into another database, and the import tool is expecting the original order of columns.
I wrote to the DBVisualizer team, they answered as follows:
"Hi Robert, Export uses the column order reported by the JDBC driver, so please consult your driver developer to see if you can get the driver fixed. More specifically, DbVisualizer uses the column order as reported by the DatabaseMetaData#getColumns() method."
If MonetDB JDBC driver is actually sorting columns, could you please return the given order of table columns?
Hi Robert, I would recommend using SQL/Workbench (http://www.sql-workbench.net/) instead of DbVisualizer. There is a cookbook for setting the monetdb in the sqlworkbench - https://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/Clients/SQLWorkb... . I tried the export to CSV it shows columns in correct order. HTH, Radovan
On Mon, 2014-11-24 at 09:48 +0100, Robert Koch wrote:
I am using DBVisualizer via JDBC to work with MonetDB. When exporting tables with DBVisualizers @export function, columns are sorted alphabetically, which causes problems when LOADING the exported csv into another database, and the import tool is expecting the original order of columns.
I wrote to the DBVisualizer team, they answered as follows:
"Hi Robert, Export uses the column order reported by the JDBC driver, so please consult your driver developer to see if you can get the driver fixed. More specifically, DbVisualizer uses the column order as reported by the DatabaseMetaData#getColumns() method."
If MonetDB JDBC driver is actually sorting columns, could you please return the given order of table columns?
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Radovan Bičiště -
Robert Koch