Hi, we are currently running DSpace 1.5.1 (release install, not source) in production, with Oracle as our back end. A message thread from March 25, 2008 to the dspace-tech list identifies the same problem we're having (Oracle doesn't support PostgrSQL's ILIKE operator), and posts a solution (DB-agnostic SQL replacement for the ILIKE operator). I also see that SVN commit 2870, also made on March 25, asserts to solve this problem.
However, in our experience, running 1.5.1, we still see this error. A recap: in the XMLUI, when one clicks the "People" link under "Access Control", the following exception is thrown: java.sql.SQLException: ORA-00920: invalid relational operator if you look in the trace, the source of the exception is: at org.dspace.eperson.EPerson.searchResultCount(EPerson.java:326) So, my question is, did SVN commit 2870 get rolled back before 1.5.1 was released? To work around this issue, we've been using the JSPUI as an admin interface. Which actually is going to come in handy since we're in the process of implementing the Minho stats add-on, and that only supports a JSPUI interface. However, it has always bugged me that a big part of the XMLUI admin interface just dies whenever we try to use it. Are there any other institutions running DSpace and using Oracle for a back end that have noticed this behavior? What was your solution? -- HARDY POTTINGER <pottinge...@umsystem.edu> University of Missouri Library Systems http://lso.umsystem.edu/~hardy/ "No matter how far down the wrong road you've gone, turn back." --Turkish proverb ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
