Pet Catalog - Java EE 6 Sample Application

Change the Root Account Password to 'nbuser'

1. Open a command-line prompt and navigate to the bin directory within your MySQL installation.

   shell> cd <install-dir>/bin

   (Where <install-dir> is the path to your MySQL installation directory.)
   
   
2. Type in the following:

   shell> mysql -u root
   mysql> UPDATE mysql.user SET Password = PASSWORD('nbuser') WHERE User = 'root';
   mysql> FLUSH PRIVILEGES;

   For more information, see the official MySQL Reference Manual: Securing the Initial MySQL Accounts.

Register the Server in the IDE

1. In the Services window (Ctrl-5; ⌘-5 on Mac), right-click the Databases node and choose Register MySQL Server.
   
2. In the MySQL Server Properties dialog, under the Basic Properties tab, you can see the default settings for the MySQL server installation. These are:
   • Server Host Name: localhost
   • Server Port Number: 3306
   • Administrator User Name: root
   • Administrator Password: nbuser
3. Select the Save Password option.
   
4. Click OK. The IDE connects to your MySQL database server, and lists database instances that are maintained by the server.

Create a Database Instance

1. Right-click the MySQL Server node and choose Create Database.
2. In the dialog that displays, type in petcatalog. Select the 'Grant Full Access to' option, then select from the drop-down field.
   
3. Click OK. When you do so, an empty database named petcatalog is created, and a connection to the database is automatically established. Connections are displayed in the Services window using a connection node ( ).

Create database tables and populate them with sample data

1. In the Projects window, expand the Server Resources node and double-click catalog.sql to open it in the IDE's editor.
2. In the Connection drop-down above the editor, select the jdbc:mysql://localhost:3306/petcatalog connection that you created in the previous step.
3. Click the Run SQL ( ) button in the editor's toolbar. The script runs on your MySQL server.

<jdbc-connection-pool allow-non-component-callers="false"
                      associate-with-thread="false"
                      connection-creation-retry-attempts="0"
                      connection-creation-retry-interval-in-seconds="10"
                      connection-leak-reclaim="false"
                      connection-leak-timeout-in-seconds="0"
                      connection-validation-method="auto-commit"
                      datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
                      fail-all-connections="false"
                      idle-timeout-in-seconds="300"
                      is-connection-validation-required="false"
                      is-isolation-level-guaranteed="true"
                      lazy-connection-association="false"
                      lazy-connection-enlistment="false"
                      match-connections="false"
                      max-connection-usage-count="0"
                      max-pool-size="32"
                      max-wait-time-in-millis="60000"
                      name="petCatalogPool"
                      non-transactional-connections="false"
                      pool-resize-quantity="2"
                      res-type="javax.sql.ConnectionPoolDataSource"
                      statement-timeout-in-seconds="-1"
                      steady-pool-size="8"
                      validate-atmost-once-period-in-seconds="0"
                      wrap-jdbc-objects="false">

  <property name="URL" value="jdbc:mysql://localhost:3306/petcatalog"/>
  <property name="User" value="root"/>
  <property name="Password" value="nbuser"/>
</jdbc-connection-pool>

<jdbc-resource enabled="true"
               jndi-name="jdbc/petcatalog"
               object-type="user"
               pool-name="petCatalogPool">
</jdbc-resource>

* The sun-resources.xml file is not included in the sample application bundled with IDE versions 6.8 and 6.9. To create the file, perform the following steps.

1. Open the Files window (Ctrl-2; ⌘-2 on Mac).
2. Create a new folder in the PetCatalog project named setup. To do so, right-click the project node and choose New > Folder. (If Folder is not displayed, choose Other. Select the Other category, then select the Folder file type. Click Next.)
3. Name the folder setup, then click Finish.
4. Save sun-resources.xml to your computer.
5. Copy (Ctrl-C; ⌘-C on Mac) the sun-resources.xml file from the location on your computer, then paste (Ctrl-V; ⌘-V on Mac) it into the setup folder.
6. Switch to the Projects window (Ctrl-1; ⌘-1 on Mac) and note that the sun-resources.xml file is displayed in the Server Resources node within the project.