Create tables in MySQL using JDev


Steps:

  • Setup MySQL
  • Setup JDev
  • Create a new JDev Application
  • Create a new Database Diagram with a sample Table
  • Add columns to the table
  • Create a database connection from JDev to MySQL
  • and Publish the Table to MySQL

Note:  Put the mysql-connector-java-3.1.14-bin.jar in the lib path (JDEV or JDK) to avoid Driver Not Found type errors. Google mysql connector and you should find the installer or zip file – once you extract it you can copy the jar into your lib path (if there is a “proper” way – i.e. extract and set the classpath on windows so that JDEV knows where to look for this driver jar then do it that way).

Published by techiecook

Alok is the "Techie Cook". He loves technology and cooking. While his cooking recipies are a work in progress, Alok is expressing his technology experience in his posts. In his posts, Alok brings experience in engineering and architecting distributed software systems from over 20 years across industry and consulting. His posts focus on Systems Integration, API design, Microservices and Event driven systems, Modern Enterprise Architecture and other related topics

Leave a Comment

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s