You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (Jira)" <ji...@apache.org> on 2021/02/08 07:15:00 UTC

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

     [ https://issues.apache.org/jira/browse/CAY-2696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-2696.
--------------------------------
    Resolution: Duplicate

Duplicate of CAY-2695

> 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
>            Priority: Minor
>
> 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)