Hi Maria, CAY-2600 is a related, but separate issue. Here is the one that matches your problem: https://issues.apache.org/jira/browse/CAY-2695 <https://issues.apache.org/jira/browse/CAY-2695> . I just updated it with your description. I hope we can fix this specific problem as I mentioned in the Jira. But IIRC SQLite driver had deeper issues with DB metadata, so I suspect it may fail at some other step.
@Nikita - do you remember what other limitations we had with SQLite? Or does it finally start to work? Andrus > On Feb 6, 2021, at 10:52 PM, Maria Huber <huber.maria...@gmx.de> wrote: > > 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
