SQL server configuration in SUP

[Former Member]

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)

[Former Member]

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

[Former Member]

Please refer to the following :

http://dcx.sybase.com/sup0211/en/com.sybase.infocenter.dc01283.0211/doc/html/asc1229701207667.html

My problem solve by paste the sqljdbc4.jar to the plugins\com.sybase.uep.com.sqlserver and make sure is using SQL Server JDBC driver 3.0.

Hope this can help.