@Before
public void setup() {
Properties dsProps = loadDataSourceProperties();
pds = DataSourceFactory.setupPoolingDataSource("jdbc/jbpm-ds", dsProps);
prepareDb();
props = new Properties();
props.setProperty(DBUserInfoImpl.DS_JNDI_NAME, "jdbc/jbpm-ds");
props.setProperty(DBUserInfoImpl.NAME_QUERY, "select name from Users where userId = ?");
props.setProperty(DBUserInfoImpl.EMAIL_QUERY, "select email from Users where userId = ?");
props.setProperty(DBUserInfoImpl.LANG_QUERY, "select lang from Users where userId = ?");
props.setProperty(DBUserInfoImpl.HAS_EMAIL_QUERY, "select email from Groups where groupId = ?");
props.setProperty(DBUserInfoImpl.MEMBERS_QUERY, "select userId from Groups where groupId = ?");
props.setProperty(DBUserInfoImpl.ID_QUERY, "select userId from Users where email = ?");
}