Server-side Cursors Causes Hanging Connections In SequeLink Server For MS SQL Server
 Technote (troubleshooting)
 
Problem(Abstract)
Using DataDirect Technologies (formerly known as MERANT) SequeLink Server, the database connections remain hung after the application has disconnected. Over a period of time, this causes the system to freeze.
 
Cause
The problem is with the SequeLink server, where hanging processes are clearly visible on the SequeLink Console as well as MS SQL Server Query Analyzer.

There is no problem using the same application with SequeLink Server for Oracle
 
Resolving the problem
Switching from Serverside to Clientside cursors fixed the problem.
For SequeLink Server 5.1 for Microsoft SQL Server, the SequeLink Datasource attribute is called DataSourceMSSCursorType. It should be set to clientside.

1. Launch the SequeLink 5.1 Manager Snapin and navigate to the datasource.



2. Right click on datasource (Default in this example), select New, then select Attribute. From the New Attribute windows, select DataSourceMSSCursorType for Attribute, and select Clientside for the Value.


3. Click OK

4. Save the configuration

5. Restart the SequeLink service for SQL Server.

 
Related information
DataDirect JDBC Product Documentation
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
Product Alias/Synonym
Merant SequeLink Server
 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.1.1
Software edition:
Reference #: 1178130
IBM Group: Software Group
Modified date: Aug 28, 2004