[protege-discussion] Oracle backend

[Ulf Licht]

Hello Timothy,

thank you for your answer. I hope that the Oracle backend option does not 
go away completely. I see two basic alternatives to tackle the problem:
 
        a) Extend the KnownDatabase enum type with a "useNullValues" 
boolean flag and modify DefaultDatabaseFrameDb to honor it. One must not 
forget to add an additional null check in DatabaseUtils.getFrameId().
        b) Create an OracleDatabaseFrameDb, which extends 
DefaultDatabaseFrameDb. But how would one switch from one to another 
implementation of an AbstractDatabaseFrameDb? Is there a mechanism for it?

Scott, do you mind if your patch is publizised? Would you be so kind to 
provide the necessary information to Timothy?
Timothy, in which format do you want to receive/distribute the patch? Just 
the updated Java source files?

Regards,
Ulf








Timothy Redmond <tredmond at stanford.edu> 
Gesendet von: protege-discussion-bounces at lists.stanford.edu
24.02.2010 19:22
Bitte antworten an
User support for Core Protege and the Protege-Frames editor 
<protege-discussion at lists.stanford.edu>


An
User support for Core Protege and the Protege-Frames editor 
<protege-discussion at lists.stanford.edu>
Kopie

Thema
Re: [protege-discussion] Oracle backend







I had intended to reply to this earlier.  We no longer have an available
Oracle server running at Stanford and the nightly junits have not run
for some time.  For this reason the Oracle database backend has
gradually stopped working.  In fact currently the only two backends
being run on a nightly basis are those for the mysql and postgresql
database.

Unfortunately, it doesn't look like we can use the suggested patch
without some work.  An easier fix would have constrained itself to a
change to the KnownDatabase enum definition but I don't know if that is
possible.  If you like and you send me the working patch, I can make the
patch available on the wiki until we implement  a better fix.

-Timothy


On Wed, 2010-02-24 at 10:47 +0100, Ulf Licht wrote:
> Hi Scott,
> 
> thank you very much for providing your patch immediately! I am still 
> evaluating if I want to keep the Oracle database as backend (standard of 

> our IT Operations group) our if I setup a MySQL instance (would have to 
be 
> maintained by myself) because of the problem we encountered. If possible 
I 
> would like to keep going with Oracle because I want to focus on working 
> with Protege and not on operating a RDBMS.
> 
> I still can not believe that the Protege FAQ states that experience with 

> Oracle is given <http://protege.stanford.edu/doc/faq.html#05.01> but it 
> does not work out of the box. I would love to have your patch included 
in 
> a future release of Protege but do not know how to make this happen. I 
can 
> not even open a new bug in Bugzilla. Any ideas?
> 
> 
> Regarding your change to the class DefaultDatabaseFrameDb I encountered 
> the problem that a NullPointerException occured when trying to convert a 

> project from File to Database:
> 
> Thread [AWT-EventQueue-0] (Suspended (exception NullPointerException)) 
>         DatabaseUtils.getFrameId(ResultSet, int) line: 271 
>         DatabaseUtils.getFacet(ResultSet, int, FrameFactory, boolean) 
> line: 294 
>         DefaultDatabaseFrameDb.getFacet(ResultSet, int) line: 1135 
>         DefaultDatabaseFrameDb.getFrameValuesSQL(Frame) line: 952 
>         DefaultDatabaseFrameDb.getFrameValues(Frame) line: 915 
> 
> The problem seems to be that when requesting a Facet value from the 
> ResutSet it returns "null", which is now allowed in the DB after your 
> modification, and then the test for  "value.equals("")" in 
> DatabaseUtils.getFrameId(ResultSet, int) fails. After adding an 
additional 
> check for null it now works as expected. Did you modify this or other 
> parts of DatabaseUtils as well?
> 
> Regards,
> Ulf Licht
> 
> Integration Architect
> Enterprise Architecture Management
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> scott o <oswa at yahoo.com> 
> 12.02.2010 22:34
> 
> An
> Ulf Licht <Ulf.Licht at esprit.com>
> Kopie
> 
> Thema
> Re: Protege with Oracle backend
> 
> 
> 
> 
> 
> 
> Hi Ulf,
> 
> I don't know if a fix is planned and I did not submit a bug. However, 
> attached is the DefaultDatabaseFrameDb.java class as I modified it (it 
is 
> in the package edu.stanford.smi.protege.storage.database). I have been 
> using it consistently and without errors with Protege 3.4.1 
> (jdk1.6.0.0_06) (as part of an Essential Architect for modeling 
enterprise 
> architecture). It should compile with the 3.4.3 source. I have also 
> attached the protege.jar file from my last compile - it  might require 
> Protege 3.4.1, but will certainly require jdk1.6.0.0_06.
> Glad someone else may use the code...
> 
> - Scott
> From: Ulf Licht <Ulf.Licht at esprit.com>
> To: oswa at yahoo.com
> Sent: Fri, February 12, 2010 8:50:09 AM
> Subject: Protege with Oracle backend
> 
> Hello Scott,
> 
> I read your bug report regarding the Oracle backend on the 
> [protege-discussion] list with great interest since we recently stumbled 

> over the same problem when trying to use an Oracle database as the 
backend 
> 
> for an Protege 3.4.3 project.
> 
> <
> 
https://mailman.stanford.edu/pipermail/protege-discussion/2009-July/003360.html

> >
> 
> Do you know if your modification will be included in a future release of 

> Protege? The bug still exists in version 3.4.3. Were you able to open a 
> Bugzilla ticket for it <http://smi-protege.stanford.edu/bugzilla>? I did 

> register but am not able to open a new bug.
> 
> Would you mind sharing your modification with us? Do you have a compiled 

> version of Protege 3.4.3 including your fix? Otherwise I could try to 
> build it myself.
> 
> Thank your very much,
> 
> Ulf Licht
> Integration Architect
> Enterprise Architecture
> 
> 
> 
> 
> Esprit Europe GmbH
> Esprit-Allee
> 40882 Ratingen
> 
> P.O. Box:
> Esprit Europe GmbH
> 40842 Ratingen
> 
> t +49 2102 123-0
> f +49 2102 123-45100
> i www.esprit.com
> 
> Amtsgericht Düsseldorf,
> HRB 28967, VAT-ID: DE 162905814
> Geschäftsführer: Heinz Krogner, Ernst-Peter Vogel, Jürgen Haas, Dr. 
Michael Niklas, Ronald van der Vis
> 
> Confidential Notice: The information in this document is confidential. 
It is intended only for the use of the named recipient. Internet 
communications are not secure and therefore our Company does not accept 
legal responsibility for the contents of this message. If you are not the 
intended recipient  please notify us immediately and then delete this 
document.
> 
> Please consider your environmental responsibility before printing this 
e-mail
> _______________________________________________
> 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

_______________________________________________
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





Esprit Europe GmbH
Esprit-Allee
40882 Ratingen

P.O. Box:
Esprit Europe GmbH
40842 Ratingen

t +49 2102 123-0
f +49 2102 123-45100
i www.esprit.com

Amtsgericht Düsseldorf,
HRB 28967, VAT-ID: DE 162905814
Geschäftsführer: Heinz Krogner, Ernst-Peter Vogel, Jürgen Haas, Dr. Michael Niklas, Ronald van der Vis

Confidential Notice: The information in this document is confidential. It is intended only for the use of the named recipient. Internet communications are not secure and therefore our Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient  please notify us immediately and then delete this document.

Please consider your environmental responsibility before printing this e-mail