IBM Support

Unable to create a Microsoft SQL Server database stub

Troubleshooting


Problem

JDBC stubs created in IBM Rational Integration Tester (RIT) do not contain any data when accessing Microsoft SQL Server tables with identity columns.

Symptom

You have setup the JDBC agent on top of your Java application.

Your application queries, as part of other columns, an identity column against your Microsoft SQL Server database.

You have created a valid database transport in IBM Rational Integration Tester (RIT) for the real and for your stub databases, both on Microsoft SQL Server.

You launch your recording in Recording Studio with options set to :

image-20190404103533-1

Your database stub is then not correctly created in Microsoft SQL Server.
The identity column in the stub database is not created, therefore the stub is not usable.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSBLQQ","label":"IBM Rational Test Workbench"},"Component":"Rational Integration Tester","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
29 May 2019

UID

ibm10879403

Page Feedback