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 -~----------~----~----~----~------~----~------~--~---
