SQL Server: "Database 'dbo' does not exist" error

Description

In SQL Server 2005-2008 ((JdbcConnection) database.getConnection()).getMetaData().getSchemas() returns parent schema name as TABLE_CATALOG. When ((JdbcDatabaseSnapshot) snapshot).getMetaData().getTables(TABLE_CATALOG, TABLE_SCHEMA ...) is invoked, TABLE_CATALOG is interpreted as database name(and schema name is passed to this parameter) and exception (see exception.log) is thrown. My company does not use database that requires multiple catalogs, therefore I've fixed this issue by removing catalog from SchemaSnapshotGenerator (see attached patch), this issue needs to be addressed to MSSQLDatabase to have consistent database\schema name variables.

Environment

SQL Server 2008, SQL Server 2005

Activity

Show:
Nathan Voxland
September 24, 2013, 1:50 PM

No longer pulling the table_catalog in schema snapshot generator. It should not be needed since it is encoded in the connection

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Reporter

Anton Zukovskij