Skip to Content
avatar image
Former Member

SQL server configuration in SUP

Hi Friends,

I have an requirement, Configure Microsoft SQL server in SUP. I downloaded sqljdbc4.jar file from website and pasted to "C:\Sybase\UnwiredPlatform\Unwired_WorkSpace\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.sqlserver_2.0.0.201105030306\lib" and "C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\lib\3rdparty". When am i creating data base connection ping is successfull, but when open the database in enterprise explorer in sybase unwired workspace it gives an error "com.microsoft.sqlserver.jdbc.SQLServerException". The data base tree shows only Aurthroized id's and catalogs.

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '7000.'.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)

at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)

at org.eclipse.datatools.connectivity.sqm.internal.core.connection.StatementAdapter.executeQuery(Unknown Source)

at org.eclipse.datatools.enablement.msft.internal.sqlserver.loaders.SQL2005SchemaLoader.createResultSet(SQL2005SchemaLoader.java:53)

at org.eclipse.datatools.connectivity.sqm.loader.JDBCSchemaLoader.loadSchemas(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCCatalog.loadSchemas(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCCatalog.getSchemas(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.vnode.ServerExplorerVNodeContentProviderNav.displaySchemaNodeChildren(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractLayoutProviderNav.getChildren(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.impl.ServerExplorerContentProviderNav.load(Unknown Source)

at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.impl.ServerExplorerContentProviderNav.getChildren(Unknown Source)

at org.eclipse.datatools.connectivity.ui.CommonContentProviderBase.getChildren(Unknown Source)

at org.eclipse.ui.internal.navigator.extensions.SafeDelegateTreeContentProvider.getChildren(SafeDelegateTreeContentProvider.java:96)

at org.eclipse.ui.internal.navigator.extensions.SafeDelegateTreeContentProvider.getChildren(SafeDelegateTreeContentProvider.java:275)

at org.eclipse.ui.internal.navigator.extensions.SafeDelegateTreeContentProvider.getChildren(SafeDelegateTreeContentProvider.java:94)

at org.eclipse.ui.internal.navigator.NavigatorContentServiceContentProvider$1.run(NavigatorContentServiceContentProvider.java:150)

at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)

at org.eclipse.ui.internal.navigator.NavigatorContentServiceContentProvider.internalGetChildren(NavigatorContentServiceContentProvider.java:137)

at org.eclipse.ui.internal.navigator.NavigatorContentServiceContentProvider.getChildren(NavigatorContentServiceContentProvider.java:123)

at org.eclipse.jface.viewers.AbstractTreeViewer.getRawChildren(AbstractTreeViewer.java:1348)

at org.eclipse.jface.viewers.TreeViewer.getRawChildren(TreeViewer.java:391)

at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:896)

at org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:601)

at com.sybase.stf.servers.ui.views.EnterpriseExplorerViewer.getSortedChildren(Unknown Source)

at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:799)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:778)

at org.eclipse.jface.viewers.TreeViewer.createChildren(TreeViewer.java:644)

at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:749)

at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:1444)

at org.eclipse.jface.viewers.TreeViewer.handleTreeExpand(TreeViewer.java:952)

at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:1455)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:132)

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.Widget.sendEvent(Widget.java:1077)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1062)

at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:7408)

at org.eclipse.swt.widgets.Control.wmNotify(Control.java:5096)

at org.eclipse.swt.widgets.Composite.wmNotify(Composite.java:1887)

at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4726)

at org.eclipse.swt.widgets.Control.windowProc(Control.java:4215)

at org.eclipse.swt.widgets.Display.windowProc(Display.java:4873)

at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)

at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:2362)

at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:1536)

at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:6303)

at org.eclipse.swt.widgets.Control.windowProc(Control.java:4195)

at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:5844)

at org.eclipse.swt.widgets.Display.windowProc(Display.java:4886)

at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)

at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2459)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3655)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)

at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)

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:369)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)

at org.eclipse.equinox.launcher.Main.run(Main.java:1407)

at org.eclipse.equinox.launcher.Main.main(Main.java:1383)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 11, 2012 at 11:56 AM

    Hi Satyha,

    I have a requirement to connect MSSQL DB from SUP as well. May i know whether you have any solutions for this ?

    Regards

    Choong

    Add comment
    10|10000 characters needed characters exceeded