Introduction

This page provides downloads related to the Morel Island Database JPA and CRUD Generation plugin for the NetBeans IDE .

Table of Contents

• NetBeans IDE Plugins
  • MI - Database JPA and CRUD Generation
  • Other MI Plugins
• Databases for Use with Generated Projects
  • Derby DB Databases (JavaDB)
  • MySQL Databases

NetBeans IDE Plugins

Morel Island Java Services provides a number of plugins for the NetBeans IDE version 7.1.

MI - Database CRUD Generation

To generate new JPA and CRUD projects the MI - Database JPA and CRUD generation plugin must be downloaded and installed in the NetBeans IDE.

Start the NetBeans IDE and follow the steps below to install the plugin

1. From the main menu select Tools -> Plugins.
   
2. From the Plugin Dialog select the Settings tab and press the Add button.
3. Fill in the Update Center Customizer dialog as shown in Figure 1 and press the OK button.
   
   
   • Name: Morel Island Java Services
   • URL: http://morelisland.com/java_services/netbeans/7.1/modules/catalog.xml

   Figure 1: Update Center Customizer Dialog

   

4. Select the Available Plugins tab from the Plugins dialog.
5. Select the MI - Database JPA and CRUD Generation plugin as in Figure 2 below.

   Figure 2: Available Plugins Tab with MI - Database JPA and CRUD Generation Selected

   

6. Press the install button. The Plugin Installer Dialog will display the additional Morel Island plugins that will be installed along with the MI - Database JPA and CRUD Generation plugin. These plugins are all NetBeans Library definitions, the contents of which can be seen in the Library Manager dialog by selecting Tools from the NetBeans main menu, followed by Libraries.

   Figure 3: NetBeans IDE Plugin Installer Dialog

   

7. Press the Next button and follow the remaining steps to install the plugin. Please note the plugin is not certified, press the continue button when a warning prompt to this effect is displayed.

Other MI Plugins

To download and install other Morel Island Java Services plugins in the NetBeans IDE:

Start the NetBeans IDE and follow the steps below to install other plugins

1. From the main menu select Tools -> Plugins.
   
2. Select the Available Plugins tab from the Plugins dialog.
3. Select the additional plugin required. All Morel Island Java Services plugins are prefixed with MI -

   Figure 4: Available Plugins Tab with MI Library Plugins Selected

   

   Figure 5: Available Plugins Tab with MI Database Plugins Selected

   

4. Select the plugins required and press the install button. Follow the remaining steps to install the plugin. Please note the plugins are not certified, press the continue button when a warning prompt to this effect is displayed.

Databases for Use with Generated Projects

Derby DB Databases (JavaDB)

• midbmetadata - The internal project database used by the plugin to store database metadata
• sample - The NetBeans IDE purchase order sample database
• travel - The NetBeans IDE MySQL travel database in JavaDB
• vir - The NetBeans IDE MySQL Vehicle Identification and Registration database in JavaDB

• icms33 - Integrated Customer Management System Version 3.3 (simplified)

The databases should be unzipped into the Java DB network server database directory to provide them to clients at a URL of jdbc:derby://localhost:1527/<db>. The database directory can be found from the Java DB properties in the NetBeans IDE by moving to the Services tab, expanding the Databases node, right clicking the JavaDB node, then selecting Properties from the popup menu. A dialog similar to Figure 6 will be displayed.

Figure 6: Java DB Properties Dialog

MySQL Databases

These zip files can be unzipped to a directory of your choice. The zip file contains an SQL script generated by the backup database functionality of the MySQL Administrator and can be restored using the same tool. The script files contain special DDL which limits their use exclusively to MySQL.

• sample - The NetBeans IDE purchase order sample database
• travel - The NetBeans IDE MySQL travel database
• vir - The NetBeans IDE MySQL Vehicle Identification and Registration database

• icms33 - Integrated Customer Management System Version 3.3 (simplified)

Alternately, to create the MySQL databases along with the NetBeans IDE database connections, right click the MySQL Server node under the Databases node in the Services tab, select Create Database from the popup menu then scroll the New Database Name combo box and select the required database.

Home Java Home Documentation Downloads Links Contact Us

Last Updated 12 Feb 2012