db_proj_backend

NBU database course final project backend repo.

Environment

Java

• JDK 24 (Using java 21 in this repo)
• Apache Maven 3.9
• OpenGauss 5.0 (No matter using docker or VM installation) with opengauss-jdbc-5.0.0.jar
  • Configured with sha256 password encryption.
  • Database name: db_proj
  • Database user: dbproj
  • Database password: dbproj@123
  • Create this user with CREATE USER dbproj SYSADMIN PASSWORD 'dbproj@123';
  • You may refer to OpenGauss 5.0在Docker下的安装 - OpenGauss 5.0 Docker Installation

OpenGauss Driver installation via mvn

Configure maven and MAVEN_HOME first.

Execute following command in cmd or powershell

mvn install:install-file -Dfile="/path/to/opengauss-jdbc-5.0.0.jar" -DgroupId=org.opengauss -DartifactId=opengauss-jdbc -Dversion=5.0.0 -Dpackaging=jar -DgeneratePom=true

Replace /path/to/opengauss-jdbc-5.0.0.jar to your own JDBC driver path, then reinstall mvn dependencies in this repo