Hi -
I'm trying to install DSpace 1.5 using Oracle. It wasn't until
yesterday that I saw this in the KNOWN_BUGS file:
"Oracle compatibility: this release does not support Oracle. Check for
patches or updates to this release to restore Oracle compatibility."
But nevertheless, I thought I had read that people had done successful
installs using Oracle, and I wound up also getting it installed OK, but
now I'm running into a problem in the eperson code when I click the
"People" link under "Access Control."
Specifically, I get this exception:
java.sql.SQLException: ORA-00920: invalid relational operator
and looking through the stack trace, it appears to be coming from
org.dspace.eperson.EPerson.searchResultCount(EPerson.java:326)
where it says
TableRow row = DatabaseManager.querySingle(context,
"SELECT count(*) as count FROM eperson WHERE
eperson_id = ? OR " +
"firstname ILIKE ? OR lastname ILIKE ? OR email
ILIKE ?",
new Object[]
{int_param,dbquery,dbquery,dbquery});
I'm pretty sure "ILIKE" doesn't work in Oracle, but I see this in the
1.4.2 code and I'm pretty sure I was able t create some users in that.
Does anybody have any idea about what's wrong here?
Thanks,
Rick Runyan
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech