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/semantic_infer_bestprac_wp.pdf 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.performFinish > > > (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 - > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
