Eclipse Database Development Schema/Catalog Problem [JDBC425] #466
Comments
Modified by: John Doe (johnedoe)Attachment: schemyEmpty.png [ 12926 ] Attachment: jpa.png [ 12927 ] description: If i open a database Connetion in Eclipse Database Development Tool i cann See a folder "Schema" but it is not filled. And I cant see the Tables. Looks like This Problem. Dont think That it is because the Cataloge, but the Schema .? public ResultSet getSchemas(String catalog, String schemaPattern) https://www.eclipse.org/forums/index.php/t/8136/ => If i open a database Connetion in Eclipse Database Development Tool i cann See a folder "Schema" but it is not filled. And I cant see the Tables. Looks like This Problem. Dont think That it is because the Cataloge, but the Schema .? I have a Connection and I get Results when i execute statements! public ResultSet getSchemas(String catalog, String schemaPattern) https://www.eclipse.org/forums/index.php/t/8136/ summary: https://www.eclipse.org/forums/index.php/t/8136/ => Eclipse Database Development Schema/Catalog Problem |
|
Commented by: @mrotteveel The problem is that Eclipse DTP assumes that all databases have (named) schema objects, and that DatabaseMetaData.getSchema has at least one row. That is not the case for Jaybird; as Firebird doesn't have schemas at this time, it returns an empty result set, which breaks DTP. The JDBC standard allows the absence of this information (the javadoc of DatabaseMetaData says "If a given form of metadata is not available, an empty ResultSet will be returned."). The solution is to use the Firebird DTP plugin https://github.com/mrotteveel/fbdtp/releases/tag/1.0.2 as this will fake a two schemas to make Eclipse happy. I haven't done any work on this plugin in the last 4 years, so I am not sure if everything will work as expected with current Eclipse versions. If you run into any problems with this plugin, then please report them on https://github.com/mrotteveel/fbdtp |
|
Commented by: John Doe (johnedoe) Development Tool Works! THX a lot |
Submitted by: John Doe (johnedoe)
Attachments:
schemyEmpty.png
jpa.png
If i open a database Connetion in Eclipse Database Development Tool i cann See a folder "Schema" but it is not filled. And I cant see the Tables.
Same in New File -> JPA Entity From Table. Combox Schems is not Filled.
Looks like This Problem. Dont think That it is because the Cataloge, but the Schema .?
I have a Connection and I get Results when i execute statements!
public ResultSet getSchemas(String catalog, String schemaPattern)
https://www.eclipse.org/forums/index.php/t/8136/
The text was updated successfully, but these errors were encountered: