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 JUNE 15, 2022

Applies to:

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:

• 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:

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.