Hello everyone,
I'm struggling with my code. Every time I get the error that a specific relation (a table in a databse) does not exist. I don't know how to fix this. In pgAdmin4 the relation is obviously visible and accessible through SQL. My queries don't seem to have any errors.
I have attached the error trace as well as my code.
I'd be very thankful for any help. Thanks in Advance.
Main.java:
package de.rezeptekompass;
import java.sql.SQLException;
import java.util.List;
import de.rezeptekompass.controller.db.DBConnect;
import de.rezeptekompass.controller.db.VorratsschrankDAO;
import de.rezeptekompass.model.Vorratsschrank;
import javafx.application.Application;
import javafx.stage.Stage;
public class Main extends Application {
public static void main(String[] args) {
launch(args);
}
@Override
public void start(Stage primaryStage) {
// try {
DBConnect dbConnect = new DBConnect();
dbConnect.connectToDB("postgres", "password");
VorratsschrankDAO vorratsschrankDAO = new VorratsschrankDAO(dbConnect);
List<Vorratsschrank> schraenke;
System.out.println(schraenke = vorratsschrankDAO.getAllVorratsschraenke());
// FXMLLoader loader = new FXMLLoader(getClass().getResource("VorratsschrankDoc.fxml"));
// VorratsschraenkeViewController controller = new VorratsschraenkeViewController(vorratsschrankDAO);
// loader.setController(controller);
//
//
// Scene scene = new Scene(loader.load());
// primaryStage.setTitle("Rezepte-Kompass");
// primaryStage.setScene(scene);
// primaryStage.show();
//
//
// primaryStage.setOnCloseRequest(event -> dbConnect.closeConnection());
// } catch (SQLException e) {
// e.printStackTrace();
// }
}
}
