Paul, I believe TopBraid Composer (at least 2.6.2) has the latest Oracle Jena driver, because it works for us (and I haven't heard other problem reports yet).
Regards Holger On Nov 19, 2008, at 4:51 PM, Paul wrote: > > Yes, the first link to the Oracle forum was the source of my original > question as it appears I may need another patch. It appears that > there are patches for 11g itself and patches for the Jena adaptor, > which I believe are separate. It might be helpful to post these > patches on the TBC forum in the future. I will try to locate. > Thanks. > > On Nov 19, 4:35 pm, Scott Henninger <[EMAIL PROTECTED]> > wrote: >> Paul; It doesn't matter which serialization format you use >> (i.e .owl, .n3, etc.). Oracle will store the data in their native >> format and the Composer/Oracle interface takes care of translation. >> RDF/XML-ABBREV, N3, N-TRIPLE, etc. are text serializations of and RDF >> data store. >> >> My question was more on the origins of the ontology and everything is >> good along that line. (and sorry for my typos! gads!) >> >> The basic error you have "component <xyz> must be declared" is an >> Oracle error resulting from a stored procedure not being defined. >> The >> issue may be that your patches have not been installed properly, >> including the stored procedure 'ANALYZE_MODEL'. There is a slight >> chance that the problem is with user permissions, but between the >> fact >> that the model was created in Composer and the specific name of the >> stored procedure, I rather doubt that. >> >> It is much more likely that the patch is the cause of the problem. >> This is a link to an Oracle forum to a TBC user with a similar >> problem >> on 10g: >> http://forums.oracle.com/forums/thread.jspa? >> threadID=664928&tstart=30 >> >> There is also a nice writeup on Oracle titled "Oracle Semantic >> Technologies Inference Best Practices with RDFS/OWL" >> http://www.oracle.com/technology/tech/semantic_technologies/pdf/seman >> ... >> >> This was a nice find for me, so maybe it can help if you didn't know >> about it. >> -- Scott >> >> On Nov 19, 5:51 pm, Paul <[EMAIL PROTECTED]> wrote: >> >> >> >>> I created it from scratch as an OWL file using TBC and I am using >>> the >>> native export option to load into Oracle directly. It is in RDF/ >>> XML- >>> ABBREV format. Now that you mention this, I thought I did read that >>> 11g requires models in N3 format. Is this accurate and if so, would >>> there be any loss to current functionality in TBC if I switch it to >>> a .N3 format? I would be interested in also understanding best >>> practices around which format to use in general. For >>> example....keeping it in .N3 format allows me to leverage any of the >>> current triples stores on the market, etc... >> >>> Thanks. >> >>> On Nov 19, 2:35 pm, Scott Henninger <[EMAIL PROTECTED]> >>> wrote: >> >>>> Payl; Hoe did you create the model (.owl/.n3 file) and what is the >>>> query you are trying to run? Some of those forums are about Jena >>>> SDB >>>> and I didn't get the impression you were using that. >>>> -- Scott >> >>>> On Nov 19, 4:08 pm, Paul <[EMAIL PROTECTED]> wrote: >> >>>>> No error messages in the log and I did verify that I have the >>>>> latest >>>>> patch for 11g. I can successfully query via SQL and the Oracle >>>>> console, so no worries there. However, I do get a message in the >>>>> error log when I try to export an owl file to my Oracle instance >>>>> using >>>>> TBC. I have already performed all of the necessary steps to RDF >>>>> enable 11g and can add triples via the SQL console. TBC fails >>>>> with >>>>> the message below: >> >>>>> java.sql.SQLException: ORA-06550: line 1, column 21: >>>>> PLS-00302: component 'ANALYZE_MODEL' must be declared >>>>> ORA-06550: line 1, column 7: >>>>> PL/SQL: Statement ignored >> >>>>> at oracle.jdbc.driver.SQLStateMapping.newSQLException >>>>> (SQLStateMapping.java:70) >>>>> at >>>>> oracle >>>>> .jdbc.driver.DatabaseError.newSQLException(DatabaseError.java: >>>>> 110) >>>>> at oracle.jdbc.driver.DatabaseError.throwSqlException >>>>> (DatabaseError.java:171) >>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) >>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) >>>>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) >>>>> at oracle.jdbc.driver.T4CCallableStatement.doOall8 >>>>> (T4CCallableStatement.java:191) >>>>> at oracle.jdbc.driver.T4CCallableStatement.executeForRows >>>>> (T4CCallableStatement.java:944) >>>>> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout >>>>> (OracleStatement.java:1222) >>>>> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal >>>>> (OraclePreparedStatement.java:3381) >>>>> at oracle.jdbc.driver.OraclePreparedStatement.execute >>>>> (OraclePreparedStatement.java:3482) >>>>> at oracle.jdbc.driver.OracleCallableStatement.execute >>>>> (OracleCallableStatement.java:3839) >>>>> at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute >>>>> (OraclePreparedStatementWrapper.java:1085) >>>>> at oracle.spatial.rdf.client.jena.GraphOracleSem.analyze >>>>> (GraphOracleSem.java:2863) >>>>> at >>>>> org >>>>> .topbraidcomposer >>>>> .oracle.wizards.export.OracleExportWizardPlugin.perform Finish >>>>> (OracleExportWizardPlugin.java:83) >>>>> at org.topbraidcomposer.wizards.export.ExportWizard$1.run >>>>> (ExportWizard.java:117) >>>>> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run >>>>> (ModalContext.java:121) >> >>>>> In searching the web, Oracle forums note this as an issue in the >>>>> Jena >>>>> adapter, requiring a patch. Before I pursue this option, I >>>>> would like >>>>> to understand whether TBC already has the latest patches for >>>>> Jena and >>>>> if not, where can I locate the latest. Thanks in advance. >> >>>>> On Nov 19, 11:10 am, Holger Knublauch <[EMAIL PROTECTED]> >>>>> wrote: >> >>>>>> Are there any more details in the error log (Window > Show View). >>>>>> Also, do you have all relevant patches for Oracle 11g's RDF >>>>>> support >>>>>> installed? >> >>>>>> Holger >> >>>>>> On Nov 19, 2008, at 11:02 AM, Paul wrote: >> >>>>>>> I was sucessful in creating a connection to Oracle 11g and >>>>>>> when I >>>>>>> click the .oracle file in my TBC project, it appears that it >>>>>>> automatically connects. Upon connection, I get the same message >>>>>>> repeating in the console. >> >>>>>>> Could not perform query >> >>>>>>> Has anyone encountered this and should I be concerned? I can >>>>>>> successfully execute SQL using the Oracle console, so that >>>>>>> appears to >>>>>>> be working. Thanks in advance.- Hide quoted text - >> >>>>>> - Show quoted text -- Hide quoted text - >> >>>> - Show quoted text -- Hide quoted text - >> >> - Show quoted text - > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TopBraid Composer Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/topbraid-composer-users?hl=en -~----------~----~----~----~------~----~------~--~---
