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


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.


SQL Server 2008, SQL Server 2005


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

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


Anton Zukovskij