org.postgresql.util.PSQLException: ERROR: procedure new_order(integer, integer, integer, character varying, character varying) does not exist
  Подсказка: No procedure matches the given name and argument types. You might need to add explicit type casts.

CREATE OR REPLACE PROCEDURE public.new_order(IN member_id integer, IN product_id integer, IN quantity integer, IN approvalstatus text, IN transactiondate date)
    LANGUAGE 'plpgsql'
    
AS $BODY$
Declare
   transact_id INT;
Begin
	SELECT MAX(transaction_id) INTO transact_id FROM Transactions;
	INSERT INTO Transactions VALUES(transact_id + 1, member_id, product_id, quantity, approvalstatus, transactiondate);
END;
$BODY$;

	public boolean addOrder(
			int MEMBER_ID, 
			int PRODUCT_ID, 
			int QUANTITY, 
			String TRANSACTION_DATE) {
		
		boolean isAdded = false;
		
		try {
			_preparestatement = _connection.prepareStatement("call new_order(?,?,?,?,?)");
			_preparestatement.setInt(1, MEMBER_ID);
			_preparestatement.setInt(2, PRODUCT_ID);
			_preparestatement.setInt(3, QUANTITY);
			_preparestatement.setString(4, "PENDING");
			_preparestatement.setString(5, TRANSACTION_DATE);
			_preparestatement.execute();
			
			isAdded = true;
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		
		return isAdded;
	}

	LocalDate now = LocalDate.now();
	_database.addOrder(member_id, prod_id, quant, now.toString());

...
import java.sql.Date;
.....
	public boolean addOrder(
			int MEMBER_ID, 
			int PRODUCT_ID, 
			int QUANTITY, 
			Date TRANSACTION_DATE) {
		
		boolean isAdded = false;
		
		try {
			_preparestatement = _connection.prepareStatement("call public.new_order(?,?,?,?,?)");
			_preparestatement.setInt(1, MEMBER_ID);
			_preparestatement.setInt(2, PRODUCT_ID);
			_preparestatement.setInt(3, QUANTITY);
			_preparestatement.setString(4, "PENDING");
			_preparestatement.setDate(5, TRANSACTION_DATE);
			_preparestatement.execute();
			
			isAdded = true;
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		
		return isAdded;
	}

...
import java.sql.Date;
...
	long millis=System.currentTimeMillis();
	Date now = new Date(millis);
	_database.addOrder(member_id, prod_id, quant, now);