Rocky; Hope that works better for you. It is the case that the previous script doesn't work well on Oracle. The one Mark sent should do better. There is another example in the Help files in Composer (search for D2RQ, and see the link buried just above the section named "Using D2RQ Databases as Triple Stores") and that should work in Oracle as well.
...or you can turn it loose on your own data. It's read-only and I'd suggest starting small. The wizard will step you through the tables/views and columns you want to map, and Composer's UI will by default grab only 1000 instances, so there even large databases can be explored with small effort using the tool suite. -- Scott On Thursday, January 16, 2014 4:15:06 PM UTC-5, Mark Graham wrote: > > Hi Rocky, > > Can you try the attached script (tested here). Thanks, > > > > > On Thu, Jan 16, 2014 at 11:36 AM, Wiethorn, Robert > <[email protected]<javascript:> > > wrote: > >> I got it from Scott Henninger >> >> >> >> >> >> >> >> *From:* [email protected] <javascript:> [mailto: >> [email protected] <javascript:>] *On Behalf Of *Mark Graham >> *Sent:* Thursday, January 16, 2014 11:17 AM >> *To:* [email protected] <javascript:> >> *Subject:* Re: [topbraid-users] D2RQException: Database exception (E43) >> >> >> >> Hi Rocky, >> >> >> >> Not sure where you got the script. But can you upload it here to >> compare/review it? >> >> >> >> On Thu, Jan 16, 2014 at 11:07 AM, R Wiethorn >> <[email protected]<javascript:>> >> wrote: >> >> Hi Mark, >> >> When I created the DB, I assigned PK and FKs. >> >> >> >> Initially I tried to make the DB MS SQL, however, I was not able to get >> the Jar file to work properly. >> >> The SQL Script that you sent me (I think it was you) didn't work in >> Oracle, so I manually created the DB. >> >> I'm able to access the data via SQL Developer (Oracle's) tool. >> >> >> >> Test connect at different DB, is that what you meant? >> >> >> >> On Thu, Jan 16, 2014 at 10:43 AM, Mark Graham >> <[email protected]<javascript:>> >> wrote: >> >> Hi Rocky, >> >> >> >> Couple things to check - D2RQ Connection wizard will often need primary >> keys to connect. Can you check that is available on the DB side. >> >> Also - can you test script other than movies - see results. >> >> >> >> Thanks, >> >> Mark >> >> >> >> On Thu, Jan 16, 2014 at 9:52 AM, R Wiethorn <[email protected]<javascript:>> >> wrote: >> >> Hi Mark, >> >> Sorry for the delay in response, >> >> My version: >> >> *Version: 4.3.1.v20131101-1317R* >> >> >> On Thursday, January 9, 2014 12:11:47 PM UTC-5, Mark Graham wrote: >> >> Hi Rocky, >> >> >> >> There have been similar known issues with D2RQ product in the past. What >> version of TBC are you running? (has odbc6.jar?) >> >> >> >> (Issue relates to D2RQ translation of SQL syntax.) >> >> >> >> On Thu, Jan 9, 2014 at 8:43 AM, R Wiethorn <[email protected]> wrote: >> >> Hello All, >> >> I'm trying to make a connection to my Oracle DB via the D2RQ Connection >> wizard. >> >> (See attached image) >> >> >> >> I think all is syntactically correct, as now I get a different error: >> D2RQException: Database exception (E43). >> >> >> >> Can someone try to explain this error. >> >> The text file also has the error message. >> >> >> >> For background, I manually created the DB in the Oracle. The sample >> Script was not compatible for the syntax. >> >> >> >> Thanks, >> >> Rocky >> >> >> >> >> >> de.fuberlin.wiwiss.d2rq.D2RQException: Database exception (E43) >> at >> de.fuberlin.wiwiss.d2rq.dbschema.DatabaseSchemaInspector.columnType(DatabaseSchemaInspector.java:78) >> at >> de.fuberlin.wiwiss.d2rq.mapgen.MappingGenerator.filter(MappingGenerator.java:604) >> at >> de.fuberlin.wiwiss.d2rq.mapgen.MappingGenerator.writeTable(MappingGenerator.java:285) >> at >> de.fuberlin.wiwiss.d2rq.mapgen.MappingGenerator.writeMapping(MappingGenerator.java:221) >> at >> de.fuberlin.wiwiss.d2rq.mapgen.MappingGenerator.writeMapping(MappingGenerator.java:179) >> at >> de.fuberlin.wiwiss.d2rq.mapgen.MappingGenerator.mappingModel(MappingGenerator.java:165) >> at >> org.topbraidcomposer.d2rq.wizard.D2RQOptions.generateModelsFromDB(D2RQOptions.java:296) >> at >> org.topbraidcomposer.d2rq.wizard.D2RQMetadataWizardPage.ensureLoad(D2RQMetadataWizardPage.java:225) >> at >> org.topbraidcomposer.d2rq.wizard.ImportD2RQWizard.performFinish(ImportD2RQWizard.java:66) >> at >> org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:827) >> at >> org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:432) >> at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624) >> at >> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754) >> at org.eclipse.jface.window.Window.runEventLoop(Window.java:825) >> at org.eclipse.jface.window.Window.open(Window.java:801) >> at >> org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:150) >> at >> org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:277) >> at >> org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:293) >> at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476) >> at >> org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508) >> at >> org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169) >> at >> org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241) >> at >> org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157) >> at >> org.eclipse.ui.internal.actions.CommandAction.run(CommandAction.java:171) >> at >> org.eclipse.ui.actions.ImportResourcesAction.run(ImportResourcesAction.java:97) >> at >> org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168) >> at >> org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584) >> at >> org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501) >> at >> org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754) >> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696) >> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660) >> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494) >> at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674) >> at >> org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) >> at >> org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667) >> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) >> at >> org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123) >> at >> org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) >> at >> org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) >> at >> org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) >> at >> org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344) >> at >> org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622) >> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577) >> at org.eclipse.equinox.launcher.Main.run(Main.java:1410) >> at org.eclipse.equinox.launcher.Main.main(Main.java:1386) >> Caused by: java.sql.SQLDataException: ORA-01424: missing or illegal >> character following the escape character >> >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) >> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) >> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) >> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) >> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) >> at >> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) >> at >> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) >> at >> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1199) >> at >> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) >> at >> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) >> at >> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628) >> at >> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493) >> at >> oracle.jdbc.driver.OracleDatabaseMetaData.getColumnsWithWildcards(OracleDatabaseMetaData.java:331) >> at >> oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:125) >> at >> de.fuberlin.wiwiss.d2rq.dbschema.DatabaseSchemaInspector.columnType(DatabaseSchemaInspector.java:59) >> ... 57 more >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> 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-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> >> -- >> Thanks, >> Mark >> >> >> Mark Graham >> TopQuadrant Support >> >> *PRODUCT SUPPORT:* >> >> [email protected] >> http://www.topquadrant.com/products/support.html >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] <javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> >> -- >> Thanks, >> Mark >> >> >> Mark Graham >> TopQuadrant Support >> >> *PRODUCT SUPPORT:* >> >> [email protected] <javascript:> >> http://www.topquadrant.com/products/support.html >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] <javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> >> You received this message because you are subscribed to a topic in the >> Google Groups "TopBraid Suite Users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/topbraid-users/Alvl3zmdzG0/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected] <javascript:>. >> >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] <javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> >> -- >> Thanks, >> Mark >> >> >> Mark Graham >> TopQuadrant Support >> >> *PRODUCT SUPPORT:* >> >> [email protected] <javascript:> >> http://www.topquadrant.com/products/support.html >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] <javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] <javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > Thanks, > Mark > > > Mark Graham > TopQuadrant Support > > *PRODUCT SUPPORT:* > > [email protected] <javascript:> > http://www.topquadrant.com/products/support.html > > > -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. 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-users?hl=en --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
