On Monday, 24 June 2013 00:51:45 UTC+1, Scott Henninger wrote: > > 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)? >
Yes... AFAIK my license key is up-to-date and I have indeed restarted mutiple times, both TBC-ME and my whole PC. > > 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 > > I have a standalone installation of D2RQ on the same machine and the following works just fine: ./generate-mapping -w3c -u cps -p cps "jdbc:sqlserver://localhost:51723;databaseName=ICM-RFF" That's exactly the same jdbc: 'URL', username and password that I've been trying to use with TBC without success. > 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. > > That would be great... I'll respond offlist with some contact details. > -- Scott > Thanks, Stuart Williams -- > > 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 pr >> oduct. >> >> 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) >>> >>> >>> > 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 >>> > ... >>> > >>> > read 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 Ensemble, 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. >> >> >> >> >> -- > -- 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 Ensemble, 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 Ensemble, 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.
