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 DECEMBER 24, 2019
Oracle Commerce Platform - Version 2006.3 and later Oracle Commerce Merchandising - Version 2006.3 and later Information in this document applies to any platform.
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:
Tables defined in <table> tags exist in the database
Columns listed in <property> tags exist
The data-type Java object type of a property matches the SQL data type of the column
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!