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)
