[
https://issues.apache.org/jira/browse/CAY-2695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17280806#comment-17280806
]
Andrus Adamchik commented on CAY-2695:
--------------------------------------
Here is another thread about this exact issue:
https://lists.apache.org/thread.html/r065fb2bb2d301ca8e3753ba8eecbae8200b22157f7acaa94d66e40a4%40%3Cuser.cayenne.apache.org%3E
This is "cdbimport" of 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}
> Reverse engineering on SQLite failes due to feature not being supported.
> ------------------------------------------------------------------------
>
> Key: CAY-2695
> URL: https://issues.apache.org/jira/browse/CAY-2695
> Project: Cayenne
> Issue Type: Bug
> Components: dbimport
> Affects Versions: 4.1
> Reporter: Alex Gheorghiu
> Priority: Major
> Fix For: 4.2.M3
>
> Attachments: cayenne_error.jpg, cayenne_error_empty_gui.jpg
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> I tried to do a reverse engineering on a SQLite database and failed due to
> SQLFeatureNotSuportedException in
> org.sqlite.jdbc4.JDBC4DatabaseMetaData.getSchema(...) .
>
> Also the error popup message is empty so I was forced to launch the -jar file
> only to get more insights.
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
