Application for Files

Spring Boot Project

• Connect with multiple Oracle schemas

• Stored procedure calls using the JPA

• SFTP file trasfer, authentication method with public/private key or username/password

• Frontend - Thymeleaf + AdminLTE + Bootstrap + AJAX

• Apache POI - the Java API for Microsoft Documents

• Role Based Access Control with Spring Security

• Lombok - Project Lombok

• application.properties - add HOST, PORT, SERVICE_NAME depend on your connection params

• sftp.properties - add Host, Username, Private Key Location for SFTP transfer

• storage.properties - folder stucture for storing files on servers

• SQL script for creating: schemas, tables, indexes, constraints, stored procedures
       additional folder is not part of the project, containing additional files such as db.sql, DockerHub Oracle Database Image desc.Oracle Database Enterprise Edition by Oracle | Docker Hub and Setup Instructions

• Build and Run
   1. Executable jar
     go to: /com.appforfiles/
       and run: gradlew buildJar
     go to: /com.appforfiles/build/libs
       and run: java -jar com.appforfiles-0.1.jar
   

  • Web app link
    username:admin
    password:K65HC&x'NBSu5V(m
    username:user
    password:c)q_3!dp2av#^{X~
    
    Screenshoots:
    
  Error example: