Skip to main content
  • Log in
  • Manage Cookies
Eclipse Plugins, Bundles and Products - Eclipse Marketplace
  • My Marketplace
  • Add Content
  • More
      • Community

      • Marketplace
      • Events
      • Planet Eclipse
      • Newsletter
      • Videos
      • Blogs
      • Participate

      • Report a Bug
      • Forums
      • Mailing Lists
      • Wiki
      • IRC
      • Research
      • Eclipse IDE

      • Download
      • Learn More
      • Documentation
      • Getting Started / Support
      • How to Contribute
      • IDE and Tools
      • Newcomer Forum
    • Search

  1. Home
  2. Marketplace
  3. Tools
  4. g9 Database Import

Please be aware that some listings have been temporarily delisted from our marketplace in order to improve the security of the platform. We apologize for any inconvenience this may caused.

For more information on this matter, please visit #1.

If you are a listing owner and would like to have your listing(s) reinstated, please open a ticket at https://gitlab.eclipse.org/eclipsefdn/it/websites/marketplace.eclipse.org/-/issues.

Thank you for your understanding and cooperation.

Eclipse Foundation Member
g9 Database Import

g9 Database Import
10
10
Install

Drag to Install!

Drag to your running Eclipse* workspace.
*Requires Eclipse Marketplace Client

Add this URL to your Eclipse Installation to reach this solution's update site.

2020-06 (4.16)
2020-03 (4.15)
2019-12 (4.14)
2019-09 (4.13)
2019-06 (4.12)
2019-03 (4.11)
2018-12 (4.10)
2018-09 (4.9)
2020-09 (4.17)

https://www.esito.no/updatesite/dbimport

Learn more...

Screenshot 0

Screenshot 1

Details Group Tabs

Details

Reverse engineer your database structure into java JPA classes. Create Java classes, or an Xcore or Ecore representation of your exisiting database. g9 Database Model Import is a free g9 Eclipse plugin producing models based on structure information read from databases.

Given a connection to an existing database, the g9 Database Import will read tables and columns in your database (using the database schema) and create the corresponding model either in Java, Xcore or Ecore depending on the project type of your Eclipse project.

Install g9 Database Import, restart Eclipse and create a Java or Xcore project. Select File > Import... > g9 > Import Database Model to start the import wizard (see the Screenshots).

Complete documentation is available from Help > Help Contents. Select g9 Documentation >  g9 Database Model Import.

Choose

  • which tables to include: by default, all tables are included and a class name based on the table names is suggested
  • which columns to include: by default, all columns are included and an attribute name based on the column names is suggested
  • the data type mappings for your domain model based on the JDBC types - or use default values

An import of your database to a Java Project will create Java classes, an import to an Xcore Project will create an Xcore model, all other Eclipse Project types will result in an Ecore model. The Java classes may be enriched with JPA annotations. If you work with Xcore or Ecore models you should use Eclipse for Java and DSL Developers.

The g9 Database Import connects to a database using JDBC drivers. The built-in drivers are MySQL, MS SQL Server (jTDS) and Sybase ASE (jTDS). Use the function [Maintain JDBC Drivers] in the g9 Import feature to connect to other databases, e.g Oracle, PostgreSQL, Firebird or a DBMS of your choice.

You may download the complete g9 product and use the Database import feature in a g9 Eclipse Project. To be able to exploit the other features in g9, you should create a g9 UI Modeling Project and import your database to an Ecore, Xcore model or Java source with g9 annotations. Please see the User guide for more information about the g9 Database Import feature.

Visit http://www.esito.no/en/products/dbimport for more information.

Similar functionality is available as cloud services. Log in to anonymizer.esito.no and select the DBimport service.

Categories:
  • Application Development Frameworks,
  • Database Persistence,
  • Modeling,
  • Modeling Tools
Tags:
  • database,
  • jpa,
  • ide extension,
  • code generation,
  • reverse engineering,
  • xcore,
  • Ecore,
  • Modeling,
  • Esito
