SQL Server 2012

CloverDX Platform
1

Having trouble importing metadata for SQL Server 2012. I can pull up a list of tables, but then trying to browse a table returns “Invalid object” errors. JDBC compatibility problem perhaps?

Thanks

2

Hello,

could you please provide us with the log file which is located in your project folder under .metadata/.log
Clover officialy supports SQL server up to 2008. However the log might tell us more about why is this happening.

3

It doesn’t look like the error is being logged:


!SESSION 2012-05-16 13:26:38.777 -----------------------------------------------
eclipse.buildId=M20100909-0800
java.version=1.6.0_29
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
Framework arguments:  -product com.cloveretl.gui.product.community.designer
Command-line arguments:  -os win32 -ws win32 -arch x86_64 -product com.cloveretl.gui.product.community.designer

!ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.987
!MESSAGE NLS unused message: Columns_text in: org.eclipse.ui.internal.views.properties.messages

!ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.988
!MESSAGE NLS unused message: Columns_toolTip in: org.eclipse.ui.internal.views.properties.messages

!ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.989
!MESSAGE NLS unused message: Selection_description in: org.eclipse.ui.internal.views.properties.messages

!ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.990
!MESSAGE NLS unused message: Pin_text in: org.eclipse.ui.internal.views.properties.messages

!ENTRY org.eclipse.osgi 2 1 2012-05-16 13:26:47.991
!MESSAGE NLS unused message: Pin_toolTip in: org.eclipse.ui.internal.views.properties.messages

But the attached is the error I am getting.

4

Hello,

is the SQL query any complicated? There’s a known bug that for some cases of queries the extraction fails. The bug is reported here https://bug.javlin.eu/browse/CLD-3657
If you simplify the query, does it still fail? The known problems causing this are:
query has a semicolon ; at the end
query contains nested query
query has some functions in the view part

This might be your case, maybe you could provide us with the SQL query and also try running the extraction with simplified query.

5

No, no actual SQL yet. Just trying to browse the data via the tree.

6

Hello,

we will check compatibility with SQL Server 2012 and let you know. I opened an issue CL-2301 in our tracking system for this.

7

We have investigated the compatibility with the SQL server 2012 and found out the message you’re getting is probably caused when you’re trying to browse a table that doesn’t belong under default schema of your DB user. Currently you can’t browse the list of tables that aren’t in your default schema, but checking the option “Prefix table names with schema” before generating query allows you to extract metadata from a table that belongs under different schema (but only all the columns can be extracted).

8

Same problem when checking that box. Problem is likely due to my lack of understanding of default schemas in MSSQL. Will investigate.