We have an trouble when install Dspace 5.6, JSPUI, Oracle 11g. An Internal
error at Eperson.java rows:518
public static EPerson[] findAll(Context context, int sortField)
throws SQLException
{
String s, t = "", theQuery = "";
switch (sortField)
{
case ID:
s = "e.eperson_id";
break;
case EMAIL:
s = "e.email";
break;
case LANGUAGE:
s = "m.text_value";
t = "language";
break;
case NETID:
s = "e.netid";
break;
default:
*s = "m.text_value";*
t = "lastname";
}
// NOTE: The use of 's' in the order by clause can not cause an SQL
// injection because the string is derived from constant values
above.
TableRowIterator rows;
if(!t.equals("")) {
rows = DatabaseManager.query(context,
"SELECT * FROM eperson e " +
"LEFT JOIN metadatavalue m on (m.resource_id =
e.eperson_id and m.resource_type_id = ? and m.metadata_field_id = ?) " +
"ORDER BY " + s,
Constants.EPERSON,
MetadataField.findByElement(context,
MetadataSchema.find(context, "eperson").getSchemaID(), t, null).getFieldID()
);
}
else {
* rows = DatabaseManager.query(context, "SELECT * FROM eperson e
ORDER BY " + s);*
}
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Maybe
* rows = DatabaseManager.query(context, "SELECT * FROM
eperson e ORDER BY " + s); *
can't work with s="m.text_value".
Please, can anyone help ??
--
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