Additional Details
Eclipse Versions: 
2020-06 (4.16), 2020-03 (4.15), 2019-12 (4.14), 2019-09 (4.13), 2019-06 (4.12), 2019-03 (4.11), 2018-12 (4.10), 2018-09 (4.9), 2020-09 (4.17)
Platform Support: 
Windows, Mac, Linux/GTK
Organization Name: 
Esito
Development Status: 
Production/Stable
Date Created: 
Wed, 2016-09-14 09:30
License: 
Commercial - Free
Date Updated: 
Wed, 2022-12-14 09:49
Submitted by: 
Dag Bøyesen
Screenshots
Screenshot 0
Screenshot 1
Metrics
DateRankingInstallsClickthroughs
January 2023211/672109 (0.03%)14
December 2022207/805128 (0.04%)19
November 2022213/808143 (0.04%)15
October 2022213/811134 (0.04%)18
September 2022224/812121 (0.03%)21
August 2022203/808127 (0.04%)9
July 2022183/816171 (0.05%)18
June 2022215/810134 (0.03%)5
May 2022167/810250 (0.06%)20
April 2022218/817139 (0.03%)12
March 2022222/820144 (0.03%)17
February 2022225/819120 (0.03%)26
View Data for all Listings
Errors

Unsuccessful Installs in the last 7 Days: 0

Download last 500 errors (CSV)
External Install Button

Marketplace Drag to Install button

By adding the following code below to your website you will be able to add an install button for g9 Database Import.

HTML Code:


Markdown Syntax:



Output: Drag to your running Eclipse* workspace. *Requires Eclipse Marketplace Client
Sunday, January 29, 2023 - 03:21

Reviews Sign in to post reviews

dbyesen's picture

Tested on STS4

Submitted by Dag Bøyesen on Mon, 2020-11-02 08:32

Works fine with the 4.8.1.RELEASE of STS4.

rsuranga's picture

It's not working with STS4

Submitted by Rakitha Suranga on Fri, 2019-08-16 06:26

Not working with STS4

1. Right click on a Project (JAVA)

2. Import --> "Import Database Model"

It says "An open target project must be selected to run this wizard"

OS - Ubuntu 18.04

 

jland's picture

E9 - error reading DBMS model when importing tables

Submitted by Jonathn Land on Thu, 2019-08-01 14:31

I've been working on this for a few days and I am at a loss. So I am able to connect to my DB connection via the g9 GUI after enterig mysql info in applicaiton properties (I am using Spring Tool Suite). When I click on "fetch table" it loads all the tables from mydb in mysql. I then go to next and it brings them up there for me to selection. So far so god. Then when I select "finish" it says "cannot read dbms table" and throws a communications link error. I know this is a common error, but idk what to add to the code or to application properties to get this to work. I have verified that the correct IP and host is being used. I have turned off the firewall. I have made sure to add autoreconnect and the correct timezone.Any advice on what is the issue? Is there an issue with tomcat? I have increased the time limit in mysql workbench as well and set it to * for the bind addresses. again, any other advice? 

dbyesen's picture

Re: E9 - error reading DBMS model when importing tables

Submitted by Dag Bøyesen on Fri, 2019-08-09 03:30

Could you send the stack trace to support@esito.no

Regards Dag

pmobedi's picture

Unable to download through the Marketplace

Submitted by Pedram Mobedi on Tue, 2018-06-12 07:17

This library does not show on my Marketplace for some reason. And when I drag the button via the browser, I only get the Featured libraries in the Marketplace client. Does any have the same issue?

OS: macOS High Sierra Version 10.14.4

Eclipse: Oxygen.2 Release 4.7.2

pdigre's picture

Re: Unable to download through the Marketplace

Submitted by Per Digre on Wed, 2018-06-20 08:20

Try now. ;-)

pdigre's picture

Re: Unable to download through the Marketplace

Submitted by Per Digre on Wed, 2018-06-13 10:35

Have you clicked "Accept cookies" on the Eclipse Marketplace web-page? Before I did that, it returned a blank Marketplace page when dropping the link onto Eclipse. I also have OSX.

