[jira] [Created] (CAY-2696) DatabaseSchemaLoader must check for schemas / catalogs support

["Andrus Adamchik (Jira)" <ji...@apache.org>]

Andrus Adamchik created CAY-2696:
------------------------------------

             Summary: DatabaseSchemaLoader must check for schemas / catalogs support
                 Key: CAY-2696
                 URL: https://issues.apache.org/jira/browse/CAY-2696
             Project: Cayenne
          Issue Type: Bug
            Reporter: Andrus Adamchik


Per this mailing list thread: https://lists.apache.org/thread.html/r065fb2bb2d301ca8e3753ba8eecbae8200b22157f7acaa94d66e40a4%40%3Cuser.cayenne.apache.org%3E we are getting a number of exceptions when trying to "cdbimport" SQLite with "Xerial-JDBC driver". While IIRC SQLite has other problems with metadata (so I wonder if we could ever get a meaningful model out of it??), I hope that this particular problem can be fixed by checking "DatabaseMetaData.supportsSchemasInTableDefinitions()"  

{noformat}
Error loading db schema

java.sql.SQLFeatureNotSupportedException
    at org.sqlite.jdbc4.JDBC4DatabaseMetaData.getSchemas (JDBC4DatabaseMetaData.java:32)
    at org.apache.cayenne.modeler.editor.dbimport.DatabaseSchemaLoader.processSchemas (DatabaseSchemaLoader.java:101)
    at org.apache.cayenne.modeler.editor.dbimport.DatabaseSchemaLoader.processCatalogs (DatabaseSchemaLoader.java:92)
    at org.apache.cayenne.modeler.editor.dbimport.DatabaseSchemaLoader.load (DatabaseSchemaLoader.java:58)
    at org.apache.cayenne.modeler.action.LoadDbSchemaAction.loadDataBase (LoadDbSchemaAction.java:116)
    at org.apache.cayenne.modeler.action.LoadDbSchemaAction.lambda$performAction$0 (LoadDbSchemaAction.java:96)
    at java.lang.Thread.run (Thread.java:844)
-------
[INFO] Exception on reverse engineering
java.sql.SQLFeatureNotSupportedException
    at org.sqlite.jdbc4.JDBC4DatabaseMetaData.getSchemas (JDBC4DatabaseMetaData.java:32)
    at org.apache.cayenne.dbsync.reverse.filters.FiltersConfigBuilder.processSchemas (FiltersConfigBuilder.java:117)
    at org.apache.cayenne.dbsync.reverse.filters.FiltersConfigBuilder.processCatalogs (FiltersConfigBuilder.java:107)
    at org.apache.cayenne.dbsync.reverse.filters.FiltersConfigBuilder.preBuildFilters (FiltersConfigBuilder.java:87)
{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)