Stuart; Thus far we have not been able to reproduce the problem. Is it the case that
your TQ license is up-to-date and that you
have re-started TBC-ME (multiple times, I
suspect)?
A potential issue is that the error message could
mean that the driver cannot be found or that
they syntax is not recognized by the driver. I.e. the message
could be somewhat misleading. In terms of the syntax, take a look at this MSDN article
to see if it helps:
http://msdn.microsoft.com/en-us/library/ms378428(v=sql.90).aspx
Let us know if you have any
success, and if you'd like someone to
contact you on troubleshooting, we'd be happy to do that.
-- Scott
On 6/18/2013 6:12 AM, Stuart Williams
wrote:
On Monday, 17 June 2013 17:09:22 UTC+1, Scott Henninger wrote:
Stuart;
Yes this has been resolved in TBS 4.2.
Please place the attached jar file in the
dropins folder for TBC-ME
or a TBS server product.
For the connector information,
use the following:
Database URL:
jdbc:sqlserver://[server-name[\instanceName][:portNumber]];DatabaseName=[db-name][;other-property=value]
Driver Class:
com.microsoft.sqlserver.jdbc.SQLServerDriver
Give that a try and let us
know if that works for you. The trick may be that the class jar needs to be wrapped with some Equinox
metadata to work with the TBS
infrastructure.
-- Scott
Hello Scott,
I'm still suffering from this problem. I've attached a file
with some screenshots of the D2RQ form panels I filled in and
the response I received on hitting 'next'. For good measure you
can see that I've also deployed the sqlserver.jar file exactly
as you suggested :-(. The detail from the error message is below
- and seems indicate a failure to either find or load the jdbc
driver.
Still stuck.
Stuart
--
An error has occurred. See error log for more details.
Cannot determine and instantiate SQL Driver. This SQL Driver
may or may not be supported. However, you may still try again by
placing driver file into folder C:\tbc-me-4.2.1\dropins\ and
restarting TopBraid.
Database connection to
jdbc:sqlserver://localhost:51723;DatabaseName=ICM-RFF failed
(user: cps): No suitable driver found for
jdbc:sqlserver://localhost:51723;DatabaseName=ICM-RFF (E54)
On 6/12/2013 11:42 AM, Stuart Williams wrote:
Scott,
Has this problem been resolved. I have exactly the same
problem using both TBC-ME 3.7.0 and 4.2.1 (both 64 bit
versions).
Many thanks
Stuart Williams.
--
On Friday, 25 January 2013 22:40:56 UTC, Scott Henninger
wrote:
Jonas; We have confirmed this as a
defect and are targeting the next
release for a fix. This should be next month and we will
announce
here.
In the meantime, you can use other data back-ends that we
support -
see http://www.topquadrant.com/products/supportedPlatforms4.1.html
-- Scott
On Jan 20, 5:50 pm, Jonas <[email protected]>
wrote:
> Hi Scott,
>
> Im using SQL 2008.
>
> heres the full TBC Errorlog in case I use the
Microsoft SQL Driver:
> de.fuberlin.wiwiss.d2rq.D2RQException: Cannot
determine and instantiate SQL
> Driver. This SQL Driver may or may not be supported.
However, you may still
> try again by placing driver file into folder
> C:\devSoftware\topbraid\dropins\ and restarting
TopBraid.
>
> Database connection to jdbc:sqlserver://[servername]:1433;databaseName=kti
> failed (user: sa): No suitable driver found for
> jdbc:sqlserver://[servername]:1433;databaseName=kti
(E54)
> at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connect(ConnectedDB.java:253)
> at
> de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connection(ConnectedDB.java:180)
> at
> de.fuberlin.wiwiss.d2rq.dbschema.DatabaseSchemaInspector.<init>(DatabaseSchemaInspector.java:47)
> at
> de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.schemaInspector(ConnectedDB.java:311)
> at
> de.fuberlin.wiwiss.d2rq.mapgen.MappingGenerator.<init>(MappingGenerator.java:79)
> at
> org.topbraidcomposer.d2rq.wizard.D2RQOptions.generateModelsFromDB(D2RQOptions.java:211)
> at
> org.topbraidcomposer.d2rq.wizard.D2RQMetadataWizardPage.ensureLoad(D2RQMetadataWizardPage.java:221)
> at
> org.topbraidcomposer.d2rq.wizard.D2RQMetadataWizardPage$1.handlePageChanging(D2RQMetadataWizardPage.java:172)
> at org.eclipse.jface.wizard.WizardDialog$10.run(WizardDialog.java:1602)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
> at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
> at
> org.eclipse.jface.wizard.WizardDialog.firePageChanging(WizardDialog.java:1600)
> at
> org.eclipse.jface.wizard.WizardDialog.doPageChanging(WizardDialog.java:929)
> at
> org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1218)
> at
> org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:915)
> at
> org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)
> 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.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.SQLException: No suitable driver
found for
> jdbc:sqlserver://[servername]:1433;databaseName=kti
> at java.sql.DriverManager.getConnection(Unknown
Source)
> at java.sql.DriverManager.getConnection(Unknown
Source)
> at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connect(ConnectedDB.java:209)
> ... 60 more
>
> do you need something else?
>
> And if I use the JTDS Driver this is the error
message in the log:
>
> de.fuberlin.wiwiss.d2rq.D2RQException: Cannot
instantiate SQL Driver
> net.sourceforge.jtds.jdbc.Driver: please place
driver file jtds.jar into
> folder C:\devSoftware\topbraid\dropins\ and
restart TopBraid.
>
> Database connection to jdbc:jtds:sqlserver://[servername]:1433/kti
failed
> (user: sa): No suitable driver found for
> jdbc:jtds:sqlserver://[servername]:1433/kti
(E54)
> at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connect(ConnectedDB.java:253)
> at
> de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connection(ConnectedDB.java:180)
> at
> de.fuberlin.wiwiss.d2rq.dbschema.DatabaseSchemaInspector.<init>(DatabaseSchemaInspector.java:47)
> at
> de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.schemaInspector(ConnectedDB.java:311)
> at
> de.fuberlin.wiwiss.d2rq.mapgen.MappingGenerator.<init>(MappingGenerator.java:79)
> at
> org.topbraidcomposer.d2rq.wizard.D2RQOptions.generateModelsFromDB(D2RQOptions.java:211)
> at
> org.topbraidcomposer.d2rq.wizard.D2RQMetadataWizardPage.ensureLoad(D2RQMetadataWizardPage.java:221)
> at
> org.topbraidcomposer.d2rq.wizard.D2RQMetadataWizardPage$1.handlePageChanging(D2RQMetadataWizardPage.java:172)
> at org.eclipse.jface.wizard.WizardDialog$10.run(WizardDialog.java:1602)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
> at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
> at
> org.eclipse.jface.wizard.WizardDialog.firePageChanging(WizardDialog.java:1600)
> at
> org.eclipse.jface.wizard.WizardDialog.doPageChanging(WizardDialog.java:929)
> at
> org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1218)
> at
> org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:915)
> at
> org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)
> 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.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)
|