How to Resolve "unknown JDBC types for property" and "Table ... does not exist in a table space accessible by the data source" Errors (Doc ID 1476429.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Commerce Platform - Version 2006.3 and later
Oracle Commerce Merchandising - Version 2006.3 and later
Information in this document applies to any platform.

Goal

Errors and warnings may be logged at startup as SQL repositorities initialize reporting that database tables or columns do not exist even though the tables and columns are properly defined in the database. The SQL repository accesses the database metadata at startup to determine the JDBC type of each property in the repository template which enables the repository to use the appropriate JDBC type in creating SQL queries. It validates the repository definition XML to ensure the following things are present in the configured datasource:

If the table is not found in the default schema or the schema defined by the metaDataSchemaPattern table attribute or the metaDataSchemaPattern property of the repository, the following error will be reported:

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms