Former Member

Sep 17, 2011 at 06:42 AM

SQL server configuration in SUP

33 Views

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