Hi Hardy & Richard, I'll readily admit that our Oracle support has been more difficult recently. The primary reason for this is that the Committer who was leading DSpace's Oracle support has moved on to a different role and no longer works with DSpace. So, at this point in time, we have no (zero) Committers who actively use Oracle in their workplace (at least none that I'm aware of, unless someone has switched recently).
Obviously, it is a concern to us that we no longer have anyone who is actively using Oracle. It also means we become much more dependent on the community members who use Oracle to report issues or problems (especially during Testathons & beta testing). The Committers do still attempt to do some basic Oracle testing before releases. But, sometimes this testing may not be as thorough as that provided by community members (as we may accidentally overlook testing of a particular feature, e.g. editing or adding e-people via XMLUI as Hardy reported in DS-841). Again, a large part of this is that none of our Committers run Oracle on a day-to-day basis, and we're all volunteers with a limited amount of time to devote to testing. So, to help ensure we are supporting Oracle fully, it'd be wonderful if those who use Oracle (and want to ensure it remains supported) can help out. Here's a few ways you can help: (1) Offer to install a Testathon DSpace instance backed by Oracle during our next Testathon. Currently, 'http://demo.dspace.org' (the primary Testathon server) is running on PostgreSQL as DuraSpace doesn't have an Oracle license, and we don't have an Oracle DB expert on staff. (2) Offer to download & test an Oracle-based DSpace install on your local servers during next Testathon/beta-testing & report back any issues you find before the final release (3) If you want, you can join the 'dspace-changelog' listserv to keep track of whether changes look to be Oracle specific or not. Alternatively, you could also just help test the latest Trunk code against Oracle every once in a while (and report back what you find). During development, the Committers are trying to ensure all patches/changes will work with Oracle (but obviously sometimes things slip through). So, in most cases, just testing the latest SVN Trunk code every once in a while should be good enough to locate any potential problems with the upcoming release. RE: 1.7.2 Release I'll talk to the Committers around whether we can push out a very minor 1.7.2 update just to fix DS-841. Are there any other known Oracle issues in DSpace 1.7.0/1.7.1 we should be resolving at the same time? Or is the only remaining Oracle issue the one described in DS-841? NOTE: At this point in time, the DSpace Committers actually were not planning a full 1.7.2 release to resolve any other issues. We had discussed a 1.7.2. But, we had tentatively decided against it, as we have 1.8.0 coming up in October and most of us are actively working hard on features to release in 1.8.0. *However*, we should be making sure that Oracle is *fully* supported in a 1.7.x release series (I know there were other Oracle issues we already fixed between 1.7.0 and 1.7.1). So, I would be willing to recommend a very small 1.7.2 release *just* to fix the remaining Oracle issue(s). So, Hardy & Richard, if you have found any other issues with 1.7.1, it'd be good to know so that we can release a working Oracle 1.7.x version in the near future. - Tim On 5/2/2011 12:33 PM, Pottinger, Hardy J. wrote: > Hi, Richard, I think what needs to happen is someone from our community of > Oracle installations needs to commit an Oracle-backed installation to the > next Testathon, to catch items like this. I am also going to try to do > more testing along the way. I think what we need to do as a community is > to be especially vigilant for patches that touch the classes that interact > with the database in any way, as this area of DSpace is particularly > important to our use of DSpace. > > I'd like to reach out to the more-experienced developers on this list: is > there a good way, besides "paying more attention" to follow the commits > and watch out for changes to the database classes? Do I need to just join > the commit mail list and set up a a filter in my mail client? Or is there > some better way to keep on top of these things? > > Also, Richard, this a very minor detail, but I am the reporter for DS-841, > Peter was kind enough to add a comment on my behalf, when I could not > figure out how to add one (I was home sick with a case of the flu on that > day, and I appreciate Peter's willingness to do that for me). > -- > HARDY POTTINGER<pottinge...@umsystem.edu> > University of Missouri Library Systems > http://lso.umsystem.edu/~pottingerhj/ > "No matter how far down the wrong road you've gone, > turn back." --Turkish proverb > > > > > > > On 5/2/11 8:59 AM, "Jizba, Richard"<richardji...@creighton.edu> wrote: > >> >> We have encountered the problem reported previously by Peter Dietz: >> http://dspace.2283337.n4.nabble.com/DuraSpace-JIRA-Created-DS-841-IllegalA >> rgumentException-No-such-column-rnum-error-in-DSpace-1-7-x-XML-td3381504.h >> tml >> ('IllegalArgumentException: No such column rnum' error in DSpace 1.7.x >> XMLUI admin eperson (with Oracle backend)) >> >> Any release date for 1.7.2? >> >> Also, in the older "Reference Theme", the simple solr statistics do not >> display. >> Look at: http://hdl.handle.net/10504/90 >> >> Any explanation for why the Oracle side has been so buggy with this >> version? This isn't helping my cause locally as a promoter of dspace. I >> am not a programmer, but I would be happy to beta-test the next version >> to catch any Oracle issues. >> >> Richard Jizba >> Health Sciences Library >> Creighton University >> (402) 280-5142 >> rji...@creighton.ed >> > > > ------------------------------------------------------------------------------ > WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
