Why my Repository method is null?

[Eleni Pap]

On my service create invoiceProduct I have the above code:      

 for(InvoiceProductDTOTotal total: createInvoiceDTO.getInvoiceProductDTOTotalList()){

            Product product=productRepository.getOne(total.getProductId());
            Shelf shelf=shelfRepository.getOne(total.getShelfId());

            invoiceProduct.setProduct(product);
            invoiceProduct.setShelf(shelf);
            invoiceProduct.setQuantity(total.getQuantity());
            invoiceProduct.setInvoice(invoice);

            invoiceProducts.add(invoiceProduct);
            
        }

  invoice=invoiceRepository.save(invoice);
        invoiceProductRepository.saveAll(invoiceProducts);

  
            Retrieval existRetrieval=retrievalRepository.findByProductAndShelfAndDate(invoiceProduct.getProduct(),invoiceProduct.getShelf(), invoice.getDate());
       ......
        retrievalRepository.save(retrieval);

I cannot undrestand why is null the result of
           Retrieval existRetrieval=retrievalRepository.findByProductAndShelfAndDate(invoiceProduct.getProduct(),invoiceProduct.getShelf(), invoice.getDate());

invoiceProduct is a list ,

My JSON on postman is this...
{
       .....
        "invoiceProductDTOTotalList" : [
                {
                "shelfId" : "35",
                "productId" : "adada",
                "quantity": 10
                }

        ]


my problem is about existRetrieval cannot find an existing retrieval...

[Dave Tolls]

What is the connection between all these bits of code?

Have you looked in the database to see what data is being stored there?

[Eleni Pap]

The data saved all ok, but I want if I had an already an already entity  retrieval to change some of its data.
For example if
  Retrieval existRetrieval=retrievalRepository.findByProductAndShelfAndDate(invoiceProduct.getProduct(),invoiceProduct.getShelf(), invoice.getDate());  (!=null)
...to  make changes.

Although I have already the data:
 invoiceProduct.setProduct(product);
 invoiceProduct.setShelf(shelf);

when existRetrieval start, find that product is null, shelf is null, as a result, cannot be not null the exist retrieval.

[Eleni Pap]

Date was the problem. It got date as null and program returned the target null exception.