D2RQException: Database exception (E43)

[R Wiethorn]

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

[Mark Graham]

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

--
-- 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
topbrai...@googlegroups.com
To unsubscribe from this group, send email to
topbraid-user...@googlegroups.com
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 topbraid-user...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Thanks,
Mark


Mark Graham
TopQuadrant Support

*PRODUCT SUPPORT:*

Help...@topquadrant.com
http://www.topquadrant.com/products/support.html

[R Wiethorn]

Hi Mark,

Sorry for the delay in response,

My version:

Version: 4.3.1.v20131101-1317R

[Mark Graham]

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

[R Wiethorn]

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?

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 topbraid-user...@googlegroups.com.

[Mark Graham]

Hi Rocky,

Not sure where you got the script. But can you upload it here to compare/review it?

[Wiethorn, Robert]

I got it from Scott Henninger

[Mark Graham]

Thanks Rocky.  Will check this out and update.

[Mark Graham]

Hi Rocky,

Can you try the attached script (tested here). Thanks,

On Thu, Jan 16, 2014 at 11:36 AM, Wiethorn, Robert <wieth...@pg.com> wrote:

[Scott Henninger]

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

To unsubscribe from this group and all its topics, send an email to topbraid-use...@googlegroups.com.