[jira] [Commented] (CAY-2695) Reverse engineering on SQLite failes due to feature not being supported.

["Andrus Adamchik (Jira)" <ji...@apache.org>]

    [ 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)