Spring Data JPA - No Property Found for Type Exception

Question

Well  I searched Google and found many results  but none of them was able to answer my problem  So  here it goes   I am trying to study Spring MVC and Spring Data JPA by doing a minimal implementation of pinterest clone  So  following is the parts of code which I think is relevant to my problem   Models Entities   Entity  Table name    pin item   public class PinItem implements Serializable          properties          JoinColumn name    board id   referencedColumnName    user board id        ManyToOne optional   false      private UserBoard board          getters and setters        Entity  Table name    user board   public class UserBoard implements Serializable          properties          OneToMany cascade   CascadeType ALL  mappedBy    board       private List lt PinItem gt  pinItemList          getters and setters        Service   Service  Transactional readOnly   true  public class BoardServiceImpl implements BoardService        Autowired     private UserBoardRepository boardRepository        Override     public List lt UserBoard gt  findLatestBoards             PageRequest request   new PageRequest                       0  PresentationUtil PAGE SIZE                        Sort Direction DESC   boardId                     return boardRepository findAll request  getContent                  Other Methods     Repository  public interface UserBoardRepository extends JpaRepository lt UserBoard  Integer gt         Now  when I call the findLatestBoards method in BoardService   No Property Found  exception is thrown on the line return boardRepository findAll request  getContent     Here is the excerpt from tomcat log   DEBUG LOG  12 28 44 254 DEBUG AnnotationTransactionAttributeSource 106 - Adding transactional method  findLatestBoards  with attribute  PROPAGATION REQUIRED ISOLATION DEFAULT readOnly     12 28 44 254 DEBUG DefaultListableBeanFactory 246 - Returning cached instance of singleton bean  transactionManager  12 28 44 254 DEBUG JpaTransactionManager 366 - Creating new transaction with name  com tecnooc picpin service impl BoardServiceImpl findLatestBoards   PROPAGATION REQUIRED ISOLATION DEFAULT readOnly     12 28 44 254 DEBUG JpaTransactionManager 369 - Opened new EntityManager  org hibernate ejb EntityManagerImpl 75284194  for JPA transaction 12 28 44 255 DEBUG AbstractTransactionImpl 158 - begin 12 28 44 255 DEBUG LogicalConnectionImpl 212 - Obtaining JDBC connection 12 28 44 255 DEBUG DriverManagerDataSource 162 - Creating new JDBC DriverManager Connection to  jdbc mysql   localhost 3306 pic pin  12 28 44 266 DEBUG LogicalConnectionImpl 218 - Obtained JDBC connection 12 28 44 267 DEBUG JdbcTransaction 69 - initial autocommit status  true 12 28 44 267 DEBUG JdbcTransaction 71 - disabling autocommit 12 28 44 267 DEBUG JpaTransactionManager 401 - Exposing JPA transaction as JDBC transaction  org springframework orm jpa vendor HibernateJpaDialect HibernateConnectionHandle 370da60e  12 28 44 274 DEBUG TransactionalRepositoryProxyPostProcessor CustomAnnotationTransactionAttributeSource 286 - Adding transactional method  findAll  with attribute  PROPAGATION REQUIRED ISOLATION DEFAULT readOnly     12 28 44 274 DEBUG DefaultListableBeanFactory 246 - Returning cached instance of singleton bean  transactionManager  12 28 44 274 DEBUG JpaTransactionManager 332 - Found thread-bound EntityManager  org hibernate ejb EntityManagerImpl 75284194  for JPA transaction 12 28 44 274 DEBUG JpaTransactionManager 471 - Participating in existing transaction 12 28 44 279 DEBUG CachedIntrospectionResults 159 - Not strongly caching class  java io Serializable  because it is not cache-safe 12 28 44 281 DEBUG JpaTransactionManager 851 - Participating transaction failed - marking existing transaction as rollback-only 12 28 44 281 DEBUG JpaTransactionManager 559 - Setting JPA transaction on EntityManager  org hibernate ejb EntityManagerImpl 75284194  rollback-only 12 28 44 283 DEBUG JpaTransactionManager 844 - Initiating transaction rollback 12 28 44 284 DEBUG JpaTransactionManager 534 - Rolling back JPA transaction on EntityManager  org hibernate ejb EntityManagerImpl 75284194  12 28 44 284 DEBUG AbstractTransactionImpl 203 - rolling back 12 28 44 284 DEBUG JdbcTransaction 164 - rolled JDBC Connection 12 28 44 285 DEBUG JdbcTransaction 126 - re-enabling autocommit 12 28 44 285 DEBUG JpaTransactionManager 594 - Closing JPA EntityManager  org hibernate ejb EntityManagerImpl 75284194  after transaction 12 28 44 285 DEBUG EntityManagerFactoryUtils 338 - Closing JPA EntityManager 12 28 44 286 DEBUG LogicalConnectionImpl 232 - Releasing JDBC connection 12 28 44 286 DEBUG LogicalConnectionImpl 250 - Released JDBC connection 12 28 44 287 DEBUG ExceptionHandlerExceptionResolver 132 - Resolving exception from handler  public java lang String com tecnooc picpin controller BoardController latest javax servlet http HttpSession org springframework ui Model    org springframework data mapping PropertyReferenceException  No property board found for type com tecnooc picpin model UserBoard 12 28 44 289 DEBUG ResponseStatusExceptionResolver 132 - Resolving exception from handler  public java lang String com tecnooc picpin controller BoardController latest javax servlet http HttpSession org springframework ui Model    org springframework data mapping PropertyReferenceException  No property board found for type com tecnooc picpin model UserBoard 12 28 44 290 DEBUG DefaultHandlerExceptionResolver 132 - Resolving exception from handler  public java lang String com tecnooc picpin controller BoardController latest javax servlet http HttpSession org springframework ui Model    org springframework data mapping PropertyReferenceException  No property board found for type com tecnooc picpin model UserBoard 12 28 44 291 DEBUG DispatcherServlet 959 - Could not complete request   Exception  The exception is  org springframework data mapping PropertyReferenceException  No property board found for type com tecnooc picpin model UserBoard   But  if I understood correctly  the property board is present in PinItem and is correctly mapped with mappedBy    board  in UserBoard   org springframework data mapping PropertyReferenceException  No property board found for type com tecnooc picpin model UserBoard     at org springframework data mapping PropertyPath  lt init gt  PropertyPath java 75      at org springframework data mapping PropertyPath create PropertyPath java 327      at org springframework data mapping PropertyPath create PropertyPath java 353      at org springframework data mapping PropertyPath create PropertyPath java 307      at org springframework data mapping PropertyPath from PropertyPath java 271      at org springframework data mapping PropertyPath from PropertyPath java 245      at org springframework data jpa repository query QueryUtils toJpaOrder QueryUtils java 408      at org springframework data jpa repository query QueryUtils toOrders QueryUtils java 372      at org springframework data jpa repository support SimpleJpaRepository getQuery SimpleJpaRepository java 456      at org springframework data jpa repository support SimpleJpaRepository getQuery SimpleJpaRepository java 437      at org springframework data jpa repository support SimpleJpaRepository findAll SimpleJpaRepository java 319      at org springframework data jpa repository support SimpleJpaRepository findAll SimpleJpaRepository java 289      at sun reflect NativeMethodAccessorImpl invoke0 Native Method      at sun reflect NativeMethodAccessorImpl invoke NativeMethodAccessorImpl java 57      at sun reflect DelegatingMethodAccessorImpl invoke DelegatingMethodAccessorImpl java 43      at java lang reflect Method invoke Method java 606      at org springframework data repository core support RepositoryFactorySupport QueryExecutorMethodInterceptor executeMethodOn RepositoryFactorySupport java 333      at org springframework data repository core support RepositoryFactorySupport QueryExecutorMethodInterceptor invoke RepositoryFactorySupport java 318      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 172      at org springframework transaction interceptor TransactionInterceptor 1 proceedWithInvocation TransactionInterceptor java 96      at org springframework transaction interceptor TransactionAspectSupport invokeWithinTransaction TransactionAspectSupport java 260      at org springframework transaction interceptor TransactionInterceptor invoke TransactionInterceptor java 94      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 172      at org springframework dao support PersistenceExceptionTranslationInterceptor invoke PersistenceExceptionTranslationInterceptor java 155      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 172      at org springframework data jpa repository support LockModeRepositoryPostProcessor LockModePopulatingMethodIntercceptor invoke LockModeRepositoryPostProcessor java 92      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 172      at org springframework aop interceptor ExposeInvocationInterceptor invoke ExposeInvocationInterceptor java 91      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 172      at org springframework aop framework JdkDynamicAopProxy invoke JdkDynamicAopProxy java 204      at com sun proxy  Proxy147 findAll Unknown Source      at com tecnooc picpin service impl BoardServiceImpl findLatestBoards BoardServiceImpl java 45      at sun reflect NativeMethodAccessorImpl invoke0 Native Method      at sun reflect NativeMethodAccessorImpl invoke NativeMethodAccessorImpl java 57      at sun reflect DelegatingMethodAccessorImpl invoke DelegatingMethodAccessorImpl java 43      at java lang reflect Method invoke Method java 606      at org springframework aop support AopUtils invokeJoinpointUsingReflection AopUtils java 317      at org springframework aop framework ReflectiveMethodInvocation invokeJoinpoint ReflectiveMethodInvocation java 183      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 150      at org springframework transaction interceptor TransactionInterceptor 1 proceedWithInvocation TransactionInterceptor java 96      at org springframework transaction interceptor TransactionAspectSupport invokeWithinTransaction TransactionAspectSupport java 260      at org springframework transaction interceptor TransactionInterceptor invoke TransactionInterceptor java 94      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 172      at org springframework aop framework JdkDynamicAopProxy invoke JdkDynamicAopProxy java 204      at com sun proxy  Proxy148 findLatestBoards Unknown Source      at com tecnooc picpin controller BoardController latest BoardController java 31      at sun reflect NativeMethodAccessorImpl invoke0 Native Method      at sun reflect NativeMethodAccessorImpl invoke NativeMethodAccessorImpl java 57      at sun reflect DelegatingMethodAccessorImpl invoke DelegatingMethodAccessorImpl java 43      at java lang reflect Method invoke Method java 606      at org springframework web method support InvocableHandlerMethod invoke InvocableHandlerMethod java 219      at org springframework web method support InvocableHandlerMethod invokeForRequest InvocableHandlerMethod java 132      at org springframework web servlet mvc method annotation ServletInvocableHandlerMethod invokeAndHandle ServletInvocableHandlerMethod java 104      at org springframework web servlet mvc method annotation RequestMappingHandlerAdapter invokeHandleMethod RequestMappingHandlerAdapter java 745      at org springframework web servlet mvc method annotation RequestMappingHandlerAdapter handleInternal RequestMappingHandlerAdapter java 686      at org springframework web servlet mvc method AbstractHandlerMethodAdapter handle AbstractHandlerMethodAdapter java 80      at org springframework web servlet DispatcherServlet doDispatch DispatcherServlet java 925      at org springframework web servlet DispatcherServlet doService DispatcherServlet java 856      at org springframework web servlet FrameworkServlet processRequest FrameworkServlet java 936      at org springframework web servlet FrameworkServlet doGet FrameworkServlet java 827      at javax servlet http HttpServlet service HttpServlet java 621      at org springframework web servlet FrameworkServlet service FrameworkServlet java 812      at javax servlet http HttpServlet service HttpServlet java 728      at org apache catalina core ApplicationFilterChain internalDoFilter ApplicationFilterChain java 305      at org apache catalina core ApplicationFilterChain doFilter ApplicationFilterChain java 210      at org netbeans modules web monitor server MonitorFilter doFilter MonitorFilter java 393      at org apache catalina core ApplicationFilterChain internalDoFilter ApplicationFilterChain java 243      at org apache catalina core ApplicationFilterChain doFilter ApplicationFilterChain java 210      at org apache catalina core StandardWrapperValve invoke StandardWrapperValve java 222      at org apache catalina core StandardContextValve invoke StandardContextValve java 123      at org apache catalina authenticator AuthenticatorBase invoke AuthenticatorBase java 472      at org apache catalina core StandardHostValve invoke StandardHostValve java 171      at org apache catalina valves ErrorReportValve invoke ErrorReportValve java 99      at org apache catalina valves AccessLogValve invoke AccessLogValve java 953      at org apache catalina core StandardEngineValve invoke StandardEngineValve java 118      at org apache catalina connector CoyoteAdapter service CoyoteAdapter java 408      at org apache coyote http11 AbstractHttp11Processor process AbstractHttp11Processor java 1023      at org apache coyote AbstractProtocol AbstractConnectionHandler process AbstractProtocol java 589      at org apache tomcat util net JIoEndpoint SocketProcessor run JIoEndpoint java 312      at java util concurrent ThreadPoolExecutor runWorker ThreadPoolExecutor java 1145      at java util concurrent ThreadPoolExecutor Worker run ThreadPoolExecutor java 615      at java lang Thread run Thread java 744    I don t get why this exception is thrown  Any idea why it is happening   Note  I am using Hibernate as Persistence provider  Also  the code portion I put here is what I thought is relevant to the problem  If it is not  let me know and I will update the question with required portion

