Ok... I think i've traced it down a bit. In JDBCGroupProvider.java there's this function:
private Collection<JID> getMembers(String groupName, boolean adminsOnly) {
List<JID> members = new ArrayList<JID>();
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
con = DriverManager.getConnection(connectionString);
if (adminsOnly) {
&n bsp; if (loadAdminsSQL == null) {
&n bsp; return members;
&n bsp; }
&n bsp; pstmt = con.prepareStatement(loadAdminsSQL);
}
else {
&n bsp; pstmt = con.prepareStatement(loadMembersSQL);
}
pstmt.setString(1, groupName);
rs = pstmt.executeQuery();
while (rs.next()) {
&n bsp; String user = rs.getString(1);
&n bsp; if (user != null) {
&n bsp; JID userJID;
&n bsp; if (user.contains("@")) {
&n bsp; userJID = new JID(user);
&n bsp; }
&n bsp; else {
&n bsp; userJID = server.createJID(user, null);
&n bsp; }
&n bsp; members.add(userJID);
&n bsp; }
}
}
catch (SQLException e) {
Log.error(e);
}
finally {
DbConnectionManager.closeConnection(rs, pstmt, con);
}
return members;
}
Where can I find out the value for loadMembersSQL ? I'm curious what the SQL statement is.
