JpaRepository<TransactionEntity,Long>
{
    @Query(value = "select productid,name,dimensiontype,productcount,n" +
            "producttotalsoldprice from transactionss inner join productentity n" +
            "on productentity.id = transactionss.productidn" +
            " where transactionss.create_date >= :startDate and transactionss.create_date <= :endDate",nativeQuery = true)
    List<Object[]> reportForTable (@Param("starDate")Date startDate, @Param("endDate")Date endDate);

}

WARNING: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'orderServiceImpl': Unsatisfied dependency expressed through field 'transactionRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionRepository': Invocation of init method failed; nested exception is java.lang.IllegalStateException: Using named parameters for method public abstract java.util.List uz.dukon.repository.TransactionRepository.reportForTable(java.util.Date,java.util.Date) but parameter 'Optional[starDate]' not found in annotated query 'select productid,name,dimensiontype,productcount,
producttotalsoldprice from transactionss inner join productentity
on productentity.id = transactionss.productid
 where transactionss.create_date >= :startDate and transactionss.create_date <= :endDate'!
фев 23, 2019 12:38:31 PM org.springframework.orm.jpa.AbstractEntityManagerFactoryBean destroy
INFO: Closing JPA EntityManagerFactory for persistence unit 'default'
Exception in thread "Thread-4" org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'orderServiceImpl': Unsatisfied dependency expressed through field 'transactionRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionRepository': Invocation of init method failed; nested exception is java.lang.IllegalStateException: Using named parameters for method public abstract java.util.List uz.dukon.repository.TransactionRepository.reportForTable(java.util.Date,java.util.Date) but parameter 'Optional[starDate]' not found in annotated query 'select productid,name,dimensiontype,productcount,
producttotalsoldprice from transactionss inner join productentity
on productentity.id = transactionss.productid
 where transactionss.create_date >= :startDate and transactionss.create_date <= :endDate'!
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:586)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:372)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1341)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:572)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:495)