User · Answer

this error happens if you try access un-exists property

my guess is that sorting is done by spring by property name and not by real column name. and the error indicates that, in "UserBoard" there is no property named "boardId".

bests,

Oak

User · Answer

Another scenario  that was not yet mentioned here  that caused this error is an API that receives Pageable  or Sort  and passes it  as is  to the JPA repository when calling the API from Swagger  Swagger default value for the Pageable parameter is this           quot page quot   0       quot size quot   0       quot sort quot            quot string quot             Notice the  quot string quot  there which is a property that does exist  Running the API without deleting or changing it will cause org springframework data mapping PropertyReferenceException  No property string found for type

User · Answer

Note here  the answers from Zane XY and Alan B  Dee are quite good  Yet for those of you who would use Spring Boot now  and Spring Data  here is what would be a more modern answer   Suppose you have a class such as    Entity class MyClass        Id      GeneratedValue     private Long id       private String myClassName      Now a JpaRepository for this would look like  interface MyClassRepository extends JpaRepository       Collection lt MyClass gt  findByMyClassName String myClassName       Now your  custom  find by method must spelled Collection lt MyClass gt  findByMyClassName String myClassName  precisely because Spring needs to have some mechanism to map this method on MyClass property myClassName   I figured this out because  to me  it seemed natural to find a class by its name semantically  whereas in fact  synatxically you find by myClassName  Cheers

