Announcement Announcement Module
Collapse
No announcement yet.
findBy Enum Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • findBy Enum

    Hello Guys, i met such problem and don't know how to resolve it. Problem is next:
    I have next model

    Code:
    @Entity(name="Authority")
    @Table(name="AUTHORITIES")
    public class Authority implements GrantedAuthority {
    	
    	@Id
    	private long id;
    	
    	@Enumerated(EnumType.STRING)
    	@Column(name="authority")
    	private asdevelopment.action.enums.Authority authority;
    
    	/**
    	 * 
    	 */
    	private static final long serialVersionUID = 1L;
    
    	@Override
    	public String getAuthority() {
    		return authority.toString();
    	}
    
    	/**
    	 * @return the id
    	 */
    	public long getId() {
    		return id;
    	}
    
    }
    Code:
    public enum Authority {
    	
    	CLIENT_ROLE, ADMIN_ROLE;
    	
    }
    i can save authority and get by ID without any problems. But as soos as i call next method in repository:

    Code:
    domain.Authority findByAuthority(enums.Authority authority);
    i get next exceptions:

    Code:
    Hibernate: select top ? authority0_.id as id1_, authority0_.authority as authority1_ from AUTHORITIES authority0_ where authority0_.authority=?
    13:48:01.125  WARN [main] org.hibernate.engine.jdbc.spi.SqlExceptionHelper:143 - SQL Error: 1064, SQLState: 42000
    13:48:01.125 ERROR [main] org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2 authority0_.id as id1_, authority0_.authority as authority1_ from AUTHORITIES ' at line 1
    how to resolve it?

    Thanks a lot!
Working...
X