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