User · Answer

If you are using ENUM like MessageStatus  you may need a converter  Just add this class  import javax persistence AttributeConverter  import javax persistence Converter          Convert ENUM type in JPA       Converter autoApply   true  public class MessageStatusConverter implements AttributeConverter lt MessageStatus  Integer gt       Override   public Integer convertToDatabaseColumn MessageStatus messageStatus        return messageStatus getValue            Override   public MessageStatus convertToEntityAttribute Integer i        return MessageStatus valueOf i

User · Answer

You should have that property defined in your model or entity class

User · Answer

In JPA a relationship has a single owner  and by using mappedByin your UserBoard class you tell that PinItem is the owner of that bidirectional relationship  and that the property in PinItem of the relationship is named board   In your UserBoard class you do not have any fields properties with the name board  but it has a property pinItemList  so you might try to use that property instead

User · Answer

In my case I had a typo  camel case  in my method name  I named it to  findbyLastName  and faced this exception  After I changed it to  findByLastName  exception was gone

User · Answer

I had this exception recently when moving to a newer spring-boot version  from 1 5 4 to 1 5 20   The problem was in the repository package structure   Problem  Under the same package were packages  repository  repositoryCustom and repositoryImpl   Solution  Rearrange repository packages so that repository package contains repositoryCustom package and repositoryCustom package contains repositoryImpl    repository          ----- repositoryCustom                             ----- repositoryImpl

