Hey all,
this time my problem is related to the cdbimport feature (maven or modeller) in
combination with SQLite.
SQLite does not support schema, so it's currently not possible to use the
reverse engineering feature.
The error you get with Xerial-JDBC driver is:
[WARNING] Error loading db schema
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)
or
[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)
getSchemas() throws this exception.
This error could be related to https://issues.apache.org/jira/browse/CAY-2600
Any idea how to use cdbimport without schema?
Kind regards,
Maria