[protege-discussion] Oracle DB project user privileges?

[Jonathan Carter]

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
 
Regards

Jonathan
 
*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.

-Timothy


On Jan 21, 2008, at 3:20 AM, Jonathan Carter wrote:


Hi,
 
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
DatabaseFrameDb.java.
 
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.
 
Regards 
 
Jonathan
 
_______________________________________

Jonathan Carter - Head of Technical Architecture
Enterprise Architecture Solutions Ltd
Web: www.enterprise-architecture.com
<http://www.enterprise-architecture.com/> 
_______________________________________

Assess your EA maturity at:
www.enterprise-architecture.com/EAvaluator
_______________________________________

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
https://mailman.stanford.edu/mailman/listinfo/protege-discussion

Instructions for unsubscribing:
http://protege.stanford.edu/doc/faq.html#01a.03 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20080206/7ed5e66d/attachment.html>