Spring Data findBy Enum

Question

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

@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;
}

}


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:

domain.Authority findByAuthority(enums.Authority authority);

i get next exceptions:

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

axtavt · Accepted Answer · 2013-07-05 15:33:20Z

4

select top ? ... is certainly not a valid query for MySQL.

Check SQL dialect setting in your Hibernate configuration.

answered Jul 5, 2013 at 15:33

axtavt

243k42 gold badges518 silver badges486 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1827052 Over a year ago

Ah YES, THANKS A LOT! I had HSQLDialect as a dialect!

Collectives™ on Stack Overflow

Spring Data findBy Enum

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related