Technical requirements

• The data exchange between the client and server must be carried out using TCP.
• The server should use input/output streams.
• The client should use the network channel.
• Use java.sql.DriverManager to connect to the database.
• The username and password for connecting to the database should be specified in the arguments of the getConnection() method.
• Use javax.sql.rowset.FilteredRowSet to get query results.
• Collective data deletion and insertion operations must be implemented using transactions.
• Single data modification operations must be implemented using the CallableStatement.execute() method.

How-to-run

• Server database

  cd ServerDataBase
  mvn compile 
  mvn exec:java

• Client database

  cd ClientDataBase
  mvn compile 
  mvn exec:java

Results

After completing this laboratory work I found out how to internationalize application using Resource Bundle and create ORM with the reflection.

Next actions

• Add command to "How-to-run" section that will help to start standalone PostgreSQL Server in Docker with port forwaring