Cannot generate entities from existing MySQL db using JPA Tools [message #1817352] |
Wed, 20 November 2019 23:21 |
Russell Longo Messages: 6 Registered: November 2019 |
Junior Member |
|
|
Fairly new to Java, Eclipse and JPA. I was steered toward using JPA for CRUD database application development. As i have seen posted in earlier messages (more than 5 years old) I also am not able to create entities from an existing database using the JPA tool, because a list of schemas, and their corresponding tables, do not show up in the dropdown list box in the Entity Creation dialog under JPA tools. They also do not show up in the Data Source Explorer.
I read in older posts that you have to explicitly name the database/schema in your URL string for the Dali JPA tools to actually work. I attempted that, here are the Connection details below related to a schema (database) called game_world in a MySQL database.
Eclipse: Version: 2019-03 (4.11.0)
Build id: 20190314-1200
JPA: 2.1
Configuration: Basic JPA Configuration
CONNECTION CONFIGURATION
Database: game_world (tried this and mysql)
URL: jdbc:mysql://localhost:3306/game_world (also tried it without game_world)
driver class in Driver Definition: I tried the following classes com.mysql.jdbc.Driver
com.mysql.cj.jdbc.Driver
driver version: 8.0.16
Note: I can ping the database successfully from the Connection Dialog Box, and both my and the default schemas that came with MySQL show up in Data Source Explorer, but they are devoid of any tables, views, etc. And as mentioned, nothing gets populated in the schema dropdown in the RPA Tool window.
I also installed DBeaver after this, just to see if another interface tool could see the DB tables, and it had no issues listing all the tables. DBeaver used the above Connection to do that.
Based on recommendations, it would seem that object mapping is the best route for the type of application I want to write. But having to code every entity by hand from the current DB or future database really doesn't make it attractive without a tool to facilitate the entity creation.
Appreciate any help I can get!!
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.27147 seconds