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]> 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]> 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] >> 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] > 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 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]. > 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] 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.
