class_desc = 'OBJECT_OR_COLUMN' and \ EXP. extended_properties AS EXP \ LEFT OUTER JOIN sys. name is not null selectTableCommentsSql = SELECT OBJECT_NAME ( EXP.
Sql server 2012 microsoft jdbc driver driver#
It will extract the files into a specified directory (default is Microsoft JDBC Driver 4.0 for SQL Server). JDK version: 5.0 and 6.0.Run the downloaded program sqljdbc.exe.
Sql server 2012 microsoft jdbc driver download#
SELECT OBJECT_NAME(c.object_id) AS TABLE_NAME, c.name AS COLUMN_NAME, ex.value AS comments FROM sys.columns c LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 ORDER BY OBJECT_NAME(c.object_id), c.column_idĬom.: The connection is closed.Īt .SQLServerException.makeFromDriverError(SQLServerException.ja va:190)Īt .SQLServerDatabaseMetaData.checkClosed(SQLServerDatabaseMetaD ata.java:119)Īt .SQLServerDatabaseMetaData.getImportedKeys(SQLServerDatabaseM etaData.java:947)Īt .nnectForeignKeys(Table.java:106)Īt .nnectTables(Database.java:984)Īt .Database.(Database.java:83)Īt .analyze(SchemaAnalyzer.java:211)Īt .main(Main.java:42)ĭescription = MS SQLServer extends = mssql05 # connectionSpec = jdbc : sqlserver :// ] ] connectionSpec = jdbc : sqlserver :// \ : 1450 host = port = 1450 db = selectColumnCommentsSql = SELECT OBJECT_NAME ( EXP. Download Microsoft JDBC driver to download Microsoft JDBC Driver 4.0 for SQL Server which supports. SELECT i_s.TABLE_NAME, s.value AS comments FROM INFORMATION_SCHEMA.Tables i_s INNER JOIN sys.extended_properties s ON s.major_id = OBJECT_ID(i_s.table_catalog + '.' + i_s.table_name) WHERE s.class = 1 AND s.name = 'MS_Description'ġ4:09:43.836 SEVERE: TDSParser.throwUnexpectedTokenException - ConnectionID:1 ClientConnectionId: aacb73c0-cb9b-4f86-bc77-a9ac1979c444: getNextResult: Encountered unexpected unknown token (0x49)ġ4:09:43.837 SEVERE: TDSReader.throwInvalidTDSToken - ConnectionID:1 ClientConnectionId: aacb73c0-cb9b-4f86-bc77-a9ac1979c444 got unexpected value in TDS response at offset:45įailed to retrieve column comments: .SQLServerException: The connection is closed.
Gathering schema details.įailed to retrieve table/view comments: .SQLServerException: The "variant" data type is not supported.
0 kommentar(er)
