Hi,
I think it worked in 1.4.2 only if you used the default jspui interface
(it doesn't call searchResultCount). Manakin/xmlui on the other hand
does call it, so it breaks.
I altered the code to be oracle friendly:
TableRow row = DatabaseManager.querySingle(context,
"SELECT count(*) as count FROM eperson WHERE eperson_id = ? OR " +
"lower(firstname) LIKE ? OR lower(lastname) LIKE ? OR lower(email) LIKE ?",
new Object[] {int_param,dbquery,dbquery,dbquery});
I assume that would work in postgres as well, but I haven't tested it.
You would also have to make a similar change in Group.java as well.
I haven't looked too closely at 1.5, but it works in 1.4.2.
Hope this helps.
-Greg
Rick Runyan wrote:
>
> 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
>
-------------------------------------------------------------------------
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
