Search Mailing List Archives
[protege-discussion] Oracle DB project user privileges?
tredmond at stanford.edu
Thu Feb 7 16:04:30 PST 2008
The SQL Server is one of the databases that we generally support. At
the moment it is not being included in the nightly junits because
there is some problem. I am not sure why this is turning up now but
it will probably not be too hard to fix. The RobustConnection class
has several places where the configuration of the database can be
customized to accommodate a variety of differences with the behavior
of the different databases. We will probably look into this sometime
On Feb 6, 2008, at 3:04 AM, Jonathan Carter wrote:
> I forgot to ask, Timothy - any thoughts on my SQL Server 2005
> problem - see below*?
> We're seeing more and more of that at our clients and would really
> like to be in a position to support it.
> In the meantime, I'm using Oracle as a fallback as that particular
> client has both.
> Thanks very much for your help
> *Failed to create index for 'short_value' column because the index
> key exceeds the 900 byte limit. MS have posted a work-around
> 'solution' for indexing nvarchar columns.
> Jonathan Carter - Head of Technical Architecture
> Enterprise Architecture Solutions Ltd
> From: protege-discussion-bounces at lists.stanford.edu [mailto:protege-discussion-bounces at lists.stanford.edu
> ] On Behalf Of Timothy Redmond
> Sent: 05 February 2008 22:23
> To: User support for Core Protege and the Protege-Frames editor
> Subject: Re: [protege-discussion] Oracle DB project user privileges?
> How are things going with using Oracle? I don't know of any
> particular problems with running Oracle. The comment you found was
> written some time ago by Ray but I don't remember having to do
> anything with privileges. There was an issue with Oracle and a
> limitation of how long the value field can be but this was fixed
> relatively recently.
> On Jan 21, 2008, at 3:20 AM, Jonathan Carter wrote:
>> When I was looking in the problem I have with MS SQL Server 2005
>> (and I have to say, I lay that one at Microsoft's door...) I
>> noticed in the source code for the DatabaseFrameDb.java, a comment
>> in the code that says "For some bizarre reason on Oracle doing an
>> index on the function of a column requires that a user have an
>> obscure addition privelege on the database. Unfortunately this
>> privelege is disabled by default."
>> This is a comment on the createIndexOnLowerValue() method of
>> OK, my question is: What is this obscure addition privilege for the
>> user that I need to know about?
>> What are the things that I need to know in order to use Oracle as
>> the DB backend - beyond the standard, driver, URL, table, user name
>> and password?
>> Thanks for your help - any experiences of using Oracle as the
>> database would be great.
>> Jonathan Carter - Head of Technical Architecture
>> Enterprise Architecture Solutions Ltd
>> Web: www.enterprise-architecture.com
>> Assess your EA maturity at:
>> W O R L D C L A S S A R C H I T E C T U R E
>> protege-discussion mailing list
>> protege-discussion at lists.stanford.edu
>> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03
> protege-discussion mailing list
> protege-discussion at lists.stanford.edu
> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03
More information about the protege-discussion