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

Leave a Comment

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

WordPress.com Logo

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

Facebook photo

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

Connecting to %s