Thu, 29 Oct 2015 17:54:57 GMT
I'm having trouble generating my repository. I've entered in all of the necessary database details in the "Configuration" tab and everything tests successfully "OK". However, when I click on the "Meta-data" tab and hit the "Get schemas" button (or any other button), I get the following error:
Cannot get tables from meta-data !
Exception com.microsoft.sqlserver.jdbc.SQLServerException : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or  are not allowed. Change the alias to a valid name.
What could be the issue here? I'm connecting to a SQL Server database (10.50.6000) using the 4.2.6420.100 driver version. Any help would be appreciated.
Fri, 30 Oct 2015 09:32:50 GMT
There's probably a peculiarity with SQL Server and JDBC meta-data to retieve the Schemas list. If you don't have Catalog or Schema just input "!" in the Catalog/Schema fields in the GUI. If you know what Schema you want to use input the schema name in the "Schema" field and try "Get tables" to retrieve all the tables belonging to this schema
Fri, 30 Oct 2015 13:23:23 GMT
Thanks - that worked!