Can you tell me where I can locate ExadelRestXpress.zip or do you no longer provide this installer?

[John T]

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.

[Maryna Brodina]

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

[Alexandr Ancipov]

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