User · Answer

Fixed  While using CrudRepository of Spring   we have to append the propertyname correctly after findBy otherwise it will give you exception   No Property Found for Type      I was getting this exception as  because property name and method name were not in sync   I have used below code for DB Access    public interface UserDao extends CrudRepository lt User  Long gt        User findByUsername String username     and my Domain User has property    Entity public class User implements UserDetails                                private static final long serialVersionUID   1L        Id      GeneratedValue strategy   GenerationType AUTO       Column name    userId   nullable   false  updatable   false      private Long userId      private String username

User · Answer

you should receive use page like this    Override public Page lt UserBoard gt  findLatestBoards         PageRequest request   new PageRequest                   0  PresentationUtil PAGE SIZE                    Sort Direction DESC   boardId             return boardRepository findAll request  getContent

User · Answer

If you are using a composite key in your bean  your parameter will be an object  You need to adjust your findBy method according to the new combination   Embeddable public class CombinationId implements Serializable      private String xId    private String yId     public class RealObject implements Serializable  Persistable lt CombinationId gt        EmbeddedId private CombinationId id     In that case  your repository findBy method should be as this  Repository public interface PaymentProfileRepository extends JpaRepository lt RealObject  String gt       List lt RealObject gt  findById XId String someString

User · Answer

this might help someone who had similar issue like me   i followed all naming and interface standards   But i was still facing issue  My param name was -- gt   update datetime   I wanted to fetch my entities based on the update datetime in the descending order  and i was getting the error org springframework data mapping PropertyReferenceException  No property update found for type Release   Somehow it was not reading the Underscore character -- gt        so for workaround i changed the property name as  -- gt  updateDatetime   and then used the same for using JpaRepository methods  It Worked

