Hi, I thought I'd bump this, and try a rephrase. See below for details, but I'd really like to know if anyone is using DSpace 1.5.1, with Oracle as the back end db, and the XMLUI as an interface? If so, I'd like to know if you've encountered the behavior detailed below, and if so, are you living with the behavior, or did you come up with a solution? Our approach has been to use XMLUI as a public interface and JSPUI as our admin interface. But, I'd love to have the XMLUI as an option for an admin interface.
--Hardy > -----Original Message----- > From: Pottinger, Hardy J. [mailto:pottinge...@umsystem.edu] > Sent: Thursday, April 16, 2009 5:06 PM > To: dspace-tech@lists.sourceforge.net > Subject: [Dspace-tech] Oracle and DSpace 1.5.1 and "ILIKE" (again) > > 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 ------------------------------------------------------------------------------ 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
