OOP CA4

Old Repo - Bitbucket

New Repo - GitHub

Authors

• Andrew Carolan
• Cameron Scholes

Setup Instrcutions

Option 1 - FTS Hosted

1. Download a Client-X.X_FTS.jar file from the releases pages.
2. Run the client file using the following command

java -jar Client-X.X_FTS.jar

Option 2 - Self Hosted - Compiled JAR

1. Download a Client and Server JAR file from the releases pages.
2. Create a database in SQL and import oop_ca4_andrew_cameron.sql.
3. In the same location as Server-X.X.jar add a config.json file with the following content

{
  "DATABASE_HOST" : "127.0.0.1",
  "DATABASE_USER" : "root",
  "DATABASE_PASS" : "",
  "DATABASE_NAME" : "oop_ca4_andrew_cameron"
}

and edit it to match your setup. 4. Run the server file using the following command

java -jar Server-X.X.jar

5. Run the client file using the following command

java -jar Client-X.X_localhost.jar

Option 3 - Self Hosted - Source Code

1. Clone the project and cd into the project folder
2. Create a database in SQL and import oop_ca4_andrew_cameron.sql
3. Rename config.json.sample to config.json and edit it to match your setup
4. Run the following commands

gradle clientJar
gradle serverJar

5. To start the server run the following command

java -jar build/libs/Server-0.5.jar

6. To start the client, in a seperate terminal run the following command

java -jar build/libs/Client-0.5.jar

Project Description

This java application is a client-server application which will grant users access to a database of movies that they can interact with. Some of the functionality that the users can avail of is:

• Register to the server

  • The client will be given a persistent ID for them to use with the database.

• Add

  • Allows clients to add new movies to the database.

• Remove

  • Allows clients to remove data from the database.

• Update

  • Users can change certain info about the movies in the database.

• Watch

  • Users will be able to track what movies in the database they have watched.

• Recommend

  • Will recommend users movies that they should watch.

Fixes we were given

• Aaron gave us the fix for the error Connection failed The server time zone value 'GMT Summer Time' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

SET @@global.time_zone = '+00:00';
SET @@session.time_zone = '+00:00';

• James gave me the solution for ensuring a successful database insert and update