User · Answer

In Addition to the suggestions  I would also suggest annotating your Repository interface with  Repository  The Spring IOC may not detect this as a repository and thus be unable to detect the entity and its corresponding property

User · Answer

I had a similiar problem that caused me some hours of headache   My repository method was   public List lt ResultClass gt  findAllByTypeAndObjects String type  List lt Object gt  objects     I got the error  that the property type was not found for type ResultClass   The solution was  that jpa hibernate does not support plurals  Nevertheless  removing the  s  solved the problem   public List lt ResultClass gt  findAllByTypeAndObject String type  List lt Object gt

User · Answer

If your project used Spring-Boot  you can try to add this annotations at your  Application java    EnableJpaRepositories repositoryFactoryBeanClass CustomRepositoryFactoryBean class   SpringBootApplication  public class Application

User · Answer

I ran into this same issue and found the solution here  https   dzone com articles persistence-layer-spring-data  I had renamed an entity property  But with Springs Automatic Custom Queries there was an interface defined for the old property name    public interface IFooDAO extends JpaRepository lt  Foo  Long  gt        Foo findByOldPropName  final String name        The error indicated that it could no longer find  OldPropName  and threw the exception    To quote the article on DZone    When Spring Data creates a new Repository implementation  it analyzes all the methods defined by the interfaces and tries to automatically generate queries from the method name  While this has limitations  it is a very powerful and elegant way of defining new custom access methods with very little effort  For example  if the managed entity has a name field  and the Java Bean standard getter and setter for that field   defining the findByName method in the DAO interface will automatically generate the correct query   public interface IFooDAO extends JpaRepository lt  Foo  Long  gt        Foo findByName  final String name        This is a relatively simple example  a much larger set of keywords is supported by query creation mechanism   In the case that the parser cannot match the property with the domain object field  the following exception is thrown   java lang IllegalArgumentException  No property nam found for type class org rest model Foo

User · Answer

Please Check property name in the defualt call of repo e i repository findByUsername username

User · Answer

Since your JPA repository name is UserBoardRepository  your custom Interface name should be UserBoardRepositoryCustom  it should end with  Custom   and your implementation class name should be UserBoardRepositoryImpl  should end with Impl  you can set it with a different postfix using the repository-impl-postfix property

User · Answer

it looks like your custom JpaRepository method name does not match any Variable in your entity classs  Make sure your method name matches a variable in your entity class for example  you got a variable name called  quot active quot  and your custom JpaRepository method says  quot findByActiveStatus quot  and since there is no variable called  quot activeStatus quot  it will throw quot PropertyReferenceException quot

User · Answer

Your naming is not correct   As per the documentation  if your repository is UserBoardRepository  the implementation of your custom repository should be name as UserBoardRepositoryImpl  here you named it as BoardServiceImpl  that s why it throws the exception

[java] Spring Data JPA - "No Property Found for Type" Exception

Examples related to java

Examples related to jpa

Examples related to spring-data-jpa