Fixes are available
Rational Integration Tester Fix Pack 1 (8.6.0.1) for 8.6
Rational Test Virtualization Server Fix Pack 1 (8.6.0.1) for 8.6
Rational Performance Test Server Fix Pack 1 (8.6.0.1) for 8.6
Rational Integration Tester Fix Pack 2 (8.6.0.2) for 8.6
Rational Performance Test Server Fix Pack 2 (8.6.0.2) for 8.6
Rational Test Virtualization Server Fix Pack 2 (8.6.0.2) for 8.6
Rational Integration Tester Fix Pack 3 (8.6.0.3) for 8.6
Rational Performance Test Server Fix Pack 3 (8.6.0.3) for 8.6
Rational Test Virtualization Server Fix Pack 3 (8.6.0.3) for 8.6
Rational Integration Tester Fix Pack 4 (8.6.0.4) for 8.6
Rational Performance Test Server Fix Pack 4 (8.6.0.4) for 8.6
Rational Test Virtualization Server Fix Pack 4 (8.6.0.4) for 8.6
APAR status
Closed as program error.
Error description
If you attempt to add a table to a stub database and that table contains a reserved word such as "table" it fails with the error "incorrect syntax near keyword <reserved word>" The JVM console shows the following: com.ghc.ghTester.gui.dbstub.AbstractEditAction handleException WARNING: Action handing exception com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'table'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabase Error(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQ LServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStateme nt(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doEx ecute(SQLServerStatement.java:689) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:56 96) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand( SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(S QLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement (SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServe rStatement.java:662) at com.ghc.ghTester.gui.dbstub.AddTableWizardPanel.processCopyTable (AddTableWizardPanel.java:280) at com.ghc.ghTester.gui.dbstub.AddTableWizardPanel.process(AddTable WizardPanel.java:206) at com.ghc.ghTester.gui.dbstub.AbstractWizardPanel.processFinish(Ab stractWizardPanel.java:120) at com.ghc.wizard.Wizard$2.run(Wizard.java:580) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of Rational Integration Tester who are using JDBC * * (database) stubs. * **************************************************************** * PROBLEM DESCRIPTION: * * If a user attempts to add a database table to a JDBC * * (database) stub and that table contains columns whose names * * are reserved database words (such as "table" or "column") * * then an error will occur. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
This problem was caused because Rational Integration Tester was not recognizing the reserved words and didn't escape them correctly. This problem has been resolved in version 8.6.0.1 of RIT and tables containing reserved words as columns can now be added to JDBC stub.
Temporary fix
Comments
APAR Information
APAR number
PI18502
Reported component name
RATL INTEGRA TE
Reported component ID
5725G79IT
Reported release
851
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-05-22
Closed date
2014-09-01
Last modified date
2014-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
RATL INTEGRA TE
Fixed component ID
5725G79IT
Applicable component levels
R800 PSN
UP
R801 PSN
UP
R850 PSN
UP
R851 PSN
UP
R860 PSY
UP
Document Information
Modified date:
14 October 2021