pmobedi's picture

Re: Re: Unable to download through the Marketplace

Submitted by Pedram Mobedi on Thu, 2018-06-14 10:13

I have accepted cookies and I have already downloaded many plugins via the marketplace. The problem is I do not even get an error message. It seems as if the marketplace ignores the plugin and shows the default recommended list instead. I'd like to know if others have had this problem, too.

pmobedi's picture

Does not appear in my Eclipse Marketplace

Submitted by Pedram Mobedi on Tue, 2018-06-12 07:01

I have Eclipse Oxygen.3a Release (4.7.3a) installed and have created a Spring Data project using Spring Initializer with JPA and SQL Server dependencies. This library does not show up in the Marketplace when I search for it. So I scroll all the way down and click on "click for more solutions". This opens a tab in the Eclipse web browser in which I see the g9 Database Import in the search results. So I click on "Install". The marketplace is opened with no g9 in the results. This is slightly confusing. 

pdigre's picture

Re: Does not appear in my Eclipse Marketplace

Submitted by Per Digre on Tue, 2018-06-19 03:46

I am not sure where the problem lies. As a backup solution you can try our updtate site http://updatesite.esito.no/dbimport. Have a look at our support/download site http://www.esito.no/en/download/ for further instructions.

Markets

  • Eclipse Project (4)
  • Tools (1342)
    • Application Development Frameworks (171)
    • Application Management (32)
    • Application Server (31)
    • BIRT (10)
    • Build and Deploy (104)
    • Business Intelligence, Reporting and Charting (14)
    • Code Management (117)
    • Collaboration (37)
    • Database (44)
    • Database Development (34)
    • Database Persistence (17)
    • Documentation (60)
    • Eclipse Kura (122)
    • Eclipse SmartHome (46)
    • EclipseRT Target Platform Components (10)
    • Editor (339)
    • Entertainment (14)
    • General Purpose Tools (124)
    • Graphics (34)
    • IDE (344)
    • Internet of Things (IoT) (35)
    • J2EE Development Platform (44)
    • J2ME (5)
    • Languages (155)
    • Linux Tools (19)
    • Logging (22)
    • Mobile and Device Development (49)
    • Modeling (90)
    • Modeling Tools (146)
    • Mylyn Connectors (20)
    • Network (14)
    • Other (74)
    • Process (18)
    • Profiling (22)
    • Programming Languages (100)
    • Reporting (32)
    • Rich Client Applications (39)
    • Science (4)
    • SCM (20)
    • Search (42)
    • SOA Development (15)
    • Source Code Analyzer (99)
    • Systems Development (59)
    • Team Development (54)
    • Testing (90)
    • Tools (568)
    • UI (97)
    • UML (40)
    • Web (90)
    • Web Services (31)
    • Web, XML, Java EE and OSGi Enterprise Development (32)
    • XML (29)
  • IoT (172)
    • Eclipse Kura (122)
    • Eclipse SmartHome (46)
  • RCP Applications (79)
  • Training & Consulting (53)
  • Long Term Support (11)

Search

Advanced Search

More like this

  • g9 Modeling Tools
  • anqu method
  • Workshop JPA/Hibernate Designer
  • Solution Blueprint- Community Edition
  • g9 Anonymizer

Favorited by

Eclipse Foundation

  • About Us
  • Contact Us
  • Sponsor
  • Members
  • Governance
  • Code of Conduct
  • Logo and Artwork
  • Board of Directors
  • Careers

Legal

  • Publishing Guidelines
  • Privacy Policy
  • Terms of Use
  • Copyright Agent
  • Eclipse Public License
  • Legal Resources

Useful Links

  • Welcome to Marketplace
  • Report a Bug
  • Documentation
  • How to Contribute
  • Mailing Lists
  • Forums
  • Marketplace

Other

  • IDE and Tools
  • Projects
  • Working Groups
  • Research@Eclipse
  • Report a Vulnerability
  • Service Status

Copyright © Eclipse Foundation. All Rights Reserved.

Back to the top