cdbimport for SQLite

Maria Huber <[email protected]>
Newsgroups gmane.comp.java.cayenne.user
Message-ID <trinity-17797588-0692-4974-b302-5ded42af9782-1612641161994@3c-app-gmx-bs32>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.