Forum | Appery.io

In the RESTXpress User guide, it shows how to set up a User Role Query when using DB Authentication. Do you have an example of the role query? I created a query that simply returns the role(s) for the username. So the result set is just the "role id(s)"

RESTXpress keeps giving me an error when I test security.

java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.
String
at com.exadel.restxpress.security.DatabaseAuthenticationProvider.convertRoleResultSetToAuthorities(DatabaseAuthenticationProvider.ja

Any help would be appreciated.

Hello! I'll let you know when have more information. Sorry for delay.

Hi, John

Thanks for your questions.

1. We've tested this on Tomcat 7.0.39 on Win7 x64.

2. Here is the example of User Role Query:

   code
   select name
   from rolesAuth rolename
   inner join user_roles_auth ur
   inner join usersAuth
   where login=:username
   /code
   Result of User Role Query is set of role names or role name which should be equal to role defined in 'security configuration' option.

   Thanks, Alex