I configured my App to use the DataSourceUserManager. According to 
orionsupport and Orion API I added the following text to my 
orion-application.xml:

<user-manager class="com.evermind.sql.DataSourceUserManager">
       <property name="table" value="users" />
       <property name="usernameField" value="username" />
       <property name="passwordField" value="password" />
       <property name="defaultGroups" value="users" />
       <property name="groupMembershipTableName" value="user_groups" />
       <property name="groupMembershipGroupFieldName" value="groupname" />
       <property name="groupMembershipUsernameFieldName" value="username" />
       <property name="dataSource" value="jdbc/DefaultDS" />
       <property name="staleness" value="1000" />
       <property name="debug" value="true" />
 </user-manager>

In my DBMS I did the following:

create table user_groups (username varcharg, roupname varchar);
create table users (username varchar,password varchar);

Adding a new User with:
        Principal user = roleManager.createPrincipal("userName","password");
works perfectly.

But when I do a: roleManager.addToRole(user,"aRole");
I get the following exception:

java.lang.RuntimeException: SQL error: No value specified for parameter 2.
        at java.lang.RuntimeException.<init>(RuntimeException.java:49)
        at com.evermind.sql.DataSourceUser.addToGroup(JAX)
        at com.evermind.server.hm.addToRole(JAX)

Using the default UserManager I don't get any exception.

Could anyone help me here?

Reply via email to