Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Start the server and Launch the Administrative Console using the URL http://localhost:8080/console.
  2. Enter default username and password.
  3. In the welcome page, Under Embedded DB, Select DB Manager.





  4. On the next page create a database userdbs and Select create.





  5. Once done you can see the userdbs database listed in DB Viewer portlet under Databases. This confirms that the database has been successfully created.





  6. As shown in the figure under Use DB, select userdbs from the dropdown box.





  7. Run the userinfo.sql script. Select Run Sql.


    Image Added


  8. To verify the table creation succeeded. Select Application as shown in the figure.


    Image Added


  9. Next screen suggests the table has been successfully created. To view the contents of the table select VIEW CONTENTS.


    Image Added


  10. The table is currently empty as shown in th figure.


    Image Added