A marketing application with JEE and JPA (DataBases 2 class project)

A.Y. 2020 // Group 67 // Danelutti, Di Dio Lavore, Franchini

IntelliJ project with source code for the Databases 2 class optional project. The purpose is to deploy a Java EE application with a MySQL database.

Setup

You'll need to download the following tools:

• TomEE
• MySQL
• Connector/J (choose the Platform Indipended version)

1. Clone this repository

git clone https://github.com/LucaDanelutti/db2-2020-Danelutti-DiDioLavore-Franchini
# or
gh repo clone LucaDanelutti/db2-2020-Danelutti-DiDioLavore-Franchini

2. Download and uncompress TomEE somewhere
3. Download and install MySQL
4. Open the project folder with IntelliJ IDEA Ultimate
5. In the menu bar, Run > Edit Configurations...
6. Click '+' in the top left and select TomEE Server > Local
7. If needed, click Configure... (beside Application Server) and point to the TomEE folder
8. Select a TomEE version
9. Leave everything else on default settings
10. In the Deployment tab, under Deploy at the server startup click '+' and select Artifact... and choose the one ending with ":war exploded"
11. Click Apply
12. If you haven't configured MySQL yet, do it now and take note of the credentials
13. Create a schema called marketing_application
14. In IntelliJ navigate to _View > Tool Windows > Database, click '+' and select Data Source > MySQL and fill in with your database connection credentials
15. In Database field, specify marketing_application and test the connection
16. Click Apply
17. In the Database panel, select marketing_application under your database, right click and select Run SQL script...
18. Select sql-dump/marketing_application.sql and run it
19. Navigate to the TomEE folder, and open conf/tomee.xml
20. Between the <tomee>...</tomee> tags, add the following code, replacing SERVER, USERNAME and PASSWORD with the credentials the application will use to connect to the database

  <Resource id="MarketingApplicationDB" type="DataSource">
    JdbcDriver com.mysql.cj.jdbc.Driver
    JdbcUrl jdbc:mysql://SERVER:3306/marketing_application
    UserName USERNAME
    Password PASSWORD
  </Resource>

22. Download Connector/J, uncompress it and drop mysql-connector-java- in /lib

Test setup

1. Run the server with Shift + F10 (or click the green play button); if it's not clickable, close and reopen IntelliJ
2. Once the browser opens, try logging in with username user1 and password user
3. If the setup was successful, you'll see a welcome page. If you get a 404 error page you probably didn't setup tomee.xml at step 20; if you can't get the server to load, you probably haven't installed TomEE or Connector/J correctly.