Cannot load tables from SQL Server 2014

Questions and answers regarding general SQL and backend databases

Cannot load tables from SQL Server 2014

Postby Ruben79 » Thu Sep 03, 2015 1:50 pm

When I try to connect to a locally installed SQL Server 2014 instance, I'm unable to see any tables.
Using the freedts driver, the connection can be made using this url:
Code: Select all
jdbc:jtds:sqlserver://localhost;DatabaseName=Donaties

But no tables are shown in Solution Explorer. I can however, create a table from Servoy and it will get made in Sql Server. Unfortunately, this table is not visible anymore after a restart.
In the server log, there's this line:
Code: Select all
Final get connection failure for server donaties in 1 times


Using the Microsoft driver, I cannot get a valid connection however it can be saved, and Servoy asks to restart.
Code: Select all
jdbc:sqlserver://localhost;databaseName=Donaties;


It has a red cross through the server icon and in the server log this message appears:
Code: Select all
com.servoy.j2db.persistence.RepositoryException: com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
       at com.servoy.j2db.server.Za.Zo.Za(Zo.java:687)
       at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:770)
       at com.servoy.j2db.server.Za.Zo.getTableAndViewNames(Zo.java:1201)
       at com.servoy.j2db.server.Za.Zo.getTableAndViewNames(Zo.java:862)
       at com.servoy.eclipse.model.repository.DataModelManager.reloadAllColumnInfo(DataModelManager.java:427)
       at com.servoy.eclipse.model.repository.DataModelManager$2.serverAdded(DataModelManager.java:199)
       at com.servoy.j2db.server.Za.Zc.Za(Zc.java:459)
       at com.servoy.j2db.server.Za.Zc.Za(Zc.java:51)
       at com.servoy.j2db.server.Za.Zc.createServer(Zc.java:148)
       at com.servoy.eclipse.core.DeveloperServerConfigSyncer.serverConfigurationChanged(DeveloperServerConfigSyncer.java:64)
       at com.servoy.j2db.server.Za.Zc.Za(Zc.java:269)
       at com.servoy.j2db.server.Za.Zc.saveServerConfig(Zc.java:470)
       at com.servoy.eclipse.ui.editors.ServerEditor.doSave(ServerEditor.java:505)
       at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:152)
       at org.eclipse.ui.internal.SaveableHelper$5.run(SaveableHelper.java:278)
       at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
       at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
       at org.eclipse.ui.internal.WorkbenchWindow$13.run(WorkbenchWindow.java:1829)
       at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
       at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:1826)
       at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:286)
       at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:265)
       at org.eclipse.ui.internal.SaveableHelper.savePart(SaveableHelper.java:157)
       at org.eclipse.ui.internal.WorkbenchPage.saveSaveable(WorkbenchPage.java:3772)
       at org.eclipse.ui.internal.WorkbenchPage.saveEditor(WorkbenchPage.java:3785)
       at org.eclipse.ui.internal.handlers.SaveHandler.execute(SaveHandler.java:53)
       at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)
       at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
       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.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
       at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)
       at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)
       at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
       at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)
       at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)
       at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
       at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)
       at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.executeCommand(KeyBindingDispatcher.java:285)
       at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.press(KeyBindingDispatcher.java:504)
       at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.processKeyEvent(KeyBindingDispatcher.java:555)
       at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.filterKeySequenceBindings(KeyBindingDispatcher.java:376)
       at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.access$0(KeyBindingDispatcher.java:322)
       at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher$KeyDownFilter.handleEvent(KeyBindingDispatcher.java:84)
       at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
       at org.eclipse.swt.widgets.Display.filterEvent(Display.java:1262)
       at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1056)
       at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1081)
       at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1066)
       at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1108)
       at org.eclipse.swt.widgets.Text.sendKeyEvent(Text.java:1726)
       at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1104)
       at org.eclipse.swt.widgets.Widget.wmChar(Widget.java:1525)
       at org.eclipse.swt.widgets.Control.WM_CHAR(Control.java:4723)
       at org.eclipse.swt.widgets.Text.WM_CHAR(Text.java:2611)
       at org.eclipse.swt.widgets.Control.windowProc(Control.java:4611)
       at org.eclipse.swt.widgets.Text.windowProc(Text.java:2597)
       at org.eclipse.swt.widgets.Display.windowProc(Display.java:4977)
       at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
       at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2549)
       at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
       at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
       at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
       at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
       at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)
       at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)
       at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
       at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
       at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
       at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
       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:354)
       at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
       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:636)
       at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
       at org.eclipse.equinox.launcher.Main.run(Main.java:1450)


Both drivers and connection strings work perfectly from dbVisualizer (JDBC database management tool).

I'm out of options, any ideas?
Ruben de Jong
Stb Software Development
SAN Partner

Stb Software Development - http://www.stb.nl
User avatar
Ruben79
 
Posts: 97
Joined: Wed Apr 18, 2007 12:43 pm

Re: Cannot load tables from SQL Server 2014

Postby Ruben79 » Thu Sep 03, 2015 2:03 pm

Of course, after trying for hours and hours I desperately decide to make a forum post.
And one minute later I just try to make another new database connection, to notice the Catalog and Schema properties are set to <none>.
My duplicated other ones were set to <empty>. Guess what.. It works (both freedts and microsoft driver) :roll:
Ruben de Jong
Stb Software Development
SAN Partner

Stb Software Development - http://www.stb.nl
User avatar
Ruben79
 
Posts: 97
Joined: Wed Apr 18, 2007 12:43 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